Hi Guys,
Does somebody of you know whether I can use EXISTS (NOT EXISTS) and correlated subqueries in ejb.select, for example:
/**
* @ejb.select
* query = "SELECT o.proId FROM ProfileEJB AS o
* WHERE o.proId <> ?1
* AND NOT EXISTS (SELECT p.gender FROM ProfileEJB p
* WHERE p.proId = ?1
* AND p.gender = o.gender)
* AND NOT EXISTS (SELECT t.toplistedProId FROM ToplistEJB AS t
* WHERE t.whoseProId = ?1
* AND t.toplistedProId = o.proId)
* ORDER BY o.proId ASC"
*/
This select is perfect in WebLogic 8.1 but in JBoss 3.2.5 I am getting complilation errors.
Any advices?
No, subquieries are not supported.