Error compiling EJB-QL statement

[xyang200]

Hi,

I have a EJB-QL statement as "SELECT OBJECT(o) FROM Order
AS o WHERE o.status = ?1". It works with JBoss 2.2.3, but when I use JBoss 4.0.0 RC1 I got the following error. Can anyone help? Thanks.


Depends On Me: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(o) FROM Order
AS o WHERE o.status = ?1'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "Order"
at line 1, column 23.
Was expecting one of:
"IN" ...
<ABSTRACT_SCHEMA> ...
)


Xiaohong Yang

[fbiaggi]

Hi,
"Order" is an sql reserved word.

[xyang200]

I changed Order to OrderXY, and now it works.

Thanks.

Xiaohong Yang