Eclipse Community Forums: EclipseLink » Hibernate to eclipselink port, multiple entity class search

Help

Home

Home » Eclipse Projects » EclipseLink » Hibernate to eclipselink port, multiple entity class search

Show: Today's Messages :: Show Polls :: Message Navigator

Hibernate to eclipselink port, multiple entity class search [message #726420]

Sun, 18 September 2011 00:52

Jonathan

Messages: 6
Registered: August 2011

Junior Member

I'm currently attempting to port a hibernate application to eclipselink for multi-tenancy support.

One of the things I'm struggling with is querying multiple entity classes. Hibernate allows you to perform queries such as:

Select a, b, c From Apple a, Banana b, Cat c WHERE a.id = b.id AND c.id = a.id

Hibernate manages performing a cartesian join. I know this isn't ideal and I don't have access to the JPQL that is being sent over the wire. In eclipselink I find that I can't seem to do the same thing. It attempts to choose the first class in the FROM statement as the reference class. It will then blow up if you try and reference any of the other entities within the WHERE clause.

Are there any suggestions? I've started tinkering with unwrapping the entitymanager and issuing queries with the readallquery but with no luck.

I'm currently using eclipselink 2.3.0 (I have also attempted with 2.3.1-M5 with no luck).

Any help or suggestions would be greatly appreciated.

Report message to a moderator