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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/80f54b45-f633-499a-82f0-feee0fa40c9bn%40googlegroups.com.
