Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

IN clause in finder method  RSS feed

 
Sivakumar Nachimuthu
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hai all,
iam using jboss 3.0 and mysql.i want to use the IN clause in the finder method.

the finder method gives the following error while deployment.




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
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!