Custom finders help neeeded
mdramit May 20, 2003 9:29 AMHi,
I am trying to implement a custom finder. I have an entity EJB with CMP.
I have coded a custom finder method findCheapAuctions in the bean home interface:
public Collection findCheapAuctions(int startP)
throws FinderException, remoteException;
and then I have coded the following on jaws.xml :
Hypersonic SQL
<type-mapping>Hypersonic SQL</type-mapping>
<enterprise-beans>
<ejb-name>Auction8EJB</ejb-name>
<table-name>AUCTION8</table-name>
<cmp-field><field-name>auctionId</field-name><column-name>AID</column-name></cmp-field>
<cmp-field><field-name>organizerId</field-name><column-name>OID</column-name></cmp-field>
<cmp-field><field-name>resourceId</field-name><column-name>RID</column-name></cmp-field>
<cmp-field><field-name>description</field-name><column-name>DESCR</column-name></cmp-field>
<cmp-field><field-name>startDate</field-name><column-name>STARTD</column-name></cmp-field>
<cmp-field><field-name>endDate</field-name><column-name>ENDD</column-name></cmp-field>
<cmp-field><field-name>comments</field-name><column-name>COMMENTS</column-name></cmp-field>
<cmp-field><field-name>startPrice</field-name><column-name>STARTP</column-name></cmp-field>
<cmp-field><field-name>auctionType</field-name><column-name>AUCTYPE</column-name></cmp-field>
<cmp-field><field-name>auctionHistory</field-name><column-name>AUCHISTORY</column-name></cmp-field>
<cmp-field><field-name>bidIncrement</field-name><column-name>BIDINC</column-name></cmp-field>
<cmp-field><field-name>auctionWinnerId</field-name><column-name>AUCWINNERID</column-name></cmp-field>
<cmp-field><field-name>auctionPrice</field-name><column-name>AUCPRICE</column-name></cmp-field>
findCheapAuctions
startPrice < {0}
startPrice DESC
</enterprise-beans>
However, I keep getting the following error:
Bean : Auction8EJB
Method : public abstract Collection findCheapAuctions(int) throws FinderException, RemoteException
Section: 10.5.6
Warning: Every finder method except findByPrimaryKey(key) must be associated with a query element in
the deployment descriptor.
Any ideas what I might have done wrong? I guess I must have a mistake on my jaws.xml file? I have tried to solve this for a long time but failed, so any help is appreciated.
Thanks in advance for your help!
Manos