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:
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
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
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
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
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
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(
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"
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)
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
10 matches
Mail list logo