connection Broken Session Closed Error message

2010-07-14 Thread ranjith
Sir, We are using h2 in server mode. Client and Server is running in separate Windows XP machine. After 45-60 minutes connection was broken in client machine. And sometimes Timeout error was occurred when we try to access the same table in 2 or 3 clients. Please help me sir. Thanks in advance

Re: Migrate IDENTITY to AUTO_INCREMENT

2010-07-14 Thread Remo
Yes, it does, thanks! On Jul 14, 7:51 pm, Thomas Mueller wrote: > Hi, > > Does this solve the problem?: > > drop table test; > create table test(id identity, b int); > insert into test values(null, 0), (null, 1); > alter table test drop primary key; > alter table test alter column b set not null;

Re: "Unique index or primary key violation" for unknown constraint

2010-07-14 Thread Peter
maybe I hit this: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5042 On Jul 14, 10:44 pm, Peter wrote: > Hi again, > > now. this seems to be really a problem of hibernate+h2. hibernate > generates already existing ids!!?? > > The observations I made when importing data from an ex

Re: "Unique index or primary key violation" for unknown constraint

2010-07-14 Thread Peter
Hi again, now. this seems to be really a problem of hibernate+h2. hibernate generates already existing ids!!?? The observations I made when importing data from an external data source: 1. I executed the import once. A lot of data (say X*1000) -> every thing is fine 2. The next import -> exception

Re: Function field expression reference

2010-07-14 Thread Kerry Sainsbury
I don't quite understand. Do you want to do something like this: public String myFunction(Value value) { if (value.getTable.getName().equals("MyTable")) { return "AAA" + value.getText(); } else { return "BBB" + value.getText(); } } That is: Your function wants to

Re: REFERENTIAL_INTEGRITY FALSE

2010-07-14 Thread Thomas Mueller
Hi, Thanks for reporting! In my view this is a bug. I will try to fix it in the next release. 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-datab...@googlegroups.com. To unsubscribe from

Re: Migrate IDENTITY to AUTO_INCREMENT

2010-07-14 Thread Thomas Mueller
Hi, Does this solve the problem?: drop table test; create table test(id identity, b int); insert into test values(null, 0), (null, 1); alter table test drop primary key; alter table test alter column b set not null; alter table test add primary key(id, b); insert into test values(null, 0), (null,

Re: TcpServer, Disconnect user

2010-07-14 Thread Jeffrey Krzysztow
On Wed, Jul 14, 2010 at 2:41 AM, Michael Schmodt < michael.schm...@googlemail.com> wrote: > Hi, > I am using the TcpServer and I was wondering, if there is a > possibility to identify connections on serverside (e. g. the IP- > address of the client) and to close connections from the server > progr

Hierarchical Queries

2010-07-14 Thread Isaac
Is there any way of creating hierarchical queries in H2? I mean something like Oracle's CONNECT BY. Any help would be appreciated. Thanks in advance. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-datab..

Function field expression reference

2010-07-14 Thread bocher
Hi, I'd like to obtain the referenced table in sql statement to perform a specific process with myFunction. Select myFunction(avalue) from mytable; In my java code I want to know if the column avalue is referenced to mytable The same thing if I write Select myFunction(a.avalue) from mytable a

TcpServer, Disconnect user

2010-07-14 Thread Michael Schmodt
Hi, I am using the TcpServer and I was wondering, if there is a possibility to identify connections on serverside (e. g. the IP- address of the client) and to close connections from the server programmatically? Currently I am working with a seperate table, where clients insert their information and