Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » HSQLDB Update schema
HSQLDB Update schema [message #831711] Thu, 29 March 2012 04:38 Go to next message
pdvmipv Mising name is currently offline pdvmipv Mising name
Messages: 12
Registered: October 2010
Junior Member
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?

Re: HSQLDB Update schema [message #831938 is a reply to message #831711] Thu, 29 March 2012 10:46 Go to previous message
Chris Delahunt is currently offline Chris Delahunt
Messages: 1018
Registered: July 2009
Senior Member
Hello,

EclipseLink nightly builds include
https://bugs.eclipse.org/bugs/show_bug.cgi?id=368365
also described here:
http://wiki.eclipse.org/EclipseLink/DesignDocs/368365
This feature can be used to create new tables or add missing fields to existing tables that might help with what you are looking for. It cannot change field types or drop unused fields or tables since that might result in data loss though.

Best Regard,
Chris
Previous Topic:How to compile eclipselink codebase
Next Topic:Persistence
Goto Forum:
  


Current Time: Sat Aug 30 00:24:08 EDT 2014

Powered by FUDForum. Page generated in 0.02452 seconds