JBoss 2.4.x: WHERE clause with IN operator

elljay Oct 11, 2001 11:07 AM

Is there a way to make JBoss 2.4.x (i.e. JAWS for CMP 1.1)
understand the IN operator in a finders WHERE clause?

E.g. I'd like to define a finder like

findByPreferredFlavors
flavor IN ({0})

where flavor is a java.lang.String cmp field and
parameter {0} is a java.lang.String[] containing
preferred flavors.

Thanks,
Elljay

1. Re: JBoss 2.4.x: WHERE clause with IN operator

emdevlin Nov 4, 2001 10:27 AM (in response to elljay)

I also had a case where I wanted to do something like this, but didn't pursue it since it didn't seem like it would work. Once the statement is prepared, no more parameters could be added. Have you had any luck?
Actions