2 Replies Latest reply on Aug 12, 2004 6:06 AM by zarni

    JBossQL work in 3.2.3 but failed in 3.2.5

    tsangcn
    tsangcn Jul 28, 2004 10:30 AM

      Hello,

      My application works OK in JBoss-3.2.3. But when I upgraded to JBoss-3.2.5,
      JBoss always complain my JBossQL

      SELECT a.name FROM Activity a WHERE a.id > ?1 ORDER BY a.id

      (It is referenced in a ejbSelect... and should return a collection of strings).

      But it deploys OK in JBoss-3.2.3.

      If I modify it to 
      SELECT OBJECT(a) FROM Activity a WHERE a.id > ?1 ORDER BY a.id

      or 
      SELECT a.name FROM Activity a WHERE a.id > ?1

      then JBoss-3.2.5 is OK.

      It seems that in JBoss-3.2.5, it only allows SELECT OBJECT(?) ... ORDER BY ...
      But it does not allow SELECT afield ... ORDER BY ...

      Is this true? OR it is a bug?
      (It is OK in JBoss-3.2.3)

      The stack trace of the problem follows: 

      2004-07-28 21:50:12,685 ERROR [org.jboss.ejb.EntityContainer] (ScannerThread:jboss.j2ee:jndiName=ejb/sclbt/WorkItemLocalEJB,service=EJB EntityContainer) Starting failed jboss.j2ee:jndiName=ejb/sclbt/WorkItemLocalEJB,service=EJB
org.jboss.deployment.DeploymentException: Error compiling JBossQL statement 'SELECT a.name
 FROM Activity a
 WHERE a.id > ?1
 ORDER BY a.id'; - nested throwable: (java.lang.IllegalStateException: Unexpected select object: org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge@66db4e)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.<init>(JDBCJBossQLQuery.java:52)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createJBossQLQuery(JDBCCommandFactory.java:72)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:254)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:498)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)
 at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:147)
 at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:337)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
 at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
 at $Proxy17.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:367)
 at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy221.start(Unknown Source)
 at org.jboss.ejb.EjbModule.startService(EjbModule.java:367)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
 at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
 at $Proxy17.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:367)
 at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy14.start(Unknown Source)
 at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:570)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:828)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608)
 at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy7.deploy(Unknown Source)
 at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:304)
 at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:478)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:212)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
Caused by: java.lang.IllegalStateException: Unexpected select object: org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge@66db4e
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.isSelected(JDBCEJBQLCompiler.java:1781)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.visit(JDBCEJBQLCompiler.java:550)
 at org.jboss.ejb.plugins.cmp.ejbql.ASTEJBQL.jjtAccept(ASTEJBQL.java:23)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileJBossQL(JDBCEJBQLCompiler.java:196)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.<init>(JDBCJBossQLQuery.java:43)
 ... 78 more
2004-07-28 21:50:12,781 WARN [org.jboss.system.ServiceController] (ScannerThread:) Problem starting service jboss.j2ee:jndiName=ejb/sclbt/WorkItemLocalEJB,service=EJB
MBeanException: org.jboss.deployment.DeploymentException: Error compiling JBossQL statement 'SELECT a.name
 FROM Activity a
 WHERE a.id > ?1
 ORDER BY a.id'; - nested throwable: (java.lang.IllegalStateException: Unexpected select object: org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge@66db4e)
Cause: org.jboss.deployment.DeploymentException: Error compiling JBossQL statement 'SELECT a.name
 FROM Activity a
 WHERE a.id > ?1
 ORDER BY a.id'; - nested throwable: (java.lang.IllegalStateException: Unexpected select object: org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge@66db4e)
 at org.jboss.mx.server.ReflectedDispatcher.handleInvocationExceptions(ReflectedDispatcher.java:91)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:64)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
 at $Proxy17.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:367)
 at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy221.start(Unknown Source)
 at org.jboss.ejb.EjbModule.startService(EjbModule.java:367)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
 at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
 at $Proxy17.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:367)
 at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy14.start(Unknown Source)
 at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:570)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:828)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608)
 at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy7.deploy(Unknown Source)
 at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:304)
 at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:478)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:212)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
Caused by: org.jboss.deployment.DeploymentException: Error compiling JBossQL statement 'SELECT a.name
 FROM Activity a
 WHERE a.id > ?1
 ORDER BY a.id'; - nested throwable: (java.lang.IllegalStateException: Unexpected select object: org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge@66db4e)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.<init>(JDBCJBossQLQuery.java:52)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createJBossQLQuery(JDBCCommandFactory.java:72)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:254)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:498)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)
 at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:147)
 at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:337)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
 at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
 ... 66 more
Caused by: java.lang.IllegalStateException: Unexpected select object: org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge@66db4e
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.isSelected(JDBCEJBQLCompiler.java:1781)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.visit(JDBCEJBQLCompiler.java:550)
 at org.jboss.ejb.plugins.cmp.ejbql.ASTEJBQL.jjtAccept(ASTEJBQL.java:23)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileJBossQL(JDBCEJBQLCompiler.java:196)
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.<init>(JDBCJBossQLQuery.java:43)
 ... 78 more


      Thanks
      CN




      • 3926 Views
      • Tags:
        • 1. Re: JBossQL work in 3.2.3 but failed in 3.2.5
          aloubyansky
          aloubyansky Jul 29, 2004 3:24 AM (in response to tsangcn)

          You can ORDER BY fields that are in SELECT, i.e. in your case ORDER BY name. It's bug. There is no reason for this limitation. It's now fixed.

          Index: JDBCEJBQLCompiler.java
===================================================================
RCS file: /cvsroot/jboss/jboss/src/main/org/jboss/ejb/plugins/cmp/jdbc/JDBCEJBQLCompiler.java,v
retrieving revision 1.10.2.48
diff -r1.10.2.48 JDBCEJBQLCompiler.java
1829,1832d1828
< else
< {
< throw new IllegalStateException("Unexpected select object: " + selectObject);
< }


            • Actions
          • 2. Re: JBossQL work in 3.2.3 but failed in 3.2.5
            zarni
            zarni Aug 12, 2004 6:06 AM (in response to tsangcn)

             

            "loubyansky" wrote:
            You can ORDER BY fields that are in SELECT, i.e. in your case ORDER BY name. It's bug. There is no reason for this limitation. It's now fixed.

            Index: JDBCEJBQLCompiler.java
===================================================================
RCS file: /cvsroot/jboss/jboss/src/main/org/jboss/ejb/plugins/cmp/jdbc/JDBCEJBQLCompiler.java,v
retrieving revision 1.10.2.48
diff -r1.10.2.48 JDBCEJBQLCompiler.java
1829,1832d1828
< else
< {
< throw new IllegalStateException("Unexpected select object: " + selectObject);
< }


            I had the same problem and downloaded 3.2.6RC1 and compiled it.
            The problem remained.
            Then I looked up JDBCEJBQLCompiler.java and found out the throw is still in there.

            My problem was solved when I removed the lines with the throw and recompiled.
            :-) Now it's working ...

            I'm wondering, aren't the snapshots from CVS up to date?

            regards



              • Actions