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

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

['Ospeleo' via H2 Database]

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

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

['Ospeleo' via H2 Database]

The full error message is 

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 
>>> (Aide)
>>> org.h2.jdbc.JdbcSQLException: 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]
>>> at 
>>> org.h2.message.DbException.getJdbcSQLException(DbException.java:344
>>> )
>>> at 
>>> org.h2.message.DbException.get(DbException.java:178
>>> )
>>> at 
>>> org.h2.message.DbException.get(DbException.java:154
>>> )
>>> at 
>>> org.h2.index.PageDataIndex.getNewDuplicateKeyException(PageDataIndex.java:166
>>> )
>>> at 
>>> org.h2.index.PageDataIndex.add(PageDataIndex.java:144
>>> )
>>> at 
>>> org.h2.store.PageStore.addMeta(PageStore.java:1808
>>> )
>>> at 
>>> org.h2.index.PageBtreeIndex.(PageBtreeIndex.java:64
>>> )
>>> at 
>>> org.h2.table.RegularTable.addIndex(RegularTable.java:235
>>> )
>>> at 
>>> org.h2.command.ddl.AlterTableAddConstraint.createIndex(AlterTableAddConstraint.java:280
>>> )
>>> at 
>>> org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:205
>>> )
>>> at 
>>> org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:73
>>> )
>>> at 
>>> org.h2.engine.MetaRecord.execute(MetaRecord.java:59
>>> )
>>> at 
>>> org.h2.engine.Database.open(Database.java:719
>>> )
>>> at 
>>> org.h2.engine.Database.openDatabase(Database.java:260
>>> )
>>> at 
>>> org.h2.engine.Database.(Database.java:254
>>> )
>>> at 
>>> org.h2.engine.Engine.openSession(Engine.java:57
>>> )
>>> at 
>>> org.h2.engine.Engine.openSession(Engine.java:164
>>> )
>>> at 
>>> org.h2.engine.Engine.createSessionAndValidate(Engine.java:142
>>> )
>>> at 
>>> org.h2.engine.Engine.createSession(Engine.java:125
>>> )
>>> at 
>>> org.h2.engine.Engine.createSession(Engine.java:27
>>> )
>>> at 
>>> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:331
>>> )
>>> at 
>>> org.h2.jdbc.JdbcConnection.(JdbcConnection.java:107
>>> )
>>> at 
>>> org.h2.jdbc.JdbcConnection.(JdbcConnection.java:91
>>> )
>>> at 
>>> org.h2.Driver.c

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

['Ospeleo' via H2 Database]

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

-- 
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] Re: Cannot connect to an existing embedded database

['Ospeleo' via H2 Database]

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

[h2] Re: Error when opening the database a second time

['Ospeleo' via H2 Database]

hi, 
it is the same error message I have reported on this subject, posted today: 
https://groups.google.com/d/msg/h2-database/iPAECUAML4Y/70PkSslWInQJ

I access my database via my application/ Works great. I want to manipulate 
the table. The same error than yours.


Le mercredi 21 mai 2014 14:30:57 UTC+2, Benoit HELIE a écrit :
>
> I'm using H2 console to open a database. 
> When opening the first time the database, I'm able to see the different 
> tables of the database and execute SQL scripts.
>
> When I try to open it a second time, I always have the following error :
>
> Unique index or primary key violation: "PRIMARY KEY ON .PAGE_INDEX"; 
> SQL statement:
> ALTER TABLE PUBLIC.CORE_GROUP_MEMBER ADD CONSTRAINT 
> PUBLIC.FK_GROUP_MEMBER_PARTY FOREIGN KEY(PARTY_ID) REFERENCES 
> PUBLIC.CORE_PARTY(PARTY_ID) NOCHECK [23505-176] 23505/23505 (Help)
> org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: 
> "PRIMARY KEY ON .PAGE_INDEX"; SQL statement:
> ALTER TABLE PUBLIC.CORE_GROUP_MEMBER ADD CONSTRAINT 
> PUBLIC.FK_GROUP_MEMBER_PARTY FOREIGN KEY(PARTY_ID) REFERENCES 
> PUBLIC.CORE_PARTY(PARTY_ID) NOCHECK [23505-176]
>  at 
> org.h2.message.DbException.getJdbcSQLException(DbException.java:344) 
> at org.h2.message.DbException.get(DbException.java:178) 
> at org.h2.message.DbException.get(DbException.java:154) 
> at 
> org.h2.index.PageDataIndex.getNewDuplicateKeyException(PageDataIndex.java:166)
>  at org.h2.index.PageDataIndex.add(PageDataIndex.java:144) 
> at org.h2.store.PageStore.addMeta(PageStore.java:1808) 
> at org.h2.index.PageBtreeIndex.(PageBtreeIndex.java:64) 
> at org.h2.table.RegularTable.addIndex(RegularTable.java:235) 
> at 
> org.h2.command.ddl.AlterTableAddConstraint.createIndex(AlterTableAddConstraint.java:280)
>  at 
> org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:205)
>  at 
> org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:73)
>  at org.h2.engine.MetaRecord.execute(MetaRecord.java:59) 
> at org.h2.engine.Database.open(Database.java:719) 
> at org.h2.engine.Database.openDatabase(Database.java:260) 
> at org.h2.engine.Database.(Database.java:254) 
> at org.h2.engine.Engine.openSession(Engine.java:57) 
> at org.h2.engine.Engine.openSession(Engine.java:164) 
> at org.h2.engine.Engine.createSessionAndValidate(Engine.java:142) 
> at org.h2.engine.Engine.createSession(Engine.java:125) 
> at org.h2.engine.Engine.createSession(Engine.java:27) 
> at 
> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:331)
>  at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:107) 
> at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:91) 
> at org.h2.Driver.connect(Driver.java:74) 
> at org.h2.server.web.WebServer.getConnection(WebServer.java:684) 
> at org.h2.server.web.WebApp.login(WebApp.java:958) 
> at org.h2.server.web.WebApp.process(WebApp.java:212) 
> at org.h2.server.web.WebApp.processRequest(WebApp.java:171) 
> at org.h2.server.web.WebThread.process(WebThread.java:138) 
> at org.h2.server.web.WebThread.run(WebThread.java:94) 
> at java.lang.Thread.run(Unknown Source) 
>
> The database is used for a test management tool which I want to update.
> Anyone could help ?
>
> Best regards
>

-- 
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] Re: Error when opening the database a second time

['Ospeleo' via H2 Database]

I solved my problem 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.
Maybe try the same

Le mercredi 21 mai 2014 19:47:54 UTC+2, Ospeleo a écrit :
>
> hi, 
> it is the same error message I have reported on this subject, posted 
> today: 
> https://groups.google.com/d/msg/h2-database/iPAECUAML4Y/70PkSslWInQJ
>
> I access my database via my application/ Works great. I want to manipulate 
> the table. The same error than yours.
>
>
> Le mercredi 21 mai 2014 14:30:57 UTC+2, Benoit HELIE a écrit :
>>
>> I'm using H2 console to open a database. 
>> When opening the first time the database, I'm able to see the different 
>> tables of the database and execute SQL scripts.
>>
>> When I try to open it a second time, I always have the following error :
>>
>> Unique index or primary key violation: "PRIMARY KEY ON .PAGE_INDEX"; 
>> SQL statement:
>> ALTER TABLE PUBLIC.CORE_GROUP_MEMBER ADD CONSTRAINT 
>> PUBLIC.FK_GROUP_MEMBER_PARTY FOREIGN KEY(PARTY_ID) REFERENCES 
>> PUBLIC.CORE_PARTY(PARTY_ID) NOCHECK [23505-176] 23505/23505 (Help)
>> org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: 
>> "PRIMARY KEY ON .PAGE_INDEX"; SQL statement:
>> ALTER TABLE PUBLIC.CORE_GROUP_MEMBER ADD CONSTRAINT 
>> PUBLIC.FK_GROUP_MEMBER_PARTY FOREIGN KEY(PARTY_ID) REFERENCES 
>> PUBLIC.CORE_PARTY(PARTY_ID) NOCHECK [23505-176]
>>  at 
>> org.h2.message.DbException.getJdbcSQLException(DbException.java:344) 
>> at org.h2.message.DbException.get(DbException.java:178) 
>> at org.h2.message.DbException.get(DbException.java:154) 
>> at 
>> org.h2.index.PageDataIndex.getNewDuplicateKeyException(PageDataIndex.java:166)
>>  at org.h2.index.PageDataIndex.add(PageDataIndex.java:144) 
>> at org.h2.store.PageStore.addMeta(PageStore.java:1808) 
>> at org.h2.index.PageBtreeIndex.(PageBtreeIndex.java:64) 
>> at org.h2.table.RegularTable.addIndex(RegularTable.java:235) 
>> at 
>> org.h2.command.ddl.AlterTableAddConstraint.createIndex(AlterTableAddConstraint.java:280)
>>  at 
>> org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:205)
>>  at 
>> org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:73)
>>  at org.h2.engine.MetaRecord.execute(MetaRecord.java:59) 
>> at org.h2.engine.Database.open(Database.java:719) 
>> at org.h2.engine.Database.openDatabase(Database.java:260) 
>> at org.h2.engine.Database.(Database.java:254) 
>> at org.h2.engine.Engine.openSession(Engine.java:57) 
>> at org.h2.engine.Engine.openSession(Engine.java:164) 
>> at org.h2.engine.Engine.createSessionAndValidate(Engine.java:142) 
>> at org.h2.engine.Engine.createSession(Engine.java:125) 
>> at org.h2.engine.Engine.createSession(Engine.java:27) 
>> at 
>> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:331)
>>  at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:107) 
>> at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:91) 
>> at org.h2.Driver.connect(Driver.java:74) 
>> at org.h2.server.web.WebServer.getConnection(WebServer.java:684) 
>> at org.h2.server.web.WebApp.login(WebApp.java:958) 
>> at org.h2.server.web.WebApp.process(WebApp.java:212) 
>> at org.h2.server.web.WebApp.processRequest(WebApp.java:171) 
>> at org.h2.server.web.WebThread.process(WebThread.java:138) 
>> at org.h2.server.web.WebThread.run(WebThread.java:94) 
>> at java.lang.Thread.run(Unknown Source) 
>>
>> The database is used for a test management tool which I want to update.
>> Anyone could help ?
>>
>> Best regards
>>
>

-- 
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] Re: Cannot connect to an existing embedded database

['Ospeleo' via H2 Database]

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

-- 
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] Re: Cannot connect to an existing embedded database

['Ospeleo' via H2 Database]

If the h2 team is interested by this case (a Database that produces a "Unique 
index or primary key violation" error with 1.3.176 but opens perfectly with 
1.3.172, 
let me know. I cannot investigate the bug myself, but my problem is fixed.

Le jeudi 22 mai 2014 17:21:19 UTC+2, Ospeleo a écrit :
>
> 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]
>>  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


 



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