How to write this find Query Element

Greenhorn

Posts: 2

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

These are the worst of times and these are the best of times. And this is the best tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser