[Crasht51]

I would like to use JPA to access oracle db tables in 2 different schemas. I have not been able to get this to work with MyEclipse. In my persistence.xml I have defined 2 <persistence-unt>’s, but the file com.genuitec.eclipse.persistence.jpa.prefs seems to support just one connection. Can this be done in MyEclipse?

Thanks – Jon P.

[Riyad Kalla]

Jon,
You can go to the DB Explorer and rev-eng the entities from the two schemas separately, but the project validation is only run against the single PU you have associated with the project.

[Crasht51]

This message has not been recovered.

[Riyad Kalla]

This message has not been recovered.

[Deven Phillips]

Definitely put my vote on that enhancement too. Our ERP application uses about 16 different schemas and relates tables between them. It’s a necessity in my environment to perform joins across schemas daily.

[Riyad Kalla]

DSpair, it’s still on our list of enhancements, but it’s a pretty far-reaching one (touches bits of the validation parsers, content assist parsers, re-eng tools for Hib and JPA, etc. etc.) so a fairly expensive feature to build.

[Author]

Posts