Having the same problem any solution to come out of this. using h2-1.3.160.jar and Apache-Tomcat-7.0.22. When tried to run recover option and recreate database found that create statement for some tables are found twice. What could be the reason for this?
On Monday, March 17, 2014 3:07:11 PM UTC+8, Dieter Cailliau wrote: > > Using version 1.3.168 (in jboss 7.2.0). > URL: jdbc:h2:/tmp/bms;DB_CLOSE_DELAY=-1;LOCK_TIMEOUT=5000 > > Database file is attached. > > Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key > violation: "SYS_ID ON PUBLIC.SYS(ID)" [23505-168] > »·······at > org.h2.message.DbException.getJdbcSQLException(DbException.java:329) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.message.DbException.get(DbException.java:169) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.message.DbException.get(DbException.java:146) > [h2-1.3.168.jar:1.3.168] > »·······at > org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:81) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.index.TreeIndex.add(TreeIndex.java:62) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.table.RegularTable.addRowsToIndex(RegularTable.java:327) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.table.RegularTable.addIndex(RegularTable.java:256) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.engine.Database.open(Database.java:619) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.engine.Database.openDatabase(Database.java:222) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.engine.Database.<init>(Database.java:217) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.engine.Engine.openSession(Engine.java:56) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.engine.Engine.openSession(Engine.java:159) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.engine.Engine.createSession(Engine.java:121) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.engine.Engine.createSession(Engine.java:28) > [h2-1.3.168.jar:1.3.168] > »·······at > org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:305) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92) > [h2-1.3.168.jar:1.3.168] > »·······at org.h2.Driver.connect(Driver.java:72) [h2-1.3.168.jar:1.3.168] > »·······at > org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:181) > [h2-1.3.168.jar:1.3.168] > »·······at > org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:331) > [h2-1.3.168.jar:1.3.168] > »·······at > org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:441) > > -- 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.