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.
