Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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?)
icon4.gif  Generate entities from tables across multiple Oracle schemas [message #825910] Wed, 21 March 2012 08:10 Go to next message
Matej Liszka is currently offline 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.
Re: Generate entities from tables across multiple Oracle schemas [message #825983 is a reply to message #825910] Wed, 21 March 2012 09:58 Go to previous message
Neil Hauge is currently offline Neil Hauge
Messages: 467
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
Previous Topic:Configure Default on New JPA Project Wizard
Next Topic:Bug or a feature? @Column annotation is not always generated.
Goto Forum:
  


Current Time: Sat Apr 19 06:01:11 EDT 2014

Powered by FUDForum. Page generated in 0.01677 seconds