Skip to main content



      Home
Home » Eclipse Projects » EclipseLink » HSQLDB Update schema
HSQLDB Update schema [message #831711] Thu, 29 March 2012 04:38 Go to next message
Eclipse UserFriend
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
Eclipse UserFriend
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 Jul 14 21:24:43 EDT 2025

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

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

Back to the top