0 Replies Latest reply on Mar 20, 2006 6:01 PM by Sami

    Error compiling EJB-QL statement, Caused by: org.jboss.ejb.p

    Sami Newbie

      Hi!
      I am getting following exception in my console.
      I will appreciate any help to solve this problem. Currently It's working fine on WebLogic 8.1SP4. I am migrating it to JBoss.

      I am in Fix. Not able to overcome this problem.

      ************************************************************

      15:51:44,828 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=bts/ejb/BtsWafSliceRejectHistoryHome,service=EJB
      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(B)
      FROM BRS_BASELINE_BUILDS B
      WHERE B.name = ?1 and
      B.version =?2 and
      B.slamPhase = ?3 and
      B.factory = ?4'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "2" at line 4, column 24.
      Was expecting one of:
      "ABS" ...
      "LENGTH" ...
      "LOCATE" ...
      "SQRT" ...
      "MOD" ...
      "(" ...
      "+" ...
      "-" ...
      <INTEGER_LITERAL> ...
      <FLOATING_POINT_LITERAL> ...
      <NUMERIC_VALUED_PARAMETER> ...
      <NUMERIC_VALUED_PATH> ...
      )
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:52)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:60)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:272)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:490)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:381)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:157)
      at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
      .
      .
      .
      .
      Caused by: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "2" at line 4, column 24.
      Was expecting one of:
      "ABS" ...
      "LENGTH" ...
      "LOCATE" ...
      "SQRT" ...
      "MOD" ...
      "(" ...
      "+" ...
      "-" ...
      <INTEGER_LITERAL> ...
      <FLOATING_POINT_LITERAL> ...
      <NUMERIC_VALUED_PARAMETER> ...
      <NUMERIC_VALUED_PATH> ...

      at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseException(EJBQLParser.java:4284)
      at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.jj_consume_token(EJBQLParser.java:4161)
      at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ArithmeticPrimary(EJBQLParser.java:1771)
      at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ArithmeticFactor(EJBQLParser.java:1700)
      at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ArithmeticTerm(EJBQLParser.java:1624)
      .
      .
      .
      .
      15:51:47,390 INFO [EARDeployer] Started J2EE application: file:/C:/jboss-4.0.3SP1/server/BRSADNdomain/deploy/MES.ear
      15:51:47,578 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

      --- MBeans waiting for other MBeans ---
      ObjectName: jboss.j2ee:jndiName=bts/ejb/BtsWafSliceRejectHistoryHome,service=EJB
      State: FAILED
      Reason: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(B)
      FROM BRS_BASELINE_BUILDS B
      WHERE B.name = ?1 and
      B.version =?2 and
      B.slamPhase = ?3 and
      B.factory = ?4'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "2" at line 4, column 24.
      Was expecting one of:
      "ABS" ...
      "LENGTH" ...
      "LOCATE" ...
      "SQRT" ...
      "MOD" ...
      "(" ...
      "+" ...
      "-" ...
      <INTEGER_LITERAL> ...
      <FLOATING_POINT_LITERAL> ...
      <NUMERIC_VALUED_PARAMETER> ...
      <NUMERIC_VALUED_PATH> ...
      )

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss.j2ee:jndiName=bts/ejb/BtsWafSliceRejectHistoryHome,service=EJB
      State: FAILED
      Reason: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(B)
      FROM BRS_BASELINE_BUILDS B
      WHERE B.name = ?1 and
      B.version =?2 and
      B.slamPhase = ?3 and
      B.factory = ?4'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "2" at line 4, column 24.
      Was expecting one of:
      "ABS" ...
      "LENGTH" ...
      "LOCATE" ...
      "SQRT" ...
      "MOD" ...
      "(" ...
      "+" ...
      "-" ...
      <INTEGER_LITERAL> ...
      <FLOATING_POINT_LITERAL> ...
      <NUMERIC_VALUED_PARAMETER> ...
      <NUMERIC_VALUED_PATH> ...
      )

      **********************************************************