java - Converting h2 database from h2.db to mv.db -

i converting old h2 databases (with h2.db extension) newer mv database engine. in tables of database have problem stricter engine.

just select * error, latest h2-1.4.187.jar... cannot open data anymore...

the error in timestampvalue:

general error: "java.lang.illegalargumentexception: timenanos out of range 86400656000000"; sql statement: select * purchases_divided [50000-187] 

i using embedded way.

now try find rows using old jar (h2-1.3.173.jar)

but cannot quite resolve way how find troubled rows.. because query in old database seem work, , no errors catched...

anybody clue how solve this?

i thought of select troubled rows old jar in db table, , fix timestamp field there.... , open new jar....

but need find way select them...

i found 'best of worse' solution:

when use recover function, can create sql dump file, , load in new database. (with new version jar well).

it generate errors on rows cannot read, rest done. corrupted rows generate error message. sql dump file able fix it.... lot of handwork, done.

still hoping better solution given else.