3 Replies Latest reply on Jul 4, 2003 6:40 AM by Juha Lindfors

    EJB QL Collection input parameter ?

    reeves Newbie

      Hi I'm using Cmp2.0 and I've got a problem
      on my finder.
      What I want is somethink like that :
      Find all user where user.userId is IN ('id1','id2','...')
      and 'id1','id2','... is my input parameter as a collection.

      * @ejb.finder
      * signature="Collection findByMultipleUserId(java.util.Collection col)"
      * query="SELECT OBJECT(u) FROM User u where u.userId in (?1)"

      But until now, I have not seen any example with collection as input parameter? Is it possible ?

      Any idea ?
      Thanks in advance.