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