1 Reply Latest reply on May 14, 2004 3:18 AM by Juha Lindfors

    ejb-ql limitation in comparision operators

    raj_kumar Newbie

      hi ...
      i would like to ask u a question about EJB QL . i was trying ">=" sign while
      writing the finder query ... but while deploying the bean jboss throws an exception. i'm using jboss3.2.2. but according to EJB specification ">=" works with
      EJB-QL but i dont know why it is not working... my ejb is working when i puts"<,>,=" but when i put it like " <=,>=" it throws an exception ...
      the stack trace is as follows :-

      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(f) FROM RSNE15 AS f WHERE f.switchName = ?1 and f.slotPort = ?2 and f.endTime >= ?3 and f.endTime < ?4'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered ">=" at line 1, column 95.
      Was expecting one of:
       ">" ...
       "<" ...
       "=" ...
       "<>" ...
       )
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:45)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:53)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:204)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:511)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:411)
       at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
       at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:343)
       at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
       at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
       at $Proxy12.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:394)
       at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
       at or
      


      pls tell me whether this is an limitation of jboss or what ...or if i'm wrong somewhere...

      is there any limitation on comparision operator?

      thanks
      Raj........