Re: [h2] Cannot connect to an existing embedded database

[Thomas Mueller]

Hi

Don't escape spaces.

Regards, Thomas

On Wednesday, May 21, 2014, 'Ospeleo' via H2 Database <
h2-database@googlegroups.com> 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]
>  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 
> 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.
>

-- 
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.

[h2] Cannot connect to an existing embedded database

['Ospeleo' via H2 Database]

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



-- 
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.