| Author |
Optional parameters in EJB QL?
|
L Duperval
Ranch Hand
Joined: May 14, 2003
Posts: 63
|
|
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
|
Live Free, Live Happy
|
 |
Howard Kushner
author
Ranch Hand
Joined: Sep 19, 2003
Posts: 361
|
|
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
|
 |
 |
|
|
subject: Optional parameters in EJB QL?
|
|
|