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 04:38

pdvmipv Missing name is currently offline

pdvmipv Missing name
Messages: 8
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

[Message index]

		HSQLDB Update schema By: pdvmipv Missing name on Thu, 29 March 2012 04:38
		Re: HSQLDB Update schema By: Chris Delahunt on Thu, 29 March 2012 10:46

Previous Topic:	How to compile eclipselink codebase
Next Topic:	Persistence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 20:40:50 EDT 2013