|HSQLDB Update schema [message #831711]
||Thu, 29 March 2012 04:38
| pdvmipv Mising name
Registered: October 2010
I move a DB structure from Oracle 11g to HSQLDB embedded throught java code.|
I create the Oracle DB in SQL Developer, then mapping the DB throught NetBeans in java class.
Now I create from this structure an embedded DB in HSQLDB at the run of my application.
I have this problem:
When I change my Oracle DB structure, I recreate the class of my persistence throught NetBeans, but now if i try to read an HSQLDB file already created with the old class of persistence it doesn't work, beacause the DB doesn't represent the structure of class.
There is a way to update the DB HSQLDB from the new schema without writing manually the ALTER TABLE query? and without losing any data?
Powered by FUDForum
. Page generated in 0.01521 seconds