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.
