Unfortunately, when I created the latest DB, the version was 188 and I guess that my issue is due to a version below 188. I will continue the investigation to reproduce the issue. I will keep you informed.
On Wednesday, September 16, 2015 at 11:14:09 AM UTC+2, IntensiveH2 wrote: > > Hello, > > Since I use the version 1.4.189 with an existing DB created with > version 1.4.188 (option like > MVCC=TRUE;AUTOCOMMIT=OFF;LOCK_MODE=3;LOG=2;CACHE_TYPE=SOFT_LRU;MV_STORE=FALSE > ), I have a lot of issue with column of kind datetime > > INFO | jvm 1 | 2015/09/16 10:25:32 | org.h2.jdbc.JdbcSQLException: > Cannot parse "TIMESTAMP" constant "8"; SQL statement: > INFO | jvm 1 | 2015/09/16 10:25:32 | SELECT A0.idmcprodinstance,A0.id > FROM MCJOBHISTORY A0 LEFT OUTER JOIN MCPRODINSTANCE A1 ON > A0.idmcprodinstance=A1.id WHERE ( (A0.processendstatus <> ? OR > (A0.jobreturncode <> ?)) AND A0.idmcprodinstance IS NOT NULL ) AND > ((A1.lastacknowledge IS NULL OR (A0.enddate > A1.lastacknowledge)) AND > A0.enddate >= ?) [22007-189] > .... > INFO | jvm 1 | 2015/09/16 10:25:34 | 2015/09/16 10:25:34 ERROR > [pperListener_start_runner] mserver.H2Listener > (com.infovista.mserver.H2Listener:H2Listener.java:exceptionThrown:57) > INFO | jvm 1 | 2015/09/16 10:25:34 | [DATABASE] exceptionThrown > sql=SELECT min(A0.startdate) FROM MCJOBHISTORY A0 > INFO | jvm 1 | 2015/09/16 10:25:34 | org.h2.jdbc.JdbcSQLException: > Cannot parse "TIMESTAMP" constant "0"; SQL statement: > INFO | jvm 1 | 2015/09/16 10:25:34 | SELECT min(A0.startdate) FROM > MCJOBHISTORY A0 [22007-189] > INFO | jvm 1 | 2015/09/16 10:25:34 | at > org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > ..... > INFO | jvm 1 | 2015/09/16 10:25:34 | Caused by: > java.lang.IllegalArgumentException: 0 > INFO | jvm 1 | 2015/09/16 10:25:34 | at > org.h2.util.DateTimeUtils.parseDateValue(DateTimeUtils.java:303) > INFO | jvm 1 | 2015/09/16 10:25:34 | at > org.h2.value.ValueTimestamp.parseTry(ValueTimestamp.java:140) > INFO | jvm 1 | 2015/09/16 10:25:34 | at > org.h2.value.ValueTimestamp.parse(ValueTimestamp.java:120) > with > create table MCJobHistory ( > id int not null, > parametersString varchar(20000) null, > idMCProdInstance int null, > startDate datetime null, > endDate datetime null, > ...... > > Maybe it's due to recent change to h2.storeLocalTime. > Nevertheless this issue is very annoying for me because the only way is to > migrate data. > > Do you have a workaround helping me? > > Regards > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
