Hi, Were you able to find the cause as I am also getting the same issue in my application.
Thanks, Shubham On Monday, 1 March 2021 at 16:22:44 UTC+5:30 [email protected] wrote: > Hi, just wondered if there were any more thoughts? > > On Thursday, 4 February 2021 at 16:04:58 UTC [email protected] wrote: > >> Apologies, I had already tried this in the environment the database was >> created with, using H2 1.4.199 and got the following error: >> 2021-01-25 14:57:04,226 ERROR main h2database - mydatabase:database >> opening mydatabase >> org.h2.message.DbException: Table "FRUITS" not found [42102-199] >> at org.h2.message.DbException.get(DbException.java:205) >> at org.h2.message.DbException.get(DbException.java:181) >> at >> org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:108) >> at >> org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:78) >> at org.h2.engine.MetaRecord.execute(MetaRecord.java:60) >> at org.h2.engine.Database.open(Database.java:842) >> at org.h2.engine.Database.openDatabase(Database.java:319) >> at org.h2.engine.Database.<init>(Database.java:313) >> at org.h2.engine.Engine.openSession(Engine.java:69) >> at org.h2.engine.Engine.openSession(Engine.java:201) >> at org.h2.engine.Engine.createSessionAndValidate(Engine.java:178) >> at org.h2.engine.Engine.createSession(Engine.java:161) >> at org.h2.engine.Engine.createSession(Engine.java:31) >> at >> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:336) >> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:169) >> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:148) >> at org.h2.Driver.connect(Driver.java:69) >> at >> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) >> ... more >> Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "FRUITS" not >> found; SQL statement: >> ALTER TABLE PUBLIC.FRUITS ADD CONSTRAINT PUBLIC.CONSTRAINT_23 PRIMARY >> KEY(ID) INDEX PUBLIC.PRIMARY_KEY_23 [42102-199] >> at org.h2.message.DbException.getJdbcSQLException(DbException.java:451) >> at org.h2.message.DbException.getJdbcSQLException(DbException.java:427) >> ... 80 more >> >> This isn't related to switching versions, I just recreated it to get the >> logs on the wrong version. >> >> On Thursday, 4 February 2021 at 15:22:14 UTC Evgenij Ryazanov wrote: >> >>> Hello. >>> >>> Error code 42102-200 is from H2 1.4.200, you should not try to use both >>> 1.4.199 and 1.4.200 with the same database file. >>> >>> If you have a database with corrupted metadata, you can add >>> ;DATABASE_EVENT_LISTENER='path.to.Listener' >>> to the connection url, where path.to.Listener is a fully-qualified class >>> name. >>> Your class must implement org.h2.api.DatabaseEventListener and it needs >>> public no-arg constructor. >>> >> -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/91c771f9-8bd1-408c-984a-9f6ab6ed98adn%40googlegroups.com.
