in memory mode

2009-11-19 Thread Arthur Blake
I just wanted to point out that, contrary to the comparison on http://www.h2database.com/html/main.html, Apache Derby also has an in-memory mode.as of release 10.5.1.1, according to http://old.nabble.com/-ANNOUNCE--Apache-Derby-10.5.1.1-released-td23337475.html: "- In-memory back end - first rev

Server side cursors

2009-11-19 Thread Franklin Schmidt
When do you expect to implement server side cursors? My application needs this because it reads from a long result set until certain conditions are met and reading the entire result is too slow. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: Using java.util.UUID with Hibernate

2009-11-19 Thread jgrasper
I figured it out... it was a problem between using Postgres and using H2. For Postgres I had to do this when setting a UUID via the setObject() command: st.setObject(index, value,); for H2 I do this: st.setObject(index, value); On Nov 19, 12:

Re: Testing Clustered H2 Nodes

2009-11-19 Thread Merkel
Solution found; Append ";CLUSTER=''" to individual database URLs to be able to connect to it in isolation instead of connecting to the cluster. On Nov 19, 10:52 am, Max Bridgewater wrote: > Hi, > > I had some troubles testing a H2 cluster. Let's say I have two nodes running > on localhost ports 8

Re: Using java.util.UUID with Hibernate

2009-11-19 Thread jgrasper
This is all Hibernate Generated: create table MyObject ( id integer not null, UUID uuid, primary key (id) ) insert into MyObject (id, UUID) values (?, ?) Here is what Hibernate is Binding: commonObjects.MyObject{id=0, UUID=2ac2

Re: Using java.util.UUID with Hibernate

2009-11-19 Thread jgrasper
Ignore the last one... I messed up when I was typing it This is all Hibernate Generated: create table MyObject ( id integer not null, UUID uuid, primary key (id) ) insert into MyObject (id, UUID) values (?, ?) Here is what Hibe

Re: Recover error

2009-11-19 Thread Thomas Mueller
Hi, You are right. The exceptions should not be listed, you can ignore them. I will disable those in the next release. The Recover tool doesn't work well with LOBs unfortunately - it tries to load them in memory because it temporarily converts them to VARCHAR, which is bad of course. I'm not sure

Re: Invalid value for parameter url [90008-114]

2009-11-19 Thread Thomas Mueller
Hi, It looks like the URL property was not set, because the exception message is " Invalid value for parameter url [90008-114]" (two spaces between "value" and "for"). That's strange. Maybe the problem is that the method name is setURL(..) instead of setUrl(..). If that's the problem, I would hav

Re: Using java.util.UUID with Hibernate

2009-11-19 Thread jgrasper
This is all Hibernate Generated: create table MyObject ( id integer not null, UUID uuid, primary key (id) ) insert into OmnyxObject (UUID, id) values (?, ?) Here is what Hibernate is Binding: commonObjects.MyObject{id=0, UUID

Re: Using java.util.UUID with Hibernate

2009-11-19 Thread Max Bridgewater
Out of curiosity, can you show you SQL statement for creating the table and for insertion? On Thu, Nov 19, 2009 at 11:07 AM, jgrasper wrote: > I have been trying to use Hibernate and H2s capability of using > java.util.UUID. The problem is that no matter what I have the UUID > field of my objec

Re: Using java.util.UUID with Hibernate

2009-11-19 Thread jgrasper
Ok.. so I tried something else (Having the UUID not as a PK to see what h2 would see) On the Java Side: (Generated UUIDs) 2ac27d72-ea0f-46ef-8c96-29e728d4aaa1 d760a7c7-854e-4ce3-a403-d7c9d0dd6b47 330f42e0-ff11-4c9e-bd35-f57fb8646ebe cf470ef1-3f51-4e8d-856b-8a6b55f0729b 9280bb8c-33f6-43b6-aab0-05f

Using java.util.UUID with Hibernate

2009-11-19 Thread jgrasper
I have been trying to use Hibernate and H2s capability of using java.util.UUID. The problem is that no matter what I have the UUID field of my object set to, the UUID ends up in the db as: aced0005-7372-000e-6a61-76612e757469 Is this value hard coded somewhere? I get exceptions like this even

Testing Clustered H2 Nodes

2009-11-19 Thread Max Bridgewater
Hi, I had some troubles testing a H2 cluster. Let's say I have two nodes running on localhost ports 8000 and 8001. I can connect to the cluster as a whole using the URL: tcp://localhost:8000,localhost:8001/test. What I couldn't figure out is a simple way to verify that each node in the cluster pr

Re: H2 Database table size

2009-11-19 Thread Vali
Thank you for the help. PS: Yes I was talking about the size on disk. Best Regards, Vali On Nov 18, 7:51 pm, Mike Goodwin wrote: > Hi Vali, > > Presumably you mean the size on disk? > > I think the answer will be no. Between different storage mechanisms > and string data being shared there is n