Forum Stats

  • 3,837,247 Users
  • 2,262,242 Discussions
  • 7,900,235 Comments

Discussions

Liquibase DB Migration failing for change set

User_87R1B
User_87R1B Member Posts: 1 Green Ribbon

I have spring boot app in gradle which uses Liquibase for its changesets.

when I try to run it I am facing issue while executing the below changeset:

```

<databaseChangeLog

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"

        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">


  <property name="blob_type" value="BYTEA" dbms="postgresql"/>

  <property name="blob_type" value="BLOB"/>


  <changeSet id="quartz-init" author="quartz">


    <createTable tableName="QRTZ_LOCKS">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="LOCK_NAME" type="VARCHAR(40)">

        <constraints nullable="false"/>

      </column>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, LOCK_NAME" tableName="QRTZ_LOCKS"/>


    <createTable tableName="QRTZ_FIRED_TRIGGERS">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="ENTRY_ID" type="VARCHAR(95)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_GROUP" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="INSTANCE_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="FIRED_TIME" type="BIGINT">

        <constraints nullable="false"/>

      </column>

      <column name="SCHED_TIME" type="BIGINT">

        <constraints nullable="false"/>

      </column>

      <column name="PRIORITY" type="INTEGER">

        <constraints nullable="false"/>

      </column>

      <column name="STATE" type="VARCHAR(16)">

        <constraints nullable="false"/>

      </column>

      <column name="JOB_NAME" type="VARCHAR(200)"/>

      <column name="JOB_GROUP" type="VARCHAR(200)"/>

      <column name="IS_NONCONCURRENT" type="BOOLEAN"/>

      <column name="REQUESTS_RECOVERY" type="BOOLEAN"/>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, ENTRY_ID" tableName="QRTZ_FIRED_TRIGGERS"/>


    <createIndex tableName="QRTZ_FIRED_TRIGGERS" indexName="IDX_QRTZ_FT_INST_JOB_REQ_RCVRY">

      <column name="SCHED_NAME"/>

      <column name="INSTANCE_NAME"/>

      <column name="REQUESTS_RECOVERY"/>

    </createIndex>


    <createIndex tableName="QRTZ_FIRED_TRIGGERS" indexName="IDX_QRTZ_FT_J_G">

      <column name="SCHED_NAME"/>

      <column name="JOB_NAME"/>

      <column name="JOB_GROUP"/>

    </createIndex>


    <createIndex tableName="QRTZ_FIRED_TRIGGERS" indexName="IDX_QRTZ_FT_JG">

      <column name="SCHED_NAME"/>

      <column name="JOB_GROUP"/>

    </createIndex>


    <createIndex tableName="QRTZ_FIRED_TRIGGERS" indexName="IDX_QRTZ_FT_T_G">

      <column name="SCHED_NAME"/>

      <column name="TRIGGER_NAME"/>

      <column name="TRIGGER_GROUP"/>

    </createIndex>


    <createIndex tableName="QRTZ_FIRED_TRIGGERS" indexName="IDX_QRTZ_FT_TG">

      <column name="SCHED_NAME"/>

      <column name="TRIGGER_GROUP"/>

    </createIndex>


    <createIndex tableName="QRTZ_FIRED_TRIGGERS" indexName="IDX_QRTZ_FT_TRIG_INST_NAME">

      <column name="SCHED_NAME"/>

      <column name="INSTANCE_NAME"/>

    </createIndex>


    <createTable tableName="QRTZ_CALENDARS">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="CALENDAR_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="CALENDAR" type="${blob_type}">

        <constraints nullable="false"/>

      </column>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, CALENDAR_NAME" tableName="QRTZ_CALENDARS"/>


    <createTable tableName="QRTZ_PAUSED_TRIGGER_GRPS">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_GROUP" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, TRIGGER_GROUP" tableName="QRTZ_PAUSED_TRIGGER_GRPS"/>


    <createTable tableName="QRTZ_SCHEDULER_STATE">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="INSTANCE_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="LAST_CHECKIN_TIME" type="BIGINT">

        <constraints nullable="false"/>

      </column>

      <column name="CHECKIN_INTERVAL" type="BIGINT">

        <constraints nullable="false"/>

      </column>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, INSTANCE_NAME" tableName="QRTZ_SCHEDULER_STATE"/>


    <createTable tableName="QRTZ_JOB_DETAILS">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="JOB_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="JOB_GROUP" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="DESCRIPTION" type="VARCHAR(250)"/>

      <column name="JOB_CLASS_NAME" type="VARCHAR(250)">

        <constraints nullable="false"/>

      </column>

      <column name="IS_DURABLE" type="BOOLEAN">

        <constraints nullable="false"/>

      </column>

      <column name="IS_NONCONCURRENT" type="BOOLEAN">

        <constraints nullable="false"/>

      </column>

      <column name="IS_UPDATE_DATA" type="BOOLEAN">

        <constraints nullable="false"/>

      </column>

      <column name="REQUESTS_RECOVERY" type="BOOLEAN">

        <constraints nullable="false"/>

      </column>

      <column name="JOB_DATA" type="${blob_type}"/>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, JOB_NAME, JOB_GROUP" tableName="QRTZ_JOB_DETAILS"/>


    <createIndex tableName="QRTZ_JOB_DETAILS" indexName="IDX_QRTZ_J_GRP">

      <column name="SCHED_NAME"/>

      <column name="JOB_GROUP"/>

    </createIndex>


    <createIndex tableName="QRTZ_JOB_DETAILS" indexName="IDX_QRTZ_J_REQ_RECOVERY">

      <column name="SCHED_NAME"/>

      <column name="REQUESTS_RECOVERY"/>

    </createIndex>


    <createTable tableName="QRTZ_TRIGGERS">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_GROUP" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="JOB_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="JOB_GROUP" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="DESCRIPTION" type="VARCHAR(250)"/>

      <column name="NEXT_FIRE_TIME" type="BIGINT"/>

      <column name="PREV_FIRE_TIME" type="BIGINT"/>

      <column name="PRIORITY" type="INTEGER"/>

      <column name="TRIGGER_STATE" type="VARCHAR(16)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_TYPE" type="VARCHAR(8)">

        <constraints nullable="false"/>

      </column>

      <column name="START_TIME" type="BIGINT">

        <constraints nullable="false"/>

      </column>

      <column name="END_TIME" type="BIGINT"/>

      <column name="CALENDAR_NAME" type="VARCHAR(200)"/>

      <column name="MISFIRE_INSTR" type="smallint"/>

      <column name="JOB_DATA" type="${blob_type}"/>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP" tableName="QRTZ_TRIGGERS"/>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_C">

      <column name="SCHED_NAME"/>

      <column name="CALENDAR_NAME"/>

    </createIndex>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_G">

      <column name="SCHED_NAME"/>

      <column name="TRIGGER_GROUP"/>

    </createIndex>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_JG">

      <column name="SCHED_NAME"/>

      <column name="JOB_GROUP"/>

    </createIndex>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_N_G_STATE">

      <column name="SCHED_NAME"/>

      <column name="TRIGGER_GROUP"/>

      <column name="TRIGGER_STATE"/>

    </createIndex>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_N_STATE">

      <column name="SCHED_NAME"/>

      <column name="TRIGGER_NAME"/>

      <column name="TRIGGER_GROUP"/>

      <column name="TRIGGER_STATE"/>

    </createIndex>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_NEXT_FIRE_TIME">

      <column name="SCHED_NAME"/>

      <column name="NEXT_FIRE_TIME"/>

    </createIndex>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_NFT_MISFIRE">

      <column name="SCHED_NAME"/>

      <column name="MISFIRE_INSTR"/>

      <column name="NEXT_FIRE_TIME"/>

    </createIndex>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_NFT_ST">

      <column name="SCHED_NAME"/>

      <column name="TRIGGER_STATE"/>

      <column name="NEXT_FIRE_TIME"/>

    </createIndex>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_NFT_ST_MISFIRE">

      <column name="SCHED_NAME"/>

      <column name="MISFIRE_INSTR"/>

      <column name="NEXT_FIRE_TIME"/>

      <column name="TRIGGER_STATE"/>

    </createIndex>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_NFT_ST_MISFIRE_GRP">

      <column name="SCHED_NAME"/>

      <column name="MISFIRE_INSTR"/>

      <column name="NEXT_FIRE_TIME"/>

      <column name="TRIGGER_GROUP"/>

      <column name="TRIGGER_STATE"/>

    </createIndex>


    <createIndex tableName="QRTZ_TRIGGERS" indexName="IDX_QRTZ_T_STATE">

      <column name="SCHED_NAME"/>

      <column name="TRIGGER_STATE"/>

    </createIndex>


    <createTable tableName="QRTZ_BLOB_TRIGGERS">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_GROUP" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="BLOB_DATA" type="${blob_type}"/>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP" tableName="QRTZ_BLOB_TRIGGERS"/>


    <createTable tableName="QRTZ_SIMPROP_TRIGGERS">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_GROUP" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="STR_PROP_1" type="VARCHAR(512)"/>

      <column name="STR_PROP_2" type="VARCHAR(512)"/>

      <column name="STR_PROP_3" type="VARCHAR(512)"/>

      <column name="INT_PROP_1" type="INTEGER"/>

      <column name="INT_PROP_2" type="INTEGER"/>

      <column name="LONG_PROP_1" type="BIGINT"/>

      <column name="LONG_PROP_2" type="BIGINT"/>

      <column name="DEC_PROP_1" type="NUMERIC(13,4)"/>

      <column name="DEC_PROP_2" type="NUMERIC(13,4)"/>

      <column name="BOOL_PROP_1" type="BOOLEAN"/>

      <column name="BOOL_PROP_2" type="BOOLEAN"/>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP"

            tableName="QRTZ_SIMPROP_TRIGGERS"/>


    <createTable tableName="QRTZ_CRON_TRIGGERS">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_GROUP" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="CRON_EXPRESSION" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="TIME_ZONE_ID" type="VARCHAR(80)"/>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP" tableName="QRTZ_CRON_TRIGGERS"/>


    <createTable tableName="QRTZ_SIMPLE_TRIGGERS">

      <column name="SCHED_NAME" type="VARCHAR(120)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_NAME" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="TRIGGER_GROUP" type="VARCHAR(200)">

        <constraints nullable="false"/>

      </column>

      <column name="REPEAT_COUNT" type="BIGINT">

        <constraints nullable="false"/>

      </column>

      <column name="REPEAT_INTERVAL" type="BIGINT">

        <constraints nullable="false"/>

      </column>

      <column name="TIMES_TRIGGERED" type="BIGINT">

        <constraints nullable="false"/>

      </column>

    </createTable>

    <addPrimaryKey columnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP"

            tableName="QRTZ_SIMPLE_TRIGGERS"/>


    <addForeignKeyConstraint baseTableName="QRTZ_TRIGGERS"

                 constraintName="QRTZ_TRIGGERS_SCHED_NAME_FKEY"

                 baseColumnNames="SCHED_NAME, JOB_NAME, JOB_GROUP"

                 referencedTableName="QRTZ_JOB_DETAILS"

                 referencedColumnNames="SCHED_NAME, JOB_NAME, JOB_GROUP"/>


    <addForeignKeyConstraint baseTableName="QRTZ_SIMPLE_TRIGGERS"

                 constraintName="QRTZ_SIMPLE_TRIGGERS_SCHED_NAME_FKEY"

                 baseColumnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP"

                 referencedTableName="QRTZ_TRIGGERS"

                 referencedColumnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP"/>


    <addForeignKeyConstraint baseTableName="QRTZ_CRON_TRIGGERS"

                 constraintName="QRTZ_CRON_TRIGGERS_SCHED_NAME_FKEY"

                 baseColumnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP"

                 referencedTableName="QRTZ_TRIGGERS"

                 referencedColumnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP"/>


    <addForeignKeyConstraint baseTableName="QRTZ_SIMPROP_TRIGGERS"

                 constraintName="QRTZ_SIMPROP_TRIGGERS_SCHED_NAME_FKEY"

                 baseColumnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP"

                 referencedTableName="QRTZ_TRIGGERS"

                 referencedColumnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP"/>


    <addForeignKeyConstraint baseTableName="QRTZ_BLOB_TRIGGERS"

                 constraintName="QRTZ_BLOB_TRIGGERS_SCHED_NAME_FKEY"

                 baseColumnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP"

                 referencedTableName="QRTZ_TRIGGERS"

                 referencedColumnNames="SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP"/>

  </changeSet>

</databaseChangeLog>

```



I am facing below issue :

```

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set db/changelog/db.changelog-quartz.xml::quartz-init::quartz:

   Reason: liquibase.exception.DatabaseException: ORA-00955: name is already used by an existing object

 [Failed SQL: (955) CREATE TABLE SYSTEM.QRTZ_LOCKS (SCHED_NAME VARCHAR2(120) NOT NULL, LOCK_NAME VARCHAR2(40) NOT NULL)]


```


In the **changeset** I have only one table **QRTZ_LOCKS** to create.


table is getting created successfully once but not sure why it is trying to create the same table **again second time** and getting the above mentioned error.



FYI, I do have other **couple of changesets** but those **changesets** do not have any create table query to create table **QRTZ_LOCKS** and I am using Oracle db.


**liquibaseVersion = '4.3.5'**


Below is my project structure



and followings are the content of each changelog xml files.


**db.changelog-dev.xml**


```

<?xml version="1.0" encoding="UTF-8"?>

<databaseChangeLog

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"

        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog

                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd">


  <changeSet id="100-1" author="author1">

    <insert tableName="books">

      <column name="book_name" value="harry potter1"/>

    </insert>

    <insert tableName="books">

      <column name="book_name" value="harry potter2"/>

    </insert>

  </changeSet>

  <changeSet id="200-1" author="author2">

    <insert tableName="laptop">

      <column name="laptop_name" value="windows"/>

    </insert>

  </changeSet>

</databaseChangeLog>

```


**db.changelog-local.xml**


```

<?xml version="1.0" encoding="UTF-8"?>

<databaseChangeLog

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"

        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog

                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd">


  <changeSet id="100000000-1" author="author10">

    <insert tableName="keyboard">

      <column name="keyboard_name" value="logitech"/>

      <column name="keyboard_version" value="v10"/>

    </insert>

    <insert tableName="keyboard">

      <column name="keyboard_name" value="samsung"/>

      <column name="keyboard_version" value="v11"/>

    </insert>

    <insert tableName="keyboard">

      <column name="keyboard_name" value="sony"/>

      <column name="keyboard_version" value="v12"/>

    </insert>

  </changeSet>

</databaseChangeLog>

```


**db.changelog-master.xml**


```

<?xml version="1.0" encoding="UTF-8"?>

<databaseChangeLog

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"

        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog

                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd">


  <include file="db/changelog/db.changelog-schema.xml"/>

  <include file="db/changelog/db.changelog-local.xml" context="local"/>

  <include file="db/changelog/db.changelog-dev.xml" context="dev"/>

  <include file="db/changelog/db.changelog-quartz.xml"/>


</databaseChangeLog>

```

**db.changelog-quartz.xml** - **provided in the beginning of this post**.


**db.changelog-schema.xml** 


```

<?xml version="1.0" encoding="UTF-8"?>

<databaseChangeLog

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"

        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog

                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd">


  <changeSet id="500000-1" author="author500">

    <createTable tableName="phonemodels">

      <column autoIncrement="true" name="id" type="BIGINT">

        <constraints nullable="false" primaryKey="true" primaryKeyName="PK_MODELS"/>

      </column>

      <column name="model_name" type="VARCHAR(255)">

        <constraints nullable="false" unique="true"/>

      </column>

      <column name="vendor_id" type="BIGINT">

        <constraints nullable="false"/>

      </column>

    </createTable>

    <createTable tableName="macbook">

      <column autoIncrement="true" name="id" type="BIGINT">

        <constraints nullable="false" primaryKey="true" primaryKeyName="PK_NATCOS"/>

      </column>

      <column name="macbook_name" type="VARCHAR(255)">

        <constraints nullable="false" unique="true"/>

      </column>

      <column name="macbook_id" type="VARCHAR(255)">

        <constraints nullable="false"/>

      </column>

      <column name="macbook_code" type="VARCHAR(255)">

        <constraints nullable="false"/>

      </column>

      </column>


    </createTable>


  </changeSet>


  <changeSet id="600000-1" author="author600">

    <createTable tableName="int_metadata_store">

      <column name="metadata_key" type="VARCHAR(255)">

        <constraints nullable="false"/>

      </column>

      <column name="metadata_value" type="VARCHAR(4000)"/>

      <column name="region" type="VARCHAR(100)">

        <constraints nullable="false"/>

      </column>

    </createTable>

  </changeSet>


  <changeSet id="7000000-1" author="author700">

    <createTable tableName="shedlock">

      <column name="name" type="VARCHAR(255)">

        <constraints nullable="false" primaryKey="true" primaryKeyName="PK_SHED_LOCK_NAME"/>

      </column>

      <column name="lock_until" type="timestamp(3)"/>

      <column name="locked_at" type="timestamp(3)"/>

      <column name="locked_by" type="VARCHAR(255)"/>

    </createTable>

  </changeSet>


</databaseChangeLog>

```


my properties files are below:


**application.yml**


```

server:

 tomcat:

  connectionTimeout: 300000

management:

 endpoint:

  mappings:

   enabled: true

spring:

 liquibase:

  change-log: classpath:/db/changelog/db.changelog-master.xml

 datasource:

  driver-class-name: oracle.jdbc.driver.OracleDriver

  hikari:

   minimum-idle: 5

   maximumPoolSize: 20

   idleTimeout: 30000

   maxLifetime: 2000000

   connectionTimeout: 30000

   poolName: abc-pool

 jpa:

  hibernate:

   use-new-id-generator-mappings: false

   ddl-auto: none

  database-platform: org.hibernate.dialect.Oracle12cDialect

 quartz:

  job-store-type: jdbc

  jdbc:

   initialize-schema: never

  properties:

   org:

    quartz:

     scheduler:

      instanceId: AUTO

     jobStore:

      class: org.quartz.impl.jdbcjobstore.JobStoreTX

      driverDelegateClass: org.quartz.impl.jdbcjobstore.oracle.OracleDelegate

      useProperties: false

      misfireThreshold: 60000

      clusterCheckinInterval: 5000

      isClustered: true

     threadPool:

      class: org.quartz.simpl.SimpleThreadPool

      threadCount: 10

      threadPriority: 5

      threadsInheritContextClassLoaderOfInitializingThread: true


```


**application-dev.yml**


```

spring:

 datasource:

  url: jdbc:oracle:thin:@devdomain:1521/devdb

  username: dev

  password: devpass

 liquibase:

  contexts: dev

```


**application-local.yml**


```

server:

 port: 8080

spring:

 datasource:

  url: jdbc:oracle:thin:@localhost:1521:OraDoc

  username: system

  password: MyPasswd123

 liquibase:

  contexts: local

```


**bootstrap.yml**


```

spring:

 application:

  name: awesome-app

```

can any one please help on this ?

Thanks

Tagged: