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 08:38 Go to next message
pdvmipv Mising name is currently offline pdvmipv Mising nameFriend
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 14:46 Go to previous message
Chris Delahunt is currently offline Chris DelahuntFriend
Messages: 1039
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: Mon Dec 22 02:50:35 GMT 2014

Powered by FUDForum. Page generated in 0.01689 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software