Bug 375016 - Generate entities from tables across multiple Oracle schemas at the time.
Summary: Generate entities from tables across multiple Oracle schemas at the time.
Status: NEW
Alias: None
Product: Dali JPA Tools
Classification: WebTools
Component: JPA (show other bugs)
Version: 2.3.2   Edit
Hardware: PC Windows 7
: P3 enhancement (vote)
Target Milestone: Future   Edit
Assignee: Neil Hauge CLA
QA Contact:
URL: http://www.eclipse.org/forums/index.p...
Whiteboard:
Keywords: ui, usability
Depends on:
Blocks:
 
Reported: 2012-03-22 02:55 EDT by Matej Liszka CLA
Modified: 2012-03-22 18:05 EDT (History)
2 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Matej Liszka CLA 2012-03-22 02:55:51 EDT 
Neil Hauge recommended me (in his answer to my topic on Dali forum) to enter an enhancement bug for this scenario:

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.



It would be nice to extend the Entity Generation wizard by the option to select tables across multiple schemas at once (with support for generating associated entities from foreign keys also between tables from different schemas).