Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to write this find Query Element

Status
Not open for further replies.

bnadesan

Programmer
Oct 16, 2002
2
US
Hi Everybody,

I'm totally new to EJB, I have been trying to run a EJB program but in the mid way I faced a problem in weblogic-cmp-rdbms-jar.xml file. This is regarding the finder-query element.

My xml defination is like this
<finder>
<finder-name>findInRange</finder-name>
<finder-param>float</finder-param>
<finder-param>float</finder-param>
<finder-query>taxRate BETWEEN $0 AND $1</finder-query>
</finder>

The findInRange function take two float values as argument and I wanted the SQL to be something like

SELECT taxRate FROM TAXEJBTABLE WHERE taxRate BETWEEN $0 AND $1

How do I give this statement in the finder-query elemnt

Any Sort of help/hints will be appreciated...
Thanks...
bnadesan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top