Hi, I'm afraid you will need to manually edit the SQL script file.
> 1.3.160 That's quite old, many bugs have been fixed since then. I suggest to upgrade to a more recent (1.3.x) version. Regards, Thomas On Saturday, July 26, 2014, Sanchand <sangli.mu...@gmail.com> wrote: > 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 > <javascript:_e(%7B%7D,'cvml','h2-database%2bunsubscr...@googlegroups.com');> > . > To post to this group, send email to h2-database@googlegroups.com > <javascript:_e(%7B%7D,'cvml','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.
