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.