Re: [h2] Return multiple result sets from store procedure

Sorry, we don't support multiple result sets at all. On 2014-07-31 06:23 PM, i...@vonnagy.net wrote: We have procedures that run in MySQL and that return multiple result sets. When build unit tests for them and using H2, -- You received this message because you are subscribed to the Google

Re: [h2] Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

Reason for our case seems to be due to JVM crash. We use Runscript method to run SQL files with large number of inserts statements preceded by delete statement. During execution JVM is crashing, due to which dB file becomes corrupt. I tried with out of memory error also. -- You received this

[h2] MVCC and waiting for a row level lock until the competing transaction has committed

Hi guys, I want resume an old thread here http://h2-database.66688.n3.nabble.com/MVCC-and-waiting-for-a-row-level-lock-until-the-competing-transaction-has-committed-td1135038.html . I'd like to know if now is possibile with H2 wait for a row level lock until the first transaction has committed.