Re: [h2] QUERY_CACHE_SIZE default value too low?
@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 received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
[h2] Re: H2 Database Engine: New version 1.4.188 available
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 source because i still have mods I require so my application instance can determine if it is the owner (embedded instance) of the shared db connection. I believe we have spoken about this in the past and I do not think my mod is a solution that is exceptable for all use cases so I need to compile my own. On Tuesday, August 4, 2015 at 2:56:05 PM UTC-4, Thomas Mueller wrote: > > Hi, > > I see. I don't know what the problem is, but I have uploaded the Maven > files to SourceForge as usual. For some reason outside of my control, they > are not synchronized to the Maven repository. I will ask the Maven guys > what the problem is. > > The files are here: > > > http://hsql.sourceforge.net/m2-repo/com/h2database/h2/1.4.188/h2-1.4.188.jar > > and also here: > > http://h2database.com/m2-repo/com/h2database/h2/1.4.188/h2-1.4.188.jar > > From time to time, synchronzation doesn't work, but the last time I got a > mail was quite a long time ago, see below. > > Regards, > Thomas > > > > -- Forwarded message -- > From: ma...@repo1.maven.org > > Date: Mon, Jul 20, 2015 at 10:30 PM > Subject: [Maven Central Nexus Repository Synchronization] FAILURE > To: "cen...@sonatype.com " >, > Thomas Mueller > > > > --- Some repositories were not synchronized --- > groupId: com.h2database > Error: > ssh: connect to host web.sourceforge.net port 22: Connection refused > rsync: connection unexpectedly closed (0 bytes received so far) [receiver] > rsync error: unexplained error (code 255) at io.c(600) [receiver=3.0.6] > Error synchronizing metadata. Exit code: 255 > > > > > On Tuesday, August 4, 2015, Kenton Garner > wrote: > >> Thomas, >> I was updating from the svn repository. I saw a lot of changes but the >> version number in the jar file remained at 187 and when I grep'd for the >> version number in the code - the src/main/org/h2/engine/Constants.java file >> has the public static final int BUILD_ID = 187; >> >> >> >> On Tue, Aug 4, 2015 at 1:45 AM, Thomas Mueller < >> thomas.tom.muel...@gmail.com> wrote: >> >>> Hi, >>> >>> I don't seem to have a new build ID in the constants file either... it is still showing 187. Is there something I am missing? >>> >>> Where exactly did you look? >>> >>> Regards, >>> Thomas >>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "H2 Database" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/h2-database/1qk80-GcnV4/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> h2-database+unsubscr...@googlegroups.com. >>> To post to this group, send email to h2-database@googlegroups.com. >>> Visit this group at http://groups.google.com/group/h2-database. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> 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 it, send an >> email to h2-database+unsubscr...@googlegroups.com. >> To post to this group, send email to h2-database@googlegroups.com. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > -- 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 it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Re: H2 Database Engine: New version 1.4.188 available
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 been stated, the files > are not up to date - still version 187. > > I need the source because i still have mods I require so my application > instance can determine if it is the owner (embedded instance) of the shared > db connection. > I believe we have spoken about this in the past and I do not think my mod > is a solution that is exceptable for all use cases so I need to compile my > own. > > > > On Tuesday, August 4, 2015 at 2:56:05 PM UTC-4, Thomas Mueller wrote: > >> Hi, >> >> I see. I don't know what the problem is, but I have uploaded the Maven >> files to SourceForge as usual. For some reason outside of my control, they >> are not synchronized to the Maven repository. I will ask the Maven guys >> what the problem is. >> >> The files are here: >> >> >> http://hsql.sourceforge.net/m2-repo/com/h2database/h2/1.4.188/h2-1.4.188.jar >> >> and also here: >> >> http://h2database.com/m2-repo/com/h2database/h2/1.4.188/h2-1.4.188.jar >> >> From time to time, synchronzation doesn't work, but the last time I got a >> mail was quite a long time ago, see below. >> >> Regards, >> Thomas >> >> >> >> -- Forwarded message -- >> From: ma...@repo1.maven.org >> Date: Mon, Jul 20, 2015 at 10:30 PM >> Subject: [Maven Central Nexus Repository Synchronization] FAILURE >> > To: "cen...@sonatype.com" , Thomas Mueller < >> thomas.to...@gmail.com> >> >> >> --- Some repositories were not synchronized --- >> groupId: com.h2database >> Error: >> ssh: connect to host web.sourceforge.net port 22: Connection refused >> rsync: connection unexpectedly closed (0 bytes received so far) [receiver] >> rsync error: unexplained error (code 255) at io.c(600) [receiver=3.0.6] >> Error synchronizing metadata. Exit code: 255 >> >> >> >> >> On Tuesday, August 4, 2015, Kenton Garner wrote: >> >>> Thomas, >>> I was updating from the svn repository. I saw a lot of changes but the >>> version number in the jar file remained at 187 and when I grep'd for the >>> version number in the code - the src/main/org/h2/engine/Constants.java file >>> has the public static final int BUILD_ID = 187; >>> >>> >>> >>> On Tue, Aug 4, 2015 at 1:45 AM, Thomas Mueller < >>> thomas.tom.muel...@gmail.com> wrote: >>> Hi, > I don't seem to have a new build ID in the constants file either... it > is still showing 187. Is there something I am missing? > Where exactly did you look? Regards, Thomas -- You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/1qk80-GcnV4/unsubscribe. To unsubscribe from this group and all its topics, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> 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 it, send >>> an email to h2-database+unsubscr...@googlegroups.com. >>> To post to this group, send email to h2-database@googlegroups.com. >>> Visit this group at http://groups.google.com/group/h2-database. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- > 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 it, send an > email to h2-database+unsubscr...@googlegroups.com. > To post to this group, send email to h2-database@googlegroups.com. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Postgresql Update with 'Returning clause'
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 > ON a.id = secretId > AND a.coupon_group_id = co.coupon_group_id > AND a.status = 1 >WHERE co.status = 0 >LIMIT 1 >FOR UPDATE >) ic > WHERE c.id = ic.id > RETURNING c.code > > > Against Postgres, this performs an update and returns a field from the row > that was updated. When I try to execute this against an h2database, I am > getting a mysterious syntax error [42000-187]. > > > This syntax is inspired by > http://dba.stackexchange.com/questions/69471/postgres-update-limit-1 > > > > -- > 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 it, send an > email to h2-database+unsubscr...@googlegroups.com. > To post to this group, send email to h2-database@googlegroups.com. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.