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 <[email protected]> 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 [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
