Current date in column insert

General Discussion
1

Hello,
I’m a newby enthousiast liquibase user and I have a little question that may be a problem.

I’m using liquibase 2.0.4 on an Oracle database and I try to insert some data with a date column. I want this date column to have the current date value.

I tried to use this syntax:

  1.      

which seem legit to me but I have a stange error message, like if the generated sql was incorrect: (sorry the error is in french)

  1. SEVERE 24/07/12 11:43:liquibase: Change Set changelog/6.5/changelog.xml::6.5-1::nremy failed.  Error: java.sql.SQLException: Paramètre IN ou OUT absent dans l’index :: 9
    liquibase.exception.DatabaseException: java.sql.SQLException: Paramètre IN ou OUT absent dans l’index :: 9
            at liquibase.change.core.InsertDataChange$ExecutableStatement.execute(InsertDataChange.java:166)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:79)
            at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
            at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
            at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
            at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
            at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
            at liquibase.Liquibase.update(Liquibase.java:114)
            at liquibase.Liquibase.updateTestingRollback(Liquibase.java:525)
            at liquibase.integration.commandline.Main.doMigration(Main.java:868)
            at liquibase.integration.commandline.Main.main(Main.java:134)
    Caused by: java.sql.SQLException: ParamÞtre IN ou OUT absent dans l’index :: 9
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
            at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1681)
            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3280)
            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
            at liquibase.change.core.InsertDataChange$ExecutableStatement.execute(InsertDataChange.java:164)
            … 10 more

I tried using the fixed date syntax and it works like a charm:

I didn’t found many information on correctly using sysdate with liquibase, do you have some more information do point me in the right direction ?

Thanks in advance.

2

I found out it was a bug in 2.0.4, it’s working in 2.0.3 and 2.0.5.

Too bad I suffer from another bug in 2.0.5 CORE-1170

I’ll stick with liquibase 2.0.3 for now ;o)