1 Reply Latest reply on Jul 22, 2002 4:22 PM by John-Luc Bakker

    custom finder syntax & generation

    John-Luc Bakker Newbie

      Dear all,

      I use Hypersonic and JBoss 3.0.0. I defined a finder "userId={0} AND serviceId={1}". Both fields are mentioned in the ejb-jar.xml. The finder's name is findUserService and the same as the one in the signature of the Home class.

      Yet, in the server log I cannot find proof whether the apropriate finder is created. Worse, when I execute the finder I get an empty Collection where I based on the data in the database would have expected one value in the Collection ...

      Any suggestions?

      More details below:

      I defined the finder as follows:

      public Collection findUserService(String userId, String serviceId) throws FinderException,RemoteException;

      and


      findUserService
      userId={0} AND serviceId={1}
      userId DESC


      Regards,

      John-Luc