Eclipse Community Forums: EclipseLink » Modify schema using persistence layer

Help

Home

Home » Eclipse Projects » EclipseLink » Modify schema using persistence layer

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

Modify schema using persistence layer [message #1061155]

Thu, 30 May 2013 09:30

Florian Pirchner

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

Report message to a moderator

Re: Modify schema using persistence layer [message #1061265 is a reply to message #1061155]

Thu, 30 May 2013 21:06

Tom Eugelink

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

Report message to a moderator