Eclipse Community Forums: EclipseLink » Adding new column in an exsisting table

Help

Home

Home » Eclipse Projects » EclipseLink » Adding new column in an exsisting table(without deleting old table)

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

Adding new column in an exsisting table [message #698796]

Wed, 20 July 2011 04:38

Sergei Jochim
Messages: 6
Registered: July 2011

Junior Member

Hi All!!!

I want to add a new column to an exsisting table, through adding a new property to an entity. My hope is not to loose data and references in table.

with:

<property name="eclipselink.ddl-generation" value="create-tables" />

I can only add new tables, but cannot update exsisting.

Is there any possibilily except using extensions, because using extensions I have to drop and create tables?

wiki.eclipse.org/EclipseLink/Examples/JPA/Extensible

Report message to a moderator

Re: Adding new column in an exsisting table [message #701860 is a reply to message #698796]

Mon, 25 July 2011 13:29

James Sutherland
Messages: 1844
Registered: July 2009

Senior Member

James : Wiki : Book : Blog

Report message to a moderator

(no subject) [message #701912 is a reply to message #698796]

Mon, 25 July 2011 13:29

James
Messages: 272
Registered: July 2009

Senior Member

EclipseLink does not support altering existing tables. You need to either re-create the schema (drop-and-create-tables), or write your own alter table scripts.

Please log an enhancement request for alter table support.

--
James : http://wiki.eclipse.org/EclipseLink : http://en.wikibooks.org/wiki/Java_Persistence : http://java-persistence-performance.blogspot.com/

Report message to a moderator

Previous Topic:	(no subject)
Next Topic:	[JPA]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 14:11:53 EDT 2013