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?)

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

Wed, 21 March 2012 08:10

Eclipse User

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

Eclipse User

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:

-=] Back to Top [=-

Current Time: Mon Jul 28 11:01:02 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter