Hi,
  One possibility,
 1. pre-load all lookup object instances (assuming the set is moderate). 
 2. Hold them in a collection.
    e.g.
   List lookups = em.createQuery('select x from LookUpObjects
x").getResultList();

 3. Use OpenJPAQuery.setCandidateCollection(lookups) to limit searches
within the pre-loaded collection.
    

-- 
View this message in context: 
http://n2.nabble.com/Retrieving-data-from-Lookup-Tables-tp1109950p1111187.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.


Reply via email to