[rmcvay]

We’ve run across a couple of major problems with the JPA reverse engineering tooling in ME 6.6.

1. It is impossible to perform reverse engineering against tables that are in more than one schema. (This is not a JPA limitation.)
2. The reverse engineering wizard can only see tables, not views. If you attempt to add JPA to a project where the persistence is in a view, the wizard can’t complete and the project is left in a limbo state re JPA capability.

[Brian Fernandes]

1) While the tooling support like the JPA Details view and validation may not work (you will have to turn metadata analysis off on the MyEclipse > Java Persistence property page), it should still be possible for you to reverse engineer.
From the DB Browser view, select the tables you wish to RE and choose “JPA Reverse engineering” from the context menu. The tool will not however allow you to reverse engineer from tables in multiple schema at the same time, however, you can do this in two separate passes. Cross schema relationships, if any, will not be picked up by the tool.

Could you tell us a little more about your environment?
a) What database are you using? Are you using a database like MS SQL Server / Sybase where you have multiple schemas in a catalog?
b) Do you have relationships between tables in different schemas?

2) Unfortunately it is too late to fix this for 7.0, but we will take care of it in the first release following that.

Sorry for the inconvenience caused.

[rmcvay]

1) Thanks for the tips. I’ll pass them on.

a) DB2 on Z/OS where it’s common to have apps dealing with data in a multitude of schemas
b) the relationships are not defined in the database

That (b) sort of brings up another commonly needed but unavailable function, the ability to define essentially ad hoc foreign key relationship in the data modeling tools.

2) Cool.

[Nico Drapier]

Hi,

Is it possible, that this issue isn’t solved yet in the MyEclipse For Spring version 8.6?

Kind Regards,
Nico

[jkennedy]

Nico,
Are you using the Scaffolding wizard for DB Reverse Engineering or the right click menu in the data source / table viewer?

The MyEclipse For Spring product includes the scaffolding wizard which uses a different approach to reverse engineering although I am not certain it solves your problem.

Since the relationships are not stored in the DB you may be able to get the effect you want by rerunning the scaffolding wizard for each schema to generate the JPA/DAO/Service layer for each table.

Let me know if this helps.

Thanks,
Jack

[Author]

Posts