[h2] How to overload a H2DB function

2017-03-13 Thread gb co
Hi, Is there a way to overload a predefined H2DB function? What i want is for H2DB to be able to handle the function call: LAST_INSERT_ID(id) Basically i want the LAST_INSERT_ID to accept an id as param, and return it I cannot achieve this through an ALIAS as the method LAST_INSERT_ID() is

[h2] How to overload a predefined H2DB function ?

2017-03-13 Thread gb co
Hi, Is there a was to overload a predefined H2DB function? What i want is to for H2DB to be able to handle the function call: LAST_INSERT_ID(id) Basically i want the LAST_INSERT_ID to accept an id, and return it I cannot archive this through an ALIAS as the method LAST_INSERT_ID() is already

[h2] Index corruption

2017-03-13 Thread Andre Frintrop
Hi, we are using H2 since 7 years with many hundreds of customers for a desktop application. Since a few month, we get very often corrupt customer data databases for local installations. Mostly we see: org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler:

[h2] Re: MVStore write to disk but getting an out of memory error

2017-03-13 Thread javaworkinggirl
Thx. I forgot to post I fixed this by using a result handler when getting the data from the database. On Thu, Mar 9, 2017 at 5:48 AM, Noel Grandin [via H2 Database] < ml-node+s66688n4034042...@n3.nabble.com> wrote: > your best bet is to turn heap dumping on and have a look at the heap dump >

[h2] New version 1.4.194 - performance regression on index creation?

2017-03-13 Thread Sylvain Pointeau
Dear team, Is there any performance regression for creating the indexes? I found that my database take ages to create the indexes after mass load. Please let me know. Best regards, Sylvain -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To