Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Modify schema using persistence layer
Modify schema using persistence layer [message #1061155] Thu, 30 May 2013 09:30 Go to next message
Florian Pirchner is currently offline Florian Pirchner
Messages: 87
Registered: July 2009
Member

Hi,

i wonder if there is a way to modify a table schema using the eclipse link api.

For instance XYZEntity:
Property address : String was changed to deliveryAddress : String.

For normal i would have to prepare DDL-Statements for each used Database. (ALTER TABLE XYZ change ....)

But i want to avoid writing DDLs in database specific SQL-Language.

Is there a way to tell eclipse-link api to do that for me?

Thanks a lot
Florian
Re: Modify schema using persistence layer [message #1061265 is a reply to message #1061155] Thu, 30 May 2013 21:06 Go to previous messageGo to next message
Tom Eugelink is currently offline Tom Eugelink
Messages: 807
Registered: July 2009
Senior Member
Liquibase is a good tool for maintaining database independent migration scripts.

Personally I prefer treating databases a first class citizens, and not rely on Eclipselink to modify tables.

Tom



On 2013-05-30 11:30, Florian Pirchner wrote:
> Hi,
>
> i wonder if there is a way to modify a table schema using the eclipse link api.
>
> For instance XYZEntity:
> Property address : String was changed to deliveryAddress : String.
>
> For normal i would have to prepare DDL-Statements for each used Database. (ALTER TABLE XYZ change ....)
>
> But i want to avoid writing DDLs in database specific SQL-Language.
>
> Is there a way to tell eclipse-link api to do that for me?
>
> Thanks a lot
> Florian
Re: Modify schema using persistence layer [message #1061313 is a reply to message #1061265] Fri, 31 May 2013 07:53 Go to previous message
Florian Pirchner is currently offline Florian Pirchner
Messages: 87
Registered: July 2009
Member

Thanks a lot. Will try liquibase
Previous Topic:Model-Evolution best practices
Next Topic:Unidirectional OneToMany Insert
Goto Forum:
  


Current Time: Wed Oct 01 22:27:21 GMT 2014

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

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