1 Reply Latest reply on Jul 25, 2004 3:12 AM by Alexey Loubyansky

    EXISTS and subqueries in ejb.select queries

    Vlad Vujicic Newbie

      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?