openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pinaki Poddar <ppod...@apache.org>
Subject Re: Retrieving data from Lookup Tables
Date Tue, 23 Sep 2008 01:14:34 GMT

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.


Mime
View raw message