openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From QkI <>
Subject RE: Unnecesery INNER JOIN
Date Fri, 16 Jul 2010 05:52:20 GMT

>From my point of view, there shouldn't be any joins and correct SQL output
should look like:
SELECT b.a_id FROM table_b b WHERE = 123

I try to limit unnecesery joins in my queries, because in the case of
pessimistic locking this behavoiur locks too much.

By the way previously I was using hibernate and this framework doesn't add
unnecesery joins. 

View this message in context:
Sent from the OpenJPA Users mailing list archive at

View raw message