Hello. It looks like you updated version of H2 database to 1.4.197 from some older version, executed a DDL command after it, and closed the database. There is an incompatible change in this version.
The safe way to update your database to 1.4.197 format is to export it to SQL with SCRIPT TO 'filename.sql` command in old version, create a new database with a new version and execute RUNSCRIPT FROM 'filename.sql`. Usually it's not required, but not in this case. If you don't have a backup copy, specify a database listener in database URL parameter: ;DATABASE_EVENT_LISTENER='sample.MyListener' Listener should be in your classpath and implement org.h2.api.DatabaseEventListener. http://www.h2database.com/javadoc/org/h2/api/DatabaseEventListener.html If database will be opened, use SCRIPT TO / RUNSCRIPT FROM to create a new database. This regression in 1.4.197 was fixed (for MVStore databases only), so upgrade from 1.4.196 to upcoming 1.4.198 should not lead to such problems, but your database was already damaged by 1.4.197. Also it's possible that your database was corrupted due to another reason. -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
