Writing Finder Methods Where Clause

[Meghana Reddy]

Hi all...
my intention is to write a finder method which takes an integer parameter(ie Salary) and tries to find the grade of that salary in the SALGRADE table of oracle.(SQL Query for this result is
"Select grade from SALGRADE where 2050 between losal and hisal")
i am using Visual Age for Java 4.0
eth goes fine till I invoke the findGradeForSal method in the Test Client of VAJ...
There i get the following error :
Exception is:
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
com.ibm.ejs.persistence.EJSPersistenceException: findSalBetween failed:; nested exception is:
java.lang.NullPointerException
Can Anyone suggest me a work around for this...???
I wrote the following finder method for the above query:
public static final findGradeForSalQueryString ="select T1.Grade from SalGrade T1 where
? >= T1.LoSal and ? <= T1.HiSal"
all other finder methods are working fine...Also
in the ibm-ejb-jar.xmi file the above finder is converted to a perfect SQL statement...
Thanks in Advance...

[Kyle Brown]

I don't think you understand what a Finder method should do. Your query only returns a single column, and if your EJB has only one field, then you've got a serious object design problem. :roll:
Finder methods should return ALL the fields in the database for an EJB -- not just one. A finder method literally means "find the EJB's that match some condition" -- it will, after all, return one ENTIRE EJB or a collection of entire EJB's -- not a partial answer...
So, instead, just use a "WHERE CLAUSE" finder method and only include the WHERE clause portion of your SQL statement. (Information on that is in the InfoCenter, or in my workbook.)
Kyle
[ January 31, 2002: Message edited by: Kyle Brown ]

[Meghana Reddy]

Thanks KYLE for ur help...it worked very fine...
Actually in the begining i wrote the following where clause finder method as
public static final String findGradeForSalWhereClause="? <= T1.HiSal and ? >= T1.LoSal" and i was passing only one parameter to the findGradeForSal in the home interface...so i was getting the error "All Variables not found" when i run the Visual Age Test Client.
i replaced the above query with "between" key word and could make it work...
Thanks KYLE ....Thanks for ur kind help...
Regards