[h2] Re: Cannot connect to an existing embedded 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]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/AD0/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.
[h2] Re: Error when opening the database a second time
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.init(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.init(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.init(JdbcConnection.java:107) at org.h2.jdbc.JdbcConnection.init(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
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]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/AD0/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.
[h2] Re: Cannot connect to an existing embedded 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]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/AD0/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.
[h2] Re: Cannot connect to an existing embedded 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]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/AD0/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.
[h2] Re: Cannot connect to an existing embedded 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]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/AD0/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.
[h2] Re: Error when opening the database a second time
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.init(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.init(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.init(JdbcConnection.java:107) at org.h2.jdbc.JdbcConnection.init(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] Cannot connect to an existing embedded 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 https://lh3.googleusercontent.com/-oleaDCRp1cM/U3t30O5n70I/AD0/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.