|(no subject) [message #726426]
||Sun, 18 September 2011 00:52
Registered: July 2009
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.
Powered by FUDForum
. Page generated in 0.03536 seconds