Errors in trace.db when closing Database

Hi, today I tried the latest H2 1.3.164 release. My application compacts that database from time to time by closing all connections and running "SHUTDOWN COMPACT". After that it reopens the database by creating a pooled connection. Using 1.3.164 I see the following exceptions in the trace file:

Re: Substr gives incorrect results when start_position is a negative number

Hi, Is there a way to register the new implementation with the same name > substr ? > No. I think it would be a source of trouble if we would allow to overwrite library methods. Instead, SUBSTR should be fixed if there is a bug. It seems only MySQL returns "Net" (the end of the input string) whe

Re: LEFT JOIN does not work

Hi, This is not a bug in H2. The problem is that you used "WHERE " instead of "ON ". H2 supports the omission of an "ON" condition, and uses "ON 1=1" in this case. Please note that using randomly generated UUIDs as the primary key will result on poor performance once there are millions of rows in

Re: FILE ID mismatch - upgrade db

Hi, > The highest version which still worked with an existing DB was > "Version 1.1.119 (2009-09-26)". Everything >1.2 complained about the > changed file format. Is this a stable release? Any major downsides to > this approach? If you use version 1.1.119, I would only use it as a temporary worka

Re: PreparedStatement with RUNSCRIPT/SCRIPT

Hi, Currently, the password need to be set as a literal in the SQL statement (PASSWORD 'xxx'). This will be fixed in the next release. Thanks for reporting this issue! Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to

Re: LEFT JOIN does not work

2012/3/7 Thomas Mueller : > This is not a bug in H2. The problem is that you used "WHERE > " instead of "ON ". H2 supports the omission > of an "ON" condition, and uses "ON 1=1" in this case. Okay, my SQL was wrong. I'll amend it when I am back. Thanks. > Please note that using randomly generate

Can this be done better?

I am using the following SQL code: CREATE TABLE container ( containerID UUID PRIMARY KEY, parentContainerId UUID, description VARCHAR(50) NOT NULL, FOREIGN KEY(parentContainerID) REFERENCES (containerID) ); INSERT INTO container (containerID, description) VALUES (random_UUID(

Re: Database consistency problems

Hi, Sorry I did not everything, but from the error code, you are using an old version of H2 (build #135, probably from 2009 or 2010). Can you reproduce the problem with a recent version? Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database"

Re: Java Start Parameter: -Dh2.identifiersToUpper=false not working

Hi, I was talking about the h2 database. I doubt that the PrivAccts.odb contains the H2 database file. Regards, Thomas On Friday, February 24, 2012, Noel L wrote: > Hi Thomas, > > > You need to edit the SQL script first, so that the identifier names are > of > > the correct case (find-replace)

Re: User-Defined Function Values

Hi, I'm sorry but H2 can't be 100% compatible with every other database. If I would change the behavior, it would be no longer compatible with MySQL in this area. Could you use "SELECT getNextIdAndUpdate() AS getNextIdAndUpdate" or resultSet.getString(1) instead? Regards, Thomas -- You receive