I have not realized this right away but backward slash is not URI replacement for space. it is %20 . The slash is usually used in file paths but not in the URI. JDBC connection string is URI hence you need to make sure it is valid. Try the %20 perhaps that will work for you. Maybe malformed URI caused driver to ignore IFEXISTS and your blank DB got created somewhere. try searching the drive or subpaths of your path or by filename
Tono On Wednesday, May 21, 2014 10:55:55 AM UTC+2, Ospeleo wrote: > > 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
