[h2] Re: Error when opening the database a second time

I solved my problem by downgrading to h2-1.3.172.jar 1.3.176 or 1.3.178 wouldn't open my database Unique index or primary key violation 1.3.172 opens it just fine. Maybe try the same Le mercredi 21 mai 2014 19:47:54 UTC+2, Ospeleo a écrit : hi, it is the same error message I have reported

[h2] Re: Cannot connect to an existing embedded database

The problem has been solved by downgrading to h2-1.3.172.jar 1.3.176 or 1.3.178 wouldn't open my database Unique index or primary key violation 1.3.172 opens it just fine. Le mercredi 21 mai 2014 10:55:55 UTC+2, Ospeleo a écrit : Hi, The main problem is found. the '\ ' character in the

Re: [h2] Error when opening the database a second time

Hi I would need a reproducible test case. Or could you send me the database file? Regards, Thomas On Wednesday, May 21, 2014, Benoit HELIE benoit.he...@gmail.com wrote: I'm using H2 console to open a database. When opening the first time the database, I'm able to see the different tables of

Re: [h2] Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

Hi I would need a reproducible test case, or the database file. Regards, Thomas On Thursday, May 22, 2014, jack jin super...@gmail.com wrote: when I upgrade to 1.3.176,I have the same problem. the old version h2 is works fine with the db file On Tuesday, May 6, 2014 5:00:52 PM UTC+8,

Re: [h2] Row not found when trying to delete from index [v1.3.174]

Hi, You could export the database to a script file, and then create a new database from that. Regards, Thomas On Wednesday, May 21, 2014, Sander Sõnajalg san...@zeroturnaround.com wrote: Hi, so this is basically a known issue? And as I understand from your context, you are currently

[h2] Re: Exception when opening DB after forced shutdown (1.3.176)

I have experimented with this a little and here are few notes - lock file remains in place - this is consistent with shutdown hooks not being executed during JVM abort - size of DB file remains intact during runtime but during process termination the size rises by approximately 50MB

Re: [h2] How do Ic clear a flag ? (Integer field used as bitwise flag field)

Hi, Try bitand and bitor. Regards, Thomas On Monday, May 19, 2014, Thomas tballm...@gmx.de wrote: Usuually it is easy to clear flags: flag = flag ~mask; However, I miss the bitwise functions and ~. I even thought about converting to a binary string and replace the x.thposition by

Re: [h2] Exception when opening DB after forced shutdown (1.3.176)

Hi, I would need a reproducible test case. Regards, Thomas On Tuesday, May 20, 2014, too tono...@gmail.com wrote: Hi, Sometimes when our application is shut down forcibly it is unable to start again with exceptions below. It does not appear that transaction is in progress at the time of

[h2] Re: How do Ic clear a flag ? (Integer field used as bitwise flag field)

As far as I remember you need a bitand NOT to combine bitand and bitor to delete flags. Am Montag, 19. Mai 2014 08:50:48 UTC+2 schrieb Thomas: Usuually it is easy to clear flags: flag = flag ~mask; However, I miss the bitwise functions and ~. I even thought about converting to a binary

Re: [h2] Re: How do Ic clear a flag ? (Integer field used as bitwise flag field)

Hi, Bitwise not is the same as xor -1. Regards, Thomas On Thu, May 22, 2014 at 6:32 PM, Thomas tballm...@gmx.de wrote: Here is the usual java code result = result ~mask So you need a bitweise bitand (which is implemented) and a bitwise NOT (which is not implemented). Using bitxor just

Re: [h2] Re: Corruption in a database created in 1.3.174 when opening and closing it in 1.3.176

Hi, Thanks a lot for the test case! I could reproduce the problem now. The SQL.sql can be reduced to: create table a(x int primary key); create table b(x int, y int, primary key(x, y)); alter table b add foreign key(x) references a(x); I used the following shell script to reproduce the error:

[h2] TO_CHAR function for zero padded date, oracle compatibility

I need a date to be formatted as 01/01/2014. When I use H2 TO_CHAR function I get following results CALL TO_CHAR(sysdate, 'mm/dd/') gives 5/22/2014 instead of 05/22/2014 Is there a way to use TO_CHAR to get the date in the format I am expecting? -- You received this message because you are

[h2] Re: How do Ic clear a flag ? (Integer field used as bitwise flag field)

So can you please give me a example ? Am Montag, 19. Mai 2014 08:50:48 UTC+2 schrieb Thomas: Usuually it is easy to clear flags: flag = flag ~mask; However, I miss the bitwise functions and ~. I even thought about converting to a binary string and replace the x.thposition by zero ad

Re: [h2] Re: How do Ic clear a flag ? (Integer field used as bitwise flag field)

Hi, flag = bitand(flag, bitxor(mask, -1)); Regards, Thomas On Fri, May 23, 2014 at 6:24 AM, Thomas tballm...@gmx.de wrote: So can you please give me a example ? Am Montag, 19. Mai 2014 08:50:48 UTC+2 schrieb Thomas: Usuually it is easy to clear flags: flag = flag ~mask; However, I