[h2] Re: java-level deadlock

The fix is in Version 1.3.174 (2013-10-19). Is it possible to find out in which version the bug was introduced? I have deployments using 1.3.168 and i don't remember having seen this happening. I have seen it happening in 1.3.173 though. I'm wondering whether to upgrade the 1.3.168

[h2] delete trigger

Hello, I try to create a delete trigger by this expression: create trigger 'test1' before delete ON 'filter' FOR EACH ROW BEGIN insert into recordiation set id = 1, currentdate = now(), name = old.name; END But I have some exception. Logs: Синтаксическая ошибка в выражении SQL CREATE

Re: [h2] delete trigger

This is our trigger syntax: http://h2database.com/html/grammar.html#create_trigger we don't support the style you are trying to use. -- 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

[h2] Timeout trying to lock table SYS during table creation

Hello, H2 v1.3.175 URL: jdbc:h2:mem:queries_db;CACHE_SIZE=32768;DATABASE_TO_UPPER=false;IGNORECASE=false;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;LOCK_TIMEOUT=1;LOG=0;UNDO_LOG=0;JMX=TRUE I's embedded database with in-memory tables only (table per request). After table is created multiple threads

[h2] Column not found when column is quoted

Hello folks, I've just analysed this jOOQ support request on Stack Overflow here and suspect that it is really a bug in H2: http://stackoverflow.com/q/25975401/521799 This query works in H2: select 1 abc, count(*) from dual group by abc order by abc asc So does this one: select 1 ABC,

Re: [h2] SCOPE_IDENTITY() returning NULL

I filed a bug report at https://code.google.com/p/h2database/issues/detail?id=585 Gili On Friday, September 5, 2014 1:39:06 AM UTC-4, Gili wrote: Noel, I think you were wrong about this only working for sequences. I ran into http://stackoverflow.com/a/12319823/14731 which states that SET