0 Replies Latest reply on Jun 26, 2006 4:54 AM by Himadri Saha

    How to use the COUNT keyword in JBoss-QL

    Himadri Saha Newbie

      Hi,
      The Jboss documentation says it supports COUNT keyword in JBoss-QL.
      But when i put a count method in the home interface which returns int , the app server throws a spec violation saying it needs the remote instance.

      How do i use the COUNT feature effectively. Right now i an doing a 'select * from ....' and counting the number of instances. This looks to me as a performance overkill.

      Jboss version - 4.0.1

      Regards
      Himadri