Hi
When using generateChangeLog to generate the changelog for an existing derby database, following error was seen.
generateChangeLog was used to generate changelog on various different preexisting databases, while it was successful to generate change log for some of them for others it failed with the following error
Logs:-
=========
Liquibase Home is not set.
Liquibase Home: /vobs/mac/liquibase
DEBUG 1/9/13 3:32 PM:liquibase: Unable to load/access Apache Derby driver class to check version
DEBUG 1/9/13 3:32 PM:liquibase: Unable to load/access Apache Derby driver class to check version
DEBUG 1/9/13 3:32 PM:liquibase: Connected to APP@jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db
DEBUG 1/9/13 3:32 PM:liquibase: Reading tables for APP @ jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db …
INFO 1/9/13 3:32 PM:liquibase: Reading tables for APP @ jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db …
DEBUG 1/9/13 3:32 PM:liquibase: Reading views for APP @ jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db …
INFO 1/9/13 3:32 PM:liquibase: Reading views for APP @ jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db …
DEBUG 1/9/13 3:32 PM:liquibase: Reading foreign keys for APP @ jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db …
INFO 1/9/13 3:32 PM:liquibase: Reading foreign keys for APP @ jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db …
DEBUG 1/9/13 3:32 PM:liquibase: Reading primary keys for APP @ jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db …
INFO 1/9/13 3:32 PM:liquibase: Reading primary keys for APP @ jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db …
DEBUG 1/9/13 3:32 PM:liquibase: Reading columns for APP @ jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db …
INFO 1/9/13 3:32 PM:liquibase: Reading columns for APP @ jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db …
INFO 1/9/13 3:32 PM:liquibase: Shutting down derby connection: jdbc:derby:/dv/scratch/gaur/gauravs/IBM/migrate/TestDb/vmgr.db;shutdown=true
Liquibase Update Failed: Syntax error: Encountered “CONSTRAINTS” at line 1, column 8.
SEVERE 1/9/13 3:32 PM:liquibase: Syntax error: Encountered “CONSTRAINTS” at line 1, column 8.
liquibase.exception.DatabaseException: java.sql.SQLSyntaxErrorException: Syntax error: Encountered “CONSTRAINTS” at line 1, column 8.
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:251)
at liquibase.snapshot.DatabaseSnapshotGeneratorFactory.createSnapshot(DatabaseSnapshotGeneratorFactory.java:69)
at liquibase.diff.Diff.compare(Diff.java:63)
at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:145)
at liquibase.integration.commandline.Main.doMigration(Main.java:760)
at liquibase.integration.commandline.Main.main(Main.java:134)
Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered “CONSTRAINTS” at line 1, column 8.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.isColumnAutoIncrement(JdbcDatabaseSnapshotGenerator.java:842)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readColumns(JdbcDatabaseSnapshotGenerator.java:369)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:244)
… 5 more
Caused by: java.sql.SQLException: Syntax error: Encountered “CONSTRAINTS” at line 1, column 8.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 16 more
Caused by: ERROR 42X01: Syntax error: Encountered “CONSTRAINTS” at line 1, column 8.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
… 10 more
br
gaurav singh