From: <glassfish_at_javadesktop.org>
Date: Wed, 15 Jul 2009 17:47:45 PDT

Hi: I am using JPA Query to join two tables and experience out of memory exception.

I wonder if the EntityManager actually retrieve all data in two tables first and then perform join? Or it does translate join directly into SQL and retrieve the join result back?

And is there a way to resolve this performance issue. Should I use native SQL statement in this case?

Thanks.
[Message sent by forum member 'liu_wayne10' (liu_wayne10)]

http://forums.java.net/jive/thread.jspa?messageID=355872