Hi, I am using EJB2.0 for deploying an application on WebLogic 6.1. But, I am getting an error when I use nested queries inside the <ejb-ql> tag in ejb-jar.xml descriptor. The error is something like "Could not parse EJB QL expression: SELECT OBJECT(o) from document_masterBean as o WHERE o.id IN(select u.usename from User_masterBean as u WHERE u.code = ?1))" Can anyone please help me.
The EJB Specification fobid the use of subqueries, you can achieve this by using extensions provided by the App Server vendor, i.e. Weblogic in your case. In JBoss, subqueries goes on the jbosscmp-jdbc.xml, in Websphere they go on ejb-jar.xml, you must read the Weblogic documentation to discover how you can make subqueries in EJB-QL Regards,