A new topic, 'Oracle Error in build 290', has been made on a board you are 
watching.

You can see it at
http://liquibase.org/forum/index.php?topic=513.new#new

The text of the topic is shown below:

Hi, 
I found an Oracle Error in Build 290.  

A column like the following 
Code:
<column name="aTime" type="java.sql.Types.TIMESTAMP"/>  


now produces an error in build 290.  The exact error is:
Code:
java.sql.SQLException: ORA-01858: a non-numeric character was found where a 
numeric was expected
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:281)
        at 
liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:39)
        at liquibase.Liquibase.update(Liquibase.java:112)


Code:
aTime TIMESTAMP DEFAULT 'NULL'


This used to work for us in build 202.  In comparing the sql between 202 and 
290, build 202 did not put quotes around the null.

Overall, I really like Liquibase.  But right now, I am feeling rather 
discouraged.  :(  Build 202 worked for Oracle, but not MSSQL.  Build 290 seems 
to work for MSSQL but not Oracle.  We need both to work, plus DB2, MySql, 
Postgress, and Firebird.  Other than Firebird, I haven't even tried the three 
yet.
Build 290 seems to be the last build to pass.   

Thanks,
Alana

Unsubscribe to new topics from this board by clicking here: 
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user

Reply via email to