IN clause in finder method

[Sivakumar Nachimuthu]

hai all,
iam using jboss 3.0 and mysql.i want to use the IN clause in the finder method.

@ejb.finder
 *    signature="java.util.Collection findFrequency(java.lang.String temp)"
 *    query="SELECT DISTINCT OBJECT(o) FROM Frequency o"
 * @jboss.query
 *    signature="java.util.Collection findFrequency(java.lang.String temp)"
 *    query="SELECT DISTINCT OBJECT(o) FROM Frequency o WHERE o.frequncyId IN (?1)"
  

the finder method gives the following error while deployment.

org.jboss.deployment.DeploymentException:
 Error compiling JBossQL statement 
'SELECT DISTINCT OBJECT(o) FROM Frequency o WHERE o.frequencyId IN (?1)';
 - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: 
Encountered "o.frequencyId" at line 1, column 49.
Was expecting:
     AVG
     SUM
     MAX...........
..........
  

plz help me to implement IN clause in EJB.

Thanks
Siva

[ November 30, 2004: Message edited by: Sivakumar Nachimuthu ]
[ December 09, 2004: Message edited by: Sivakumar Nachimuthu ]

[Sivakumar Nachimuthu]

Hi all,
i came to know that IN clause with variable as a argument is not supported in EJB.
i have written session bean to search the DB using JDBC.So i get the result set.But in previous cases of Add,Modify,View...i display the results in JTable as remote interfaces.
i have two possible solutions here.
1) For every row of reultset ,use the findByPrimaryKey method and get the remote interfaces and store them in JTable.
but if i use this,i have to go to the database again and again for the already collected data.

2) Create the diff table model to use the custom objects returned from result set.
but i have to handle two diff objects in the JTable,which will complicate further operations.

suggest me a good solution.

Thanks
Siva