Bugs item #602272, was opened at 2002-08-30 08:01
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=602272&group_id=22866

Category: JBossCMP
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: ObjectWiz (objectwiz)
Assigned to: Nobody/Anonymous (nobody)
Summary: JBoss EJB-QL numeric comparison error

Initial Comment:
EJB-QL allows the use of comparisons = and <> for
(in)equality and <, >, <=, >= for numeric comparison.
JBoss throws an error if you use something other than
equality (see below). The error actually says that all
it want is = or <>. This is clearly wrong according to
the EJB-QL reference (see www.ejb-ql.com).

--wiz

Version Info:

OS: RH7.3, kernel: 2.4.18-3
JBoss: 3.0.2
JDK: 1.4.0_01

CMP field decl:

public abstract float getBalance();
public abstract void setBalance(float balance);

EJB-QL:

SELECT OBJECT(a) FROM ACCOUNTS AS a WHERE a.balance >=
?1 AND a.balance <= ?2

Error Message:

org.jboss.deployment.DeploymentException: Error
compiling ejbql; - nested throwable:
(org.jboss.ejb.plugins.cmp.ejbql.ParseException:
Encountered ">=" at line 1, column 55.
Was expecting one of:
    "=" ...
    "<>" ...
    )
        at
org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(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.startStoreManager(JDBCStoreManager.java:463)
        at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:369)
        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:764)
        at
org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
        at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
        at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
        at $Proxy5.start(Unknown Source)
        at
org.jboss.system.ServiceController.start(ServiceController.java:396)
        at
sun.reflect.GeneratedMethodAccessor7.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:517)
        at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
        at $Proxy20.start(Unknown Source)
        at
org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
        at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
        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:517)
        at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
        at $Proxy5.start(Unknown Source)
        at
org.jboss.system.ServiceController.start(ServiceController.java:396)
        at
sun.reflect.GeneratedMethodAccessor7.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:517)
        at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
        at $Proxy9.start(Unknown Source)
        at
org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)
        at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)
        at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:794)
        at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)
        at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)
        at
sun.reflect.GeneratedMethodAccessor12.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:517)
        at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
        at $Proxy4.deploy(Unknown Source)
        at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:427)
        at
org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:648)
        at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:499)
        at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:212)
        at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:225)
        at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:202)
Caused by:
org.jboss.ejb.plugins.cmp.ejbql.ParseException:
Encountered ">=" at line 1, column 55.
Was expecting one of:
    "=" ...
    "<>" ...

        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseException(EJBQLParser.java:3745)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.jj_consume_token(EJBQLParser.java:3626)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ComparisonExpression(EJBQLParser.java:902)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.SimpleCondExpression(EJBQLParser.java:588)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalPrimary(EJBQLParser.java:546)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalTest(EJBQLParser.java:514)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalFactor(EJBQLParser.java:491)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalTerm(EJBQLParser.java:441)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalExpression(EJBQLParser.java:401)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.WhereClause(EJBQLParser.java:370)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.EJBQL(EJBQLParser.java:102)
        at
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.parse(EJBQLParser.java:60)
        at
org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileEJBQL(JDBCEJBQLCompiler.java:143)
        at
org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:40)
        ... 54 more


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=602272&group_id=22866


-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to