0 Replies Latest reply on Mar 21, 2003 1:28 PM by Robert Sichky

    Arrays as parameters in enterprise bean query methods.

    Robert Sichky Newbie

      I am using v3.0.4 and I have several instances of finder methods for which I have to create a definition where I would like to pass in a parameter to fulfill an IN clause -- as in "TABLE.ID IN (?,?,?)". Can this be done (an array of "int" would suffice)? And, if so, what is the syntax for the <method-param> tag and how do I reference this parameter in the SQL? Can it be done via the <ejb-ql> tag in the "ejb-jar.xml" or must it go in the <declared-sql> of the "jbosscmp-jdbc.xml" file?

      Any help would be appreciated.