ORA-00904: "FALSE": invalid identifier when creating a lock

General Discussion
1

The cause was that I have an extension overriding behavior from the OracleTypeConverter. My getBooleanType() method was returning the wrong thing. Ooopsie.

2

I’m trying to run a changelog against an Oracle database. I’ve never run liquibase against this particular database. It is in the process of creating a lock, but cannot. The version of Liquibase I’m using is 2.0.1. I am also running it with the maven plugin. Here is the Exception:


Error setting up or running Liquibase: liquibase.exception.DatabaseException: Error executing SQL UPDATE DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = ‘10.20.32.31 (10.20.32.31)’, LOCKGRANTED = to_date(‘2011-09-21 17:44:29’, ‘YYYY-MM-DD HH24:MI:SS’) WHERE ID = 1 AND LOCKED = FALSE: ORA-00904: “FALSE”: invalid identifier


at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)



Any ideas why it would do this? I’ve looked up the oracode and it’s absolutely no help at all.

3

Glad you found it, thanks for the update


Nathan