Oops! Following is my EJB finder definitions for CardHistory CMP:
* @ejb.finder * signature = "java.util.Collection findAllByParamAndCard(java.lang.Integer cardHistoryParamID, java.lang.String serialNo)" * query = "SELECT OBJECT(p) FROM CardHistory as p WHERE p.cardHistoryParamID = ?1 AND p.serialNo = ?2 ORDER BY p.cardHistoryParamID, p.pollTime" * unchecked = "true" * * @ejb.finder * signature = "java.util.Collection findByParamCardAndRecentThan(java.lang.Integer cardHistoryParamID, java.lang.String serialNo, java.util.Date d)" * query = "SELECT OBJECT(p) FROM CardHistory as p WHERE p.cardHistoryParamID = ?1 AND p.serialNo = ?2 AND p.pollTime > ?3 ORDER BY p.cardHistoryParamID, p.pollTime" * unchecked = "true" * * @ejb.finder * signature = "java.util.Collection findByOlderThanDate(java.sql.Timestamp ts)" * query = "SELECT OBJECT(p) FROM CardHistory as p WHERE p.pollTime < ?1 ORDER BY p.serialNo, p.cardHistoryParamID, p.pollTime" * unchecked = "true" View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3844708#3844708 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3844708 ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user