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.
