messages example: import.sql is faulty

[eekboom]

Seam 1.1.0.GA, JBoss 4.0.5.GA

Currently deployment fails with this exception:

Caused by: java.sql.SQLException: Wrong data type: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
 at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
 at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
 at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
 at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:84)
 at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:254)

The import.sql reads:

insert into Message (title, text, read, datetime) values ('Hello World', 'This is an example of a message.', 0, '2006-1-1 11:12')
insert into Message (title, text, read, datetime) values ('Greetings Earthling', 'This is another example of a message.', 0, '2006-2-4 03:04')

It works after changing it to

insert into Message (title, text, read, datetime) values ('Hello World', 'This is an example of a message.', 0, '2006-01-01 11:12:00')
insert into Message (title, text, read, datetime) values ('Greetings Earthling', 'This is another example of a message.', 0, '2006-02-04 03:04:00')

[norman.richards]

That's interesting. I don't get that error. I'm running Seam and JBoss from CVS, but I can't imagine anything that would have changed that would cause that.

Hmm... You wouldn't happen to be on Java 6, would you?

[eekboom]

Interesting indeed: I was running JDK 6.
Changed JDK for JBoss to 1.5 and it deployed fine.
As a double check I changed back to 6 (simply restarting the server with the ear still in the deploy directory): The error reappeared

So I guess you should change the import.sql anyway. It's an easy workaround for JDK 6 compatibility,

[norman.richards]

Yeah - very interesting. I guess something in JDBC 4.0 isn't entirely backwards compatible. I just wanted to make sure that was the issue before checking a fix. Thanks for finding that!

[maxandersen]

note, this looks more like a hsqldb and java 6 "incompability" than hibernate/seam vs java 6 incompability.

[norman.richards]

Shane said he thought it was due to a change in java.sql.Timestamp.