Hi Don't escape spaces.
Regards, Thomas On Wednesday, May 21, 2014, 'Ospeleo' via H2 Database < [email protected]> wrote: > I have the same "blank" database If I use %20 or '\ ' > > But when I move the database (temporarily) to another location, without a > space in the path, I get the error message cited below > > Le mercredi 21 mai 2014 13:44:01 UTC+2, too a écrit : > > 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/DBDat > > -- > 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]<javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to > [email protected]<javascript:_e(%7B%7D,'cvml','[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.
