H2 unable to parse a valid ISO datetime format

2011-10-25 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 becau

Re: closing embedded database with DB_CLOSE_DELAY=-1

2011-10-25 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

Re: closing embedded database with DB_CLOSE_DELAY=-1

2011-10-25 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 wrote: > Hi everyone, > > I am using an embedded Database with DB_CLOSE_DELAY=-1.  I could not > find

closing embedded database with DB_CLOSE_DELAY=-1

2011-10-25 Thread Adam McMahon
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 database from within Java code. I would like H2 to be able to close a bit more graceful, currently I am getting the tomcat warning: "appears to have started a thread named [H2

Re: var/char memory usage

2011-10-25 Thread Adam McMahon
Thanks for the quick answer! H2 is great! -Adam On Oct 25, 10:18 am, Thomas Mueller wrote: > Hi, > > In the documentation on var/chars and I saw that "The whole text is > > > kept in memory when using this data type."  I was confused as to what > > this statement meant? > > I will replace the s

Re: var/char memory usage

2011-10-25 Thread Thomas Mueller
Hi, In the documentation on var/chars and I saw that "The whole text is > kept in memory when using this data type." I was confused as to what > this statement meant? > I will replace the sentence with "The whole text is loaded into memory when using this data type." a) Does it mean that when t

Re: var/char memory usage

2011-10-25 Thread Noel Grandin
(b). As opposed to a BLOB/CLOB type, which streams only the necessary parts into memory as they are used. On Tue, Oct 25, 2011 at 16:32, Adam McMahon wrote: > Hi, > > I am new to this list.  H2 seems like a great program and I am highly > considering using it in my current web app. > > In the do

var/char memory usage

2011-10-25 Thread Adam McMahon
Hi, I am new to this list. H2 seems like a great program and I am highly considering using it in my current web app. In the documentation on var/chars and I saw that "The whole text is kept in memory when using this data type." I was confused as to what this statement meant? a) Does it mean th

Re: H2 unable to parse a valid ISO datetime format

2011-10-25 Thread Keith Donald
Just a quick follow up: 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. Thanks for the quick response, Keith On Tue, Oct 25, 2011 at 2:15 AM, Thomas Mueller < thomas.tom.muel...@gmail.com> wrote: > Hi, > > I can reproduce this probl