2 Replies Latest reply on Jan 12, 2009 11:21 PM by Sachin Jain

    Error compiling EJB-QL statement -- Jboss 4.0.0

    aoggi Newbie

      Hi Guys,

      I am using jboss 4.0.0, trying to deploy entity bean. I am getting following error for EJB-QL. I have tried modifying the EJB-QL little bit, Finally i got to a point that if i remove "'F' = ?2" this kind of check in the EJB-QL it is getting deployed.
      Can some one help me to make the bellow EJB-QL work as it is..

      ************************ERROR LOG***********************
      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT DISTINCT OBJECT(a)
      FROM bbsoft a
      WHERE
      a.bNbr = ?1
      AND ('F' = ?2 OR a.tStatus = ?3)
      ORDER BY a.tId'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "\'F\'" at line 5, column 42.
      Was expecting one of:
      "ABS" ...
      "LENGTH" ...
      "LOCATE" ...
      "SQRT" ...
      "MOD" ...
      "(" ...
      "+" ...
      "-" ...
      <INTEGER_LITERAL> ...
      <FLOATING_POINT_LITERAL> ...
      <NUMERIC_VALUED_PARAMETER> ...
      <NUMERIC_VALUED_PATH> ...
      "NOT" ...
      <COLLECTION_VALUED_PATH> ...
      <STRING_VALUED_PATH> ...
      "CONCAT" ...
      "SUBSTRING" ...
      <BOOLEAN_VALUED_PATH> ...
      <DATETIME_VALUED_PATH> ...
      <ENTITY_VALUED_PATH> ...
      <IDENTIFICATION_VARIABLE> ...
      )
      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)

      ************************ERROR LOG***********************


      Thanks
      Anil