Error compiling EJB-QL in crime portal example from JBOSS do

[alt_amit]

I have deployed on jboss 3.2.5 the crime portal example (available from the JBOSS docs subscription) - I am getting following error:

2003-08-31 14:15:21,751 ERROR [org.jboss.ejb.EntityContainer] Starting failed jb
oss.j2ee:jndiName=JBossUtilAutoNumber,service=EJB^M
org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement ''; -
nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not fou
nd)^M
at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.j
ava:52)^M
at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JD
BCCommandFactory.java:60)^M


2003-08-31 14:15:23,266 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner
] Incomplete Deployment listing:
MBeans waiting for other MBeans:
ObjectName: jboss.j2ee:jndiName=JBossUtilAutoNumber,service=EJB
state: FAILED
I Depend On:
Depends On Me: MBeanException: org.jboss.deployment.DeploymentException: Error
compiling EJB-QL statement ''; - nested throwable: (org.jboss.ejb.plugins.cmp.ej
bql.ParseException: FROM not found)
Cause: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statemen
t ''; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM
not found)
ObjectName: jboss.j2ee:jndiName=JBossUtilAutoNumber,plugin=pool,service=EJB
state: CREATED
I Depend On:
Depends On Me:

MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss.j2ee:jndiName=JBossUtilAutoNumber,plugin=pool,service=EJB
state: CREATED
I Depend On:
Depends On Me:
ObjectName: jboss.j2ee:jndiName=JBossUtilAutoNumber,service=EJB
state: FAILED
I Depend On:
Depends On Me: MBeanException: org.jboss.deployment.DeploymentException: Error
compiling EJB-QL statement ''; - nested throwable: (org.jboss.ejb.plugins.cmp.ej
bql.ParseException: FROM not found)
Cause: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statemen
t ''; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM
not found)
^M

[aloubyansky]

Just worked for me. What did you change?

[alt_amit]

I didnt change a thing, maybe can you zip up the entire example that runs on yours with 3.2.5 and I can try on mine. And the sequence of ant commands you ran.

[alt_amit]

OK the examples in JBossBook_323.zip works, but the examples in JBossCMP30x.zip caused the problem.

[aloubyansky]

I ran it from JBossCMP30x.zip against JBoss-3.2.5.
Targets: setup, test, readahead, teardown.
This 'service=EJB^M' in object name looks suspiciously.