ejb-ql limitation in comparision operators
raj_kumar May 12, 2004 12:43 AMhi ...
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........