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

H2 spatial support without using LGPL libraries

2011-10-26 Thread Wes Clark
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 as I can te

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: 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 Gro

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 wo

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 --