You will need to define your column as TIMESTAMP, a DATE column does not have a time part.
On Jul 21, 3:33 pm, gsibley <[email protected]> wrote: > 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.
