I am running into an error trying to set the database change log name in Liqiubase.
Mar 26, 2013 3:30:27 PM com.liqiubase.dbconnection.OracleConn init
SEVERE: null
liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Error executing SQL SELECT COUNT(*) FROM tdocinstall.THERADOCDATABASECHANGELOG: ORA-00942: table or view does not exist
at liquibase.database.AbstractDatabase.tag(AbstractDatabase.java:721)
at com.liqiubase.dbconnection.OracleConn.init(OracleConn.java:100)
at com.liquibase.operations.Install.updateDb(Install.java:22)
at theradocdbcode.LiquibaseMain.installNew(LiquibaseMain.java:100)
at theradocdbcode.LiquibaseMain.cleanandbuild(LiquibaseMain.java:123)
at theradocdbcode.LiquibaseMain.main(LiquibaseMain.java:38)
Caused by: liquibase.exception.DatabaseException: Error executing SQL SELECT COUNT(*) FROM tdocinstall.THERADOCDATABASECHANGELOG: ORA-00942: table or view does not exist
Here is an example of the code where the error is being thrown:
database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection©);
database.setDatabaseChangeLogLockTableName(LiquibaseMain.databaseLockLogName);
database.setDatabaseChangeLogTableName(LiquibaseMain.databaseChangeLogName);
database.setDefaultSchemaName((String) LiquibaseMain.installUsers().get(“install”));
database.tag(“4.6.0 Release”);
lqbase = new Liquibase(changeLog, new FileSystemResourceAccessor(), database );
Interesting thing here is that any of the database procedures are through the same error. For instance, if I commented out all but database.tag(“4.6.0 Release”); I still get the same error. Has anyone experienced this same issue and is there a know workaround?