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: [EMAIL PROTECTED]) | 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: [EMAIL PROTECTED] | 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: [EMAIL PROTECTED]) | 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: [EMAIL PROTECTED]) | 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: [EMAIL PROTECTED]) | 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: [EMAIL PROTECTED] | 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 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843531#3843531 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843531 ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
