[h2] Re: Number Format exception for search by uuid column, when uuid value is fetched from another table uuid column..

Hello. Your issue is not related with H2 in any way. Your application tries to read an UUID value with ResultSet.getLong() method, with this method you can read only numeric values. It looks like your column has different incompatible data types in your entity and in your table or something els

[h2] Table not found after ALTER table - leftover "_COPY_" table

I have an application that uses H2 v1.4.199, with versioning provided by Flyway. For roughly 25% of the users, this migration ends up in an unusual state. The migration is performing a number ALTER TABLE commands (typically dropping columns) on one database (lets call the table "fruits"). When

[h2] Re: Table not found after ALTER table - leftover "_COPY_" table

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-qualifi

[h2] Re: Table not found after ALTER table - leftover "_COPY_" table

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.mes