migrating old db - enforce_strict_size

Hello,

I have an old hsqldb (<1.8) that unfortunately was not created with
enforce_strict_size=true.
Now we're migrating to version 2.3 and are running into "data exception:
string data, right truncation". Some varchar and double fields have values
larger than originally expected.

The migration process requires that the db be opened with 2.3, so the plan
is to:
1. open the db with enforce_strict_size=false
2. run an sql script that makes the problematic fields larger.
3. future uses of the db will use the default enforce_strict_size (of course
together with app-level data validation!)

The problem is with step 1. The following jdbc still gives the "data
exception" error.
jdbc:hsqldb:/Users/me/Documents/mydb/dbname;sql.enforce_strict_size=false

Any suggestions on how to open this db?
Thanks,
Bar 



--
View this message in context: http://hsqldb.10974.n7.nabble.com/migrating-old-db-enforce-strict-size-tp3951.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk