Hi I want to find some entities by their keys key1,key2,key3. I can do this by:
findByPrimaryKey(key1) findByPrimaryKey(key2) findByPrimaryKey(key3) in this way 3 sql select are processed (SELECT ... WHERE id=?1) Is somthing like this possible: Collection c = new Collection() c.add(key1) c.add(key2) c.add(key3) findByKeys(c) so that there is only one sql select processed (SELECT ... WHERE id=?1 OR id=?2 OR id=?3) Is there a EJB QL notation that can do this? regards, Sven View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3890356#3890356 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3890356 ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
