Problem in EJB QL

[hardik]

Hi,
I have problem in EJB QL for COUNT query.The query is as follow:

SELECT COUNT(*) FROM CustomerInfo customerinfo

I used Jboss-3.2.3 with Eclipse-2.1

When I fired this query Jboss gives me error like:

Required:
OBJECT or DISTINCT

plz give me fast reply.

thx in advance

[aloubyansky]

You should use JBossQL instead with COUNT(customerinfo.id)

[darranl]

You can not use SELECT COUNT(*) in EJB-QL

[aloubyansky]

You can but in EJBQL2.1. EJBQL2.1 is in 4.0.0DR3 now. If there is demand for it, it can be back ported to 3.2. Though, most of it is supported by JBossQL.

[darranl]

hardik is using J2EE 1.3 not 1.4