EJB programming & troubleshooting: Find method involving complecated Query
I need to write a find method which has to execute a query like this- "select * from table1 where column1 = xxx and column2 IN (select col2 from table2 where col2 = yyy)"
- Posted by: Murphy In
- Posted on: September 11 2000 18:24 EDT
Can I write this somehow in a CMP if yes plz tell me how.
Which App server are you using?
I am using Weblogic 5.1
I am not sure how Weblogic works, but some Appservers (i.e. Orion) allow you to specify complex queries for CMP beans in the deployment descriptors.