hello,
I have been trying to get the COUNT feature to work, without success. I am using JBoss 3.2.2 w/ hypersonic and XDoclet for development, IMO the deployment descriptors and generated files are looking good, all other select and finders work fine...
during deployment the container throws an EJB-QL parse exception
I want to know the number of records in a specific table
SELECT COUNT(u) FROM User As u
exception: column 14, line 1 (encountered 'u')
Is something wrong with this query ? I have tried a lot of other possibilities such as
SELECT COUNT(u) FROM User
SELECT COUNT(u) FROM User u
SELECT COUNT(u) FROM User As x
SELECT COUNT FROM User
COUNT(u) FROM User As u
etc... but none of them work neither
I configured the bean in such a way that the query for EJB-QL is empty (ejb-jar.xml), and the COUNT query is a jboss-ql query (jbosscmp-jdbc.xml), because I assumed EJB-QL 2.1 (supporting the COUNT feature) was simply not yet working in JBoss 3.2.2 (probably it is just working fine), I then tried to use the JBOSS-QL COUNT feature and this error came up
can anyone help me with this ? someone got the count feature to work ?
thanks in advance
Wouter.