Re: [h2] Postgresql Update with 'Returning clause'

2015-08-09 Thread Noel Grandin
Sorry, we don't support that syntax. On Sat, 08 Aug 2015 at 07:14, Gary Malouf wrote: > I'm trying to execute the following against an h2database in postgresql > compatibility mode: > > UPDATE ctable c > SET c.status = 1 > FROM ( >SELECT co.id >FROM ctable co >INNER JOIN htable a >

Re: [h2] Re: H2 Database Engine: New version 1.4.188 available

2015-08-09 Thread Noel Grandin
It's on GitHub now. On Mon, 10 Aug 2015 at 02:38, Kenton Garner wrote: > Thomas, > > I actually would like to get the latest source - the links you have > attached are only the compiled jars. > Is there a another way to get access to the source? > I have used the SVN link in the past - but as has

[h2] Re: H2 Database Engine: New version 1.4.188 available

2015-08-09 Thread Kenton Garner
Thomas, I actually would like to get the latest source - the links you have attached are only the compiled jars. Is there a another way to get access to the source? I have used the SVN link in the past - but as has been stated, the files are not up to date - still version 187. I need the so

Re: [h2] QUERY_CACHE_SIZE default value too low?

2015-08-09 Thread Steve McLeod
@rado, Thanks for the suggestion. I tried Tomcat's connection pool, and it is indeed exactly what I need. On Saturday, 8 August 2015 10:04:46 UTC+2, rado wrote: > > I would recommend you to try the tomcat connection pool. I think it is > available as a separate distributable jar. -- You rece