Re: closing embedded database with DB_CLOSE_DELAY=-1

2011-10-26 Thread Thotheolh
Disconnecting the H2 via JDBC should usually handle it internally. Do you have sample working codes, test cases and errors or warnings that can be reproduced ? On Oct 26, 12:17 pm, Adam McMahon a...@cs.miami.edu wrote: Hi everyone, I am using an embedded Database with DB_CLOSE_DELAY=-1.  I

Re: closing embedded database with DB_CLOSE_DELAY=-1

2011-10-26 Thread Thomas Mueller
Hi, To close the database, execute the SQL statement SHUTDOWN (Statement.execute(SHUTDOWN)). Regards, Thomas On Wednesday, October 26, 2011, Adam McMahon wrote: Hi everyone, I am using an embedded Database with DB_CLOSE_DELAY=-1. I could not find a simple way to close this type of

H2 unable to parse a valid ISO datetime format

2011-10-26 Thread Thomas Mueller
Hi, I also had the same problem with GMT time e.g 'z', instead of a offset - it didn't seem limited just to -05:00. Yes, I also saw that. The problem is now be fixed in the trunk and in the latest jar file (available in the download page). Regards, Thomas -- You received this message

Modifying SQL grammar

2011-10-26 Thread Martin
I'm trying to use H2 with a legacy MS SQL application using 'FOR XML AUTO'. I've put together a xml-auto function to reprocess into sql result set into formatted xml but I wanted to modify the sql grammar so it would be processed automatically. How feasible is it to do this? Thanks, Martin --

Re: closing embedded database with DB_CLOSE_DELAY=-1

2011-10-26 Thread Adam McMahon
Hi, Thomas: your suggestion to use the sql shutdown command worked great Thotheolh: I guess my question was a bit off, because I thought I would need an api call, but as it turns out the shutdown sql statement worked fine. To describe my situation. I am using embedded H2 in tomcat. When I

Re: BindAddress via JDBC

2011-10-26 Thread Thomas Mueller
Hi, I see... I guess in this case there is no other way than to manually set the address. It's a bit unfortunate, maybe it could be solved in some way. If somebody has an idea - patches are always welcome. Regards, Thomas -- You received this message because you are subscribed to the Google

Re: Native threads and also some jvm options

2011-10-26 Thread Thomas Mueller
Hi, Maybe you should ask somewhere else, for example on StackOverflow. Or (possibly) even easier, try it yourself. Regards, Thomas -- You received this message because you are subscribed to the Google Groups H2 Database group. To post to this group, send email to h2-database@googlegroups.com.

Re: H2 spatial support without using LGPL libraries

2011-10-26 Thread Peter Yuill
Hi Wes, We'd like to introduce native database spatial types and functions in our ISV ERM products. Our initial plans are just to store points and polygons, and do proximity searches and contains searches. Oracle, SQL Server and DB2 all support this, but H2 does only with add-ons that, as far