This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hello, I'm trying to create a finder in a container-managed EJB, with optional parameters. What do I mean? Well, I'm looking for certain data in my tables which occur within a certain date interval. I would like to use a single method for this: findDataInInterval(Integer type, Date occursAfterThisDate, Date occursBeforeThisDate) Which can conceivably generate at least 4 SQL queries (using a EJB-QL'ish syntax): select * from my table where type = ?type select * from my table where type = ?type and mydate > ?occursAfterThisDate select * from my table where type = ?type and mydate < ?occursBeforeThisDate select * from my table where type = ?type and mydate > ?occursAfterThisDate and mydate < ?occursBeforeThisDate Is there a way to generalise the four queries into one entry, so that the mydate clauses are ignored if either (or both) dates are null? Thanks, L
Hi Laurent, Those look like four different custom finders to me. Regards,
Howard Kushner<br />IBM Certified Enterprise Developer - WebSphere Studio Application Developer V5.0<br />IBM Certified Advanced System Administrator - WebSphere Application Server V5.0<br />IBM Certified Solution Developer - Web Services with WebSphere Studio V5.1<br /><a href="http://www.amazon.com/exec/obidos/tg/detail/-/1931182108/" target="_blank" rel="nofollow">Developing J2EE Applications with WebSphere Studio</a> my Certification Study Guide for IBM Test 287