1 Reply Latest reply on May 3, 2002 11:14 PM by Dain Sundstrom

    custom finder using "IN" clause

    Mark Kent Newbie

      I've been using finder with single primary key values and "=" in my tagson an Oracle 8i database.

      i.e. location_id = {0}

      This works great for single PK values, but I'd like to add an "IN" clause to be able to check for multiple PK values at once.

      i.e. location_id IN {0}

      Problem: how do I declare this for JBoss? I tried creating a Java "String" of "(40,41)" to use for the "{0}" part, but I got an Oracle error telling me it was an invalid number as it was trying to insert a VARCHAR in the place of the "expected" Integer value.

      Any ideas? Thanks!