1 Reply Latest reply on Aug 5, 2003 3:23 AM by darth tux

    ejbql parsing error

    anilpopnet Newbie

      I am using jboss-3.2.1_tomcat-4.1.24.

      following CMP bean ejbquey fails on jboss.
      Same is working fine on weblogic7.0 SP2.

      ejb query:
      =======
      select object(c) FROM CRLEntity AS c WHERE (c.issueDate BETWEEN ?1 AND ?2) AND c.cryptoId = ?3

      Exception
      =======

      11:59:08,705 ERROR [EjbModule] Starting failed
      org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "BETWEEN" at line 2, column 71.
      Was expecting one of:
      ">" ...
      "<" ...
      "=" ...
      "<>" ...
      )
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:46)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:44)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:214)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:389)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
      at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
      at org.jboss.ejb.Container.invoke(Container.java:793)
      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)