Thank you for the response! It is very helpful.

Yachin

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

<databaseChangeLog

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

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

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

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

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

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

    <changeSet id="37" author="META"  dbms="oracle" runOnChange="true" >

        <comment>Load Metadata </comment>

        <sqlFile dbms="oracle" endDelimiter="\n/\s*\n|\n/\s*$" path="procedures/prc_delete_metadata.sql"  splitStatements="false"  />

        <rollback>

            <sql>DROP PROCEDURE META.PRC_DELETE_METADATA</sql>

        </rollback>

    </changeSet>

</databaseChangeLog>

Procedure 

=========

END;

/

Here is the error i am getting 

Unexpected error running Liquibase: java.lang.RuntimeException: Cannot find database driver: oracle.jdbc.driver.OracleDriver

liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: java.lang.RuntimeException: Cannot find database driver: oracle.jdbc.driver.OracleDriver

        at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:132)

        at liquibase.integration.commandline.Main.doMigration(Main.java:974)

        at liquibase.integration.commandline.Main.run(Main.java:199)

        at liquibase.integration.commandline.Main.main(Main.java:137)

Caused by: liquibase.exception.DatabaseException: java.lang.RuntimeException: Cannot find database driver: oracle.jdbc.driver.OracleDriver

        at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:254)

        at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:149)

        at liquibase.integration.commandline.Co<BR>Std err:

i have tried both oracle.jdbc.driver.OracleDriver & oracle.jdbc.OracleDriver  still getting the same error

Yes indeed, but we want the test writer to permute the data (test)runtime to avoid store hundreds of loader files in the project and repository...

I wrote a working solution as a liquibase extension overriding the LoadDataChange class, extending the <loadData ..> tag with an extra attribute !

Maybe it worth to share here when it is totally ready ...

I am unsing the 3.6.3 version of liquibase on an Oracle database.

When i use the index pre condition Liquibase is freezing and the freez can take more than one hour..

Here my changeLog

Here the stack trace (freezing on the select index request )

My output console is

Has some body had the same problem?

Thanks.

Abdel.

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

<databaseChangeLog

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

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

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

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

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

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

<changeSet id="19" author="Kiru">

<tagDatabase tag="tag-init"/> 

 <sqlFile dbms="oracle" path="data/test_table.sql" />

 <rollback>

            <dropTable tableName="test11"/>

      </rollback>    

</changeSet>

</databaseChangeLog>

I am getting the following an error.

Please help 

Thanks for checking my question.

We want to add liquibase into our existing project, and we also hope source control the database objects based on the file, meaning we prefer to generate the one change log file on one database object, then we source control the file and update the database object by sing the single object chang log file. 

Now generating changelog create the only file for whole schema, I don't have see the option I could use to generate the changelog file separately for each object. 

I know SQLcl could do that, but SQLcl can't allow us to specify the author for the changelog, so there is no perfect approach.Any idea or suggestions will be highly appreciated. 

Thanks

Roy

hope it helps

Nathan

This seems a working solution. Except that you are correct, the presented code would fail on function change

Problem here is that it becomes a bit hard to see which changes have been applied to the database and which weren't.

The only thing you know is that "when sproc A was last replaced at <timestamp>, the SQL code hashed to a value of <hash>".

Since you don't have a ready hash of the resulting changeset, it might be a bit hard to identify in case of any discrepancies. This could be a moot point if you have other ways of tracking deployed versions, of course...

I am working on one java spring boot based project and using liquibase as my middle layer, Using database sequence for entity ID.
so I have below liquibase changeSet and which is not creating sequence on SQL server (version - Microsoft SQL Azure (RTM) - 12.0.2000.8).

Please let me know if there is some solution to resolve it (Liquibase version is 2.0.1).

Thank you.

C:\Liquibase>liquibase update<br>Starting Liquibase at Wed, 16 Jan 2019 19:07:25 IST (version 3.6.0 built at 2018-04-05 05:13:19)<br>Unexpected error running Liquibase: Column, parameter, or variable #2: Cannot find data type BOOLEAN. [Failed SQL: CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]<br>liquibase.exception.LockException: liquibase.exception.DatabaseException: Column, parameter, or variable #2: Cannot find data type BOOLEAN. [Failed SQL: CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]<br> at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:289)<br> at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:207)<br> at liquibase.Liquibase.update(Liquibase.java:184)<br> at liquibase.Liquibase.update(Liquibase.java:179)<br> at liquibase.integration.commandline.Main.doMigration(Main.java:1205)<br> at liquibase.integration.commandline.Main.run(Main.java:191)<br> at liquibase.integration.commandline.Main.main(Main.java:129)<br>Caused by: liquibase.exception.DatabaseException: Column, parameter, or variable #2: Cannot find data type BOOLEAN. [Failed SQL: CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]<br> at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)<br> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)<br> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)<br> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:109)<br> at liquibase.lockservice.StandardLockService.init(StandardLockService.java:97)<br> at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:246)<br> ... 6 common frames omitted<br>Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or variable #2: Cannot find data type BOOLEAN.<br> at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)<br> at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)<br> at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)<br> at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)<br> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)<br> at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)<br> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)<br> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)<br> at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:751)<br> at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)<br> ... 11 common frames omitted<br><br><br>For more information, please use the --logLevel flag