Hello, I have a cMP Bean, but I cannot deploy it because I have this error on
my query :
org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement
'SELECT OBJECT(a) FROM TsaGed a where a.tsaver='0' and a.tsavis='01' and
a.tsatbl = ?1 order by a.tsarga'; - nested throwable:
(org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "order" at line 1,
column 87.
Was expecting one of:
"AND" ...
"OR" ...
)
I think, it doesn't understand order by. So what to do ? Is there any way to do
this ? Shall I have to upgrade EJB-DL ? What is the solution ?
PS : I have the same error when I want to do a.tsavis like '%1%', it doesn't
understand like.
Thx.
Pierre.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3870962#3870962
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3870962
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
