Hi, Thanks, but I already have a test case for the "Unique index or primary key violation" problem.
Regards, Thomas On Sat, May 24, 2014 at 5:38 PM, 'Ospeleo' via H2 Database < [email protected]> wrote: > If the h2 team is interested by this case (a Database that produces a "Unique > index or primary key violation" error with 1.3.176 but opens perfectly > with 1.3.172, let me know. I cannot investigate the bug myself, but my > problem is fixed. > > Le jeudi 22 mai 2014 17:21:19 UTC+2, Ospeleo a écrit : > >> 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 path is not >>> recognized. >>> I created a db in ~ and connected to it, create a table, disconnect. >>> I move the db in ~/Library and connect to it: the table is displayed. >>> I move the db in ~/Library/Application\ Support and connect to it: the >>> table doesn't show. >>> >>> Then, I move OpenConcerto.h2.db in ~/Library and connect to it. >>> Get the following error message >>> Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; >>> SQL statement: >>> ALTER TABLE "Default".FWK_MODULE_DEP ADD CONSTRAINT >>> "Default"."FWK_MODULE_DEP_ID_MODULE_fkey" FOREIGN KEY(ID_MODULE) >>> REFERENCES "Default".FWK_MODULE_METADATA(ID) ON DELETE CASCADE ON >>> UPDATE CASCADE NOCHECK [23505-176] >>> <http://192.168.0.153:8082/login.do?jsessionid=77be6b1a68ea3468fb909c2871ce4302#> >>> 23505/23505 >>> >>> I'm investigating it and let you know >>> Thanks for the hints >>> >>> Le mercredi 21 mai 2014 09:48:00 UTC+2, too a écrit : >>>> >>>> hi, >>>> Just few tips >>>> >>>> - what error is in OpenConcerto.trace.db? >>>> - try to create some table using the console. does that work? error? >>>> - what happens if you move the DB to location without spaces? >>>> - have you experimented with permissions to the DB file? >>>> >>>> Tono >>>> >>>> On Tuesday, May 20, 2014 5:47:15 PM UTC+2, Ospeleo wrote: >>>>> >>>>> Hi, >>>>> What is wrong in my process ? >>>>> I need an outside view. >>>>> I've been investigating this error for 12 hours over 3 days, thought >>>>> it was linked with my software which uses the H2 database (Openconcerto) >>>>> but it seems it is more H2/environment-related >>>>> >>>>> I use OSX10.6.8 >>>>> java version "1.6.0_65" >>>>> h2-1.3.176.jar >>>>> >>>>> I have a database (10mB) in >>>>> olivier:~ moi$ cd Library/Application\ Support/OpenConcerto/DBData/ >>>>> olivier:DBData moi$ ls -la >>>>> total 19552 >>>>> drwxr-xr-x 4 moi moi 136 19 mai 21:18 . >>>>> drwxr-xr-x 24 moi moi 816 19 mai 17:56 .. >>>>> -rw-r--r-- 1 moi moi 10004480 19 mai 21:18 OpenConcerto.h2.db >>>>> -rw-r--r-- 1 moi moi 3945 19 mai 17:18 OpenConcerto.trace.db >>>>> >>>>> I launch the H2 console in embedded mode with the parameters: >>>>> jdbc:h2:file:/Users/moi/Library/Application\ >>>>> Support/OpenConcerto/DBData/OpenConcerto;IFEXISTS=TRUE >>>>> login and password >>>>> >>>>> The console seems to succesfully connect to the database (or else it >>>>> should display an error message, with the option IFEXISTS=TRUE), but: >>>>> Where are the tables ? Shouldn't there be the tables listed on the >>>>> left pane? >>>>> What do I need to do to access these tables? >>>>> Thanks >>>>> >>>>> >>>>> <https://lh3.googleusercontent.com/-oleaDCRp1cM/U3t30O5n70I/AAAAAAAAAD0/Ha6UpzVquKI/s1600/Capture+d%E2%80%99e%CC%81cran+2014-05-20+a%CC%80+00.21.00.png> >>>>> >>>>> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
