How to generate change log file in liquibase using Java

Question

I want to generate a change log XML file in liquibase using Java, which stores the information of two databases difference.

My code is:

Database database=CommandLineUtils.createDatabaseObject(MySQLConnection.class.getClassLoader(), 
                "jdbc:mysql://localhost:3306/test", "root", "admin", "com.mysql.jdbc.Driver", "", null,false,false,null,null,null,null);

        Database database2=CommandLineUtils.createDatabaseObject(MySQLConnection.class.getClassLoader(), 
                "jdbc:mysql://localhost:3306/pizzashop", "root", "admin", "com.mysql.jdbc.Driver", "", null,false,false,null,null,null,null);
      CommandLineUtils.doDiffToChangeLog("changelog.xml", database2, database,new DiffOutputControl(),null,null);

But it generates a blank changelog.xml file.

Right now, there is a typo in the script above that sends the output to 'chagelog.xml' rather than 'changelog.xml', but that could be just a typo here. — SteveDonie
– SteveDonie, Commented Aug 25, 2014 at 17:55
could you set logLevel=DEBUG in your liquibase properties file and then attach the log? — SteveDonie
– SteveDonie, Commented Aug 27, 2014 at 17:32

Biswajit · Accepted Answer · 2014-08-29 17:11:22Z

1

I solved my question.use liquibase 2.0.3 version.

Code is:

Database database=CommandLineUtils.createDatabaseObject(MySQLConnection.class.getClassLoader(), 
                "jdbc:mysql://localhost:3306/lportal", "root", "admin", "com.mysql.jdbc.Driver", 
                null,null,null);

        Database database2=CommandLineUtils.createDatabaseObject(MySQLConnection.class.getClassLoader(), 
                "jdbc:mysql://localhost:3306/llportal", "root", "admin", "com.mysql.jdbc.Driver",
                null,null,null);
    CommandLineUtils.doDiffToChangeLog("changeLogFile.xml",database, database2)

;

answered Aug 29, 2014 at 17:11

Biswajit

2,5162 gold badges32 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to generate change log file in liquibase using Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related