Skip to main content

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 12:10 Go to next message
Matej Liszka is currently offline Matej LiszkaFriend
Messages: 13
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 13:58 Go to previous message
Neil Hauge is currently offline Neil HaugeFriend
Messages: 475
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.

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 Jun 19 04:26:26 GMT 2021

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

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

Back to the top