Hello,
I have an app in ejb that deploys fine in JBoss 3.2.1, but when I migrated to Jboss 3.2.4 i get the following error:

org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT Object(a) FROM AmbienteSistema a'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not found)

I've searched over the net and even found a similar thread here at theserverside.com but they couldnt find a solution. Can anyone please help me??? Thanks!

Luiz

JBoss 3.2.4 & 3.2.5 doesn't seem to like ejb-ql statements on more than one line. You need to put your ejb-ql statement on one line within the XML descriptor.

I'm trying to find out if this is a bug or if there happens to be a good reason for this behaviour.

Brad.

Further to this...

Here is the offending line of code from JBoss 3.2.5 (JBossQLParser.jjt)

      String lowerCase = ejbql.toLowerCase();
      int fromBeginIndex = lowerCase.indexOf(" from ");
      if(fromBeginIndex < 0) {
         throw new ParseException("FROM not found");
      }

looks for {space}from{space}

But beware, the error message seems to point you in the wrong direction. Check all ejb-ql entries in your ejb-jar.xml and jboss-ql entries in your jbosscmp-jdbc.xml descriptors.

Thanks a lot, I'll try that and get back to you..