rollbackdate in Oracle

Liquibase Development
1

Hi,

I’m testing liquibase to know how it’s works and I will to use it in the future.
I do a liquibase update and the store entries in databasechangelog. Like this entry:

       ID    AUTHOR    FILENAME    DATEEXECUTED    ORDEREXECUTED    EXECTYPE    MD5SUM    DESCRIPTION    COMMENTS    TAG    LIQUIBASE
1    3    bob    ./DataBaseChanges/BAT/JIRA/example.xml    01-APR-11 11.05.24.000000 AM    2    EXECUTED    3:a86f8a1dcc0e0903e93166c3861e8f39    Insert Row (x2)            2.0.1

This it’s fine for me but I tried to do rollback using the date(rollbackDate). I execute the ant command and I put a future date and I expect that it’s not necessary to do rollback because I hope that the rollback start in the date that I put.

In this example I put:   rollbackdate=“03/05/2011 23:59:59” and do the rollback successfully, ¿It’s normal? I think that It’s a bug.

I’m using liquibase-2.0.1-bin:

  1. Oracle Database.

    2. Update:
    <updateDatabase
                      changeLogFile="${liquibase.changeLogFile}"
                      driver="${liquibase.database.driver}"
                      url="${liquibase.database.url}"
                      username="${liquibase.database.username}"
                      password="${liquibase.database.password}"
                      promptOnNonLocalDatabase=“false”
                      dropFirst=“false”
                      contexts=“test”
                      classpathref=“liquibase.classpath”
              />


    3. Rollback:
      <rollbackDatabase
                      changeLogFile="${liquibase.changeLogFile}"
                      driver="${liquibase.database.driver}"
                      url="${liquibase.database.url}"
                      username="${liquibase.database.username}"
                      password="${liquibase.database.password}"
                      rollbackdate=“03/05/2011 23:59:59”
                      classpathref=“liquibase.classpath”
              />


2

The problem was the format of the time:

       

Will be usufull to put in the ant documentation

3

Thanks for the update. I’ll update the documentation.


Nathan