I am trying to get 1.2.147 into production and want to utilize the
auto-upgrade feature from 1.1->1.2 by way of having
h2mig_pagestore_addon.jar in the classpath.
It's been failing with the error
Caused by: org.h2.upgrade.v1_1.jdbc.JdbcSQLException:
File not found: "C:\tmp\guidewire\PC_SAVE2\pc.lobs.db\1.t21.lob.db";
SQL statement:
script to 'C:\tmp\guidewire
\PC_SAVE2\pc.data.db_script.sql' [90124-128]
at org.h2.upgrade.v1_1.message.Message.getSQLException(Message.java:
110)
at org.h2.upgrade.v1_1.message.Message.getSQLException(Message.java:
121)
at org.h2.upgrade.v1_1.message.Message.getSQLException(Message.java:
74)
at org.h2.upgrade.v1_1.engine.Database.openFile(Database.java:495)
at org.h2.upgrade.v1_1.value.ValueLob.getInputStream(ValueLob.java:
654)
After some head scratching because that file IS there, I set a method
break-point at getSQLException() and discovered that the file is
missing because the upgrade procedure is renaming the folder
pc.lobs.db to pc.lobs.db.backup which will of course cause the failure
if it is looking for the original folder name. When the upgrade fails
it renames it back (as well as removing the xx_script.sql file) so it
covers its tracks and leaves this error a mystery.
Simple bug?
Thanks
Randy
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
