Hi
I'm extracting data out of an Oracle database, using squirrel, and
inserting it into an 'in-memory' H2 database for my integration tests.
I'm using hibernate annotations and the 'hbm2ddl.auto' utility to
create the schema in the integration tests. I'm using Springs
SimpleJdbcTestUtils.executeSqlScript() method to execute the file of
insert statements. This all works fine except for when I insert data
for DATE fields. The date members in the hibernate classes are
specified as java Date types. e.g.
@Temporal(TemporalType.DATE)
@Column(name = "MY_DATE")
private Date myDate;
Here's a snippet of my insert ddl statement:-
INSERT INTO "MY_TABLE" (ID,MY_DATE) VALUES (1,{ts '2011-07-01
16:19:18.0'});
I get the following stack trace:-
Caused by: org.h2.jdbc.JdbcSQLException: Cannot parse "DATE" constant
"2011-07-01 16:19:18.0"; SQL statement:
Caused by: java.lang.NumberFormatException: For input string: "01
16:19:18.0"
The above works fine if I remove the time portion of the date.
Is there anyway that I can get the time portion recognised?
Regards
George
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
