Eclipse Community Forums: Dali » Generate entities from tables across multiple Oracle schemas

Home » Eclipse Projects » Dali » Generate entities from tables across multiple Oracle schemas(Foreign keys across Oracle schemas cannot be mapped to entities. Any workaround except manual editing?)

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

Generate entities from tables across multiple Oracle schemas [message #825910]

Wed, 21 March 2012 08:10

Matej Liszka
Messages: 7
Registered: March 2012

Junior Member

From time to time, you need to map entities from an existing database without the possibility to change the database structure. What if the following happens?
- Tables in Oracle database are organized in several schemas.
- Some of foreign keys are defined between tables across schemas.

I could succesfully sort that out in Microsoft's Entity Framework using the latest Oracle Data Access Components, where objects from multiple schemas could be selected in the wizard and accessed at the same time from one database connection. Associated entities were correctly generated for all such fields.

I however cannot find similar feature in EclipseLink entity generation wizard... It allows me to select only tables from one schema at the time.

Any hint to sort it out, without manually writing annotations, is appreciated! Thanks.

Report message to a moderator

Re: Generate entities from tables across multiple Oracle schemas [message #825983 is a reply to message #825910]

Wed, 21 March 2012 09:58

Neil Hauge
Messages: 460
Registered: July 2009

Senior Member

Unfortunately at this time we do not support generation across multiple schemas at the same time. In this case you would need to manually map these relationships after generation, which could be done in java or xml source, or in our JPA Details view, which would allow you to do the mapping in a rich UI.

This sounds like a good enhancement though, so please do enter an enhancement bug against Dali so we can add this support in the future.

https://bugs.eclipse.org/bugs/enter_bug.cgi?product=Dali%20JPA%20Tools

Thanks,
Neil

Report message to a moderator

Previous Topic:	Configure Default on New JPA Project Wizard
Next Topic:	Bug or a feature? @Column annotation is not always generated.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 29 01:20:50 EDT 2013