Eclipse Community Forums: EclipseLink

Help

Home

Home » Eclipse Projects » EclipseLink » HSQLDB Update schema

Show: Today's Messages :: Show Polls :: Message Navigator

HSQLDB Update schema [message #831711]

Thu, 29 March 2012 08:38

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?

Report message to a moderator

Re: HSQLDB Update schema [message #831938 is a reply to message #831711]

Thu, 29 March 2012 14:46

Chris Delahunt

Messages: 1266
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

Report message to a moderator

Previous Topic:	Persistence
Next Topic:	JDBC_SEQUENCE_CONNECTION_POOL deprecated but alternative not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 02:48:20 GMT 2017

.:: Contact :: Home ::.