custom finder using "IN" clause

[mkent]

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!

[dsundstrom]

You can't; that's the way SQL parameters work.