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)
use < and > instead of between!
translation
------------
where (c.issueDate > ?1 AND c.issueDate < ?2) or c.issueDate =?1 or c.issueDate = ?2