generateChangeLog problem

General Discussion
1

I have a very simple Sqlite3 database

one table, schema below


sqlite> .tables

parameters

sqlite> .schema parameters

CREATE TABLE parameters (

        id INTEGER NOT NULL,

        name VARCHAR NOT NULL,

        fo_transaction_number INTEGER NOT NULL,

        bo_transaction_number INTEGER NOT NULL,

        max_logon_attempts INTEGER,

        PRIMARY KEY (id)

);


I’m trying to do a generateChangeLog and I get the following


Any ideas?



H:\workspace\Perf\database>“C:/Program Files/liquibase/liquibase.bat” --driver=o

rg.sqlite.JDBC --changeLogFile=changelog2.xml --url=jdbc:sqlite:test.db --classp

ath=sqlitejdbc-v056.jar generateChangeLog

INFO 17/05/11 13:34:liquibase: Reading tables for null @ jdbc:sqlite:test.db …


INFO 17/05/11 13:34:liquibase: Reading tables for null @ jdbc:sqlite:test.db …


INFO 17/05/11 13:34:liquibase: Reading foreign keys for null @ jdbc:sqlite:test.

db …

INFO 17/05/11 13:34:liquibase: Reading primary keys for null @ jdbc:sqlite:test.

db …

INFO 17/05/11 13:34:liquibase: Reading columns for null @ jdbc:sqlite:test.db …

.

Liquibase Update Failed: no such column: ‘DECIMAL_POINTS’

SEVERE 17/05/11 13:34:liquibase: no such column: ‘DECIMAL_POINTS’

liquibase.exception.DatabaseException: java.sql.SQLException: no such column: 'D

ECIMAL_POINTS’

        at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(J

dbcDatabaseSnapshotGenerator.java:251)

        at liquibase.snapshot.DatabaseSnapshotGeneratorFactory.createSnapshot(Da

tabaseSnapshotGeneratorFactory.java:69)

        at liquibase.diff.Diff.compare(Diff.java:63)

        at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLo

g(CommandLineUtils.java:145)

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

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

Caused by: java.sql.SQLException: no such column: ‘DECIMAL_POINTS’

        at org.sqlite.RS.findColumn(RS.java:116)

        at org.sqlite.RS.getInt(RS.java:232)

        at liquibase.snapshot.jvm.SQLiteDatabaseSnapshotGenerator.readColumnInfo

(SQLiteDatabaseSnapshotGenerator.java:291)

        at liquibase.snapshot.jvm.SQLiteDatabaseSnapshotGenerator.readColumns(SQ

LiteDatabaseSnapshotGenerator.java:219)

        at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(J

dbcDatabaseSnapshotGenerator.java:244)

        … 5 more



For more information, use the --logLevel flag)


H:\workspace\Perf\database>

2

I have same issue, does somebody know about it. After run:

java -jar liquibase-1.9.3.jar --driver=org.sqlite.JDBC --classpath=lib/sqlite-jdbc-3.7.2.jar --changeLogFile=core.xml  --url=jdbc:sqlite:test.db  generateChangeLog

 

and I got:

Migration Failed: no such column: ‘DECIMAL_POINTS’

 

 

Thanks a lot,

 

yh