[h2] Invalid value "null" for parameter "calendar" [90008-193]

Hi, when I execute PreparedStatement.setTimestamp(1, timestamp, null); I get the following Exception: org.h2.jdbc.JdbcSQLException: Unerlaubter Wert "null" für Parameter "calendar" *Invalid value "null" for parameter "calendar" [90008-193]* at

Re: [h2] H2 database in tomcat environment throwing RuntimeException “unexpected code path” on select sequence.nextval

Is it OK to use this connections string in tomcat (i.e. multi threaded, using connection pool) environment? jdbc:h2:~/mydb;AUTO_SERVER=TRUE; May I access the database also from another JDBC-Tool with the same connection string while tomcat is running / not running? May the database become

Re: [h2] H2 database in tomcat environment throwing RuntimeException “unexpected code path” on select sequence.nextval

Hi Noel, happy new Year! Any updates on this issue? Best regards Andreas On Friday, December 23, 2016 at 8:16:18 PM UTC+1, Andreas Knees wrote: > > Hi Noel, > > I extracted the bug to a single servlet application. You may clone it on > GitHub (sorry for

Re: [h2] H2 database in tomcat environment throwing RuntimeException “unexpected code path” on select sequence.nextval

Hi Noel, I extracted the bug to a single servlet application. You may clone it on GitHub (sorry for the project name ;-). I have added a description how to set up the project and how to run it. Best regards Andreas On Friday, December 23, 2016 at

Re: [h2] H2 database in tomcat environment throwing RuntimeException “unexpected code path” on select sequence.nextval

Thank you for your reply, Noel. On Friday, December 23, 2016 at 7:19:08 AM UTC+1, Noel Grandin wrote: > > there seem to be some chunks missing from the stack trace which makes it a > little tricky to see why things are going wrong. > > Here is the whole thing: 2016-12-23 00:46:03 jdbc[3]:

[h2] H2 database in tomcat environment throwing RuntimeException “unexpected code path” on select sequence.nextval

See also this StackOverflow question I am using H2 database h2-1.4.193 as datasource in tomcat. This is my server.xml entry: I use this datasource for both the