FROM not found


EJB programming & troubleshooting: FROM not found

  1. FROM not found (3 messages)

    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 but they couldnt find a solution. Can anyone please help me??? Thanks!


    Threaded Messages (3)

  2. FROM not found[ Go to top ]

    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.

  3. FROM not found[ Go to top ]

    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.
  4. FROM not found[ Go to top ]

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