I suppose, there is no error in the EJB-QL, because I have tried the query
SELECT OBJECT(p) FROM RecipePos AS p WHERE p.color = '999', and if there is
no record with the color 999, the finder-method doesn't throw an exception. But
when I create one record with color 999, the finder-method
I have solved the problem. One column in my table is named with count. Count is
not a reserved word in EJB-QL, but it is reserved in SQL, and I have used it
many many times before. After 14 years experience with SQL I fall into this
simple trap.
View the original post :
You should use JBossQL instead with COUNT(customerinfo.id)
a
href=http://www.jboss.org/index.html?module=bbop=viewtopicp=3826153#3826153;View
the original post/a
a
href=http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3826153Reply
to the post/a
You can not use SELECT COUNT(*) in EJB-QL
a
href=http://www.jboss.org/index.html?module=bbop=viewtopicp=3826156#3826156;View
the original post/a
a
href=http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3826156Reply
to the post/a
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.
a
href=http://www.jboss.org/index.html?module=bbop=viewtopicp=3826162#3826162;View
the original post/a
a
hardik is using J2EE 1.3 not 1.4
a
href=http://www.jboss.org/index.html?module=bbop=viewtopicp=3826164#3826164;View
the original post/a
a
href=http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3826164Reply
to the post/a
---