2 Replies Latest reply on Oct 10, 2003 1:43 AM by Jochen Cordes

    jboss-ql and Count(*)

    sajeesh pj Newbie

      Dear friends,
      On going through the forum, i have learnt that we have 2 wait till jboss4.0 to have COUNT(*) in EJB-QL.

      I am using jboss 3.2.1 and is there a way out to use COUNT(*), using jboss-ql ? I've found from this forum that it is possible to have 'order by' working using jboss-ql. Can i do something similar for COUNT(*) as well?

      If it is not possible, could you suggest a workable solution for my CMP to use COUNT(*) querries.

      Thanks in advance
      sajeesh