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)"
Can I write this somehow in a CMP if yes plz tell me how.
-
Find method involving complecated Query (3 messages)
- Posted by: Murphy In
- Posted on: September 11 2000 18:24 EDT
Threaded Messages (3)
- Find method involving complecated Query by Damian Guy on September 12 2000 00:49 EDT
- Find method involving complecated Query by Murphy In on September 12 2000 13:00 EDT
- Find method involving complecated Query by Damian Guy on September 12 2000 10:39 EDT
- Find method involving complecated Query by Murphy In on September 12 2000 13:00 EDT
-
Find method involving complecated Query[ Go to top ]
- Posted by: Damian Guy
- Posted on: September 12 2000 00:49 EDT
- in response to Murphy In
Which App server are you using? -
Find method involving complecated Query[ Go to top ]
- Posted by: Murphy In
- Posted on: September 12 2000 13:00 EDT
- in response to Damian Guy
I am using Weblogic 5.1 -
Find method involving complecated Query[ Go to top ]
- Posted by: Damian Guy
- Posted on: September 12 2000 22:39 EDT
- in response to Murphy In
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.