Thank you Evgenij, It seems to work. Meni
On Tue, Aug 6, 2019 at 1:34 AM Evgenij Ryazanov <[email protected]> wrote: > 1.4.196 and older versions have a problem with some constraints. This > issue was fixed in 1.4.197, but the fix isn't fully compatible with older > databases. Execution of DDL command in 1.4.197 in the database that was > initially created by some older version may corrupt a database. This issue > was fixed for default MVStore engine and wasn't fixed for legacy PageStore > engine (there is a separate issue on GitHub for it). > > I suggest you to use the recommended way to upgrade your databases. > > 1. Execute a > SCRIPT TO 'filename.sql' > command with old version of H2. > > 2. Create a new empty database with a new version of H2 and execute a > RUNSCRIPT FROM 'filename.sql' > > You can also use the Java tools as described in the documentation: > https://h2database.com/html/tutorial.html#upgrade_backup_restore > > Usually it's not really required and database can be used as it, but due > to large amount of changes in recent releases it's much safer to use the > recommended way. > > If you don't have a backup copy you can add SET_EVENT_LISTENER parameter > to the connection URL: > https://h2database.com/html/commands.html#set_database_event_listener > The listener must implement org.h2.api.DatabaseEventListener interface. > With such listener some exceptions can be ignored. > You need to check a content of the database with H2 Console and fix the > problems. > > -- > You received this message because you are subscribed to a topic in the > Google Groups "H2 Database" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/h2-database/jsWQhRGORnw/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/h2-database/7d35d455-f1ae-4a77-8c59-d5740b0c92f1%40googlegroups.com > <https://groups.google.com/d/msgid/h2-database/7d35d455-f1ae-4a77-8c59-d5740b0c92f1%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAKFq1VuF3XO6n0c7DZSWXESO0BYq97ME_X%3DUNOVYo7Jq%3D561AA%40mail.gmail.com.
