[ http://jira.jboss.com/jira/browse/JBAS-1573?page=comments#action_12316173 ] cgs commented on JBAS-1573: ---------------------------
For the class that this selector is in, I am using: * @jboss.eager-load-group * name="most" * * @jboss.load-group * name="most" * * @jboss.read-ahead * strategy="on-find" * page-size="25" * eager-load-group="most" By disabling the read-ahead with: * ---jboss.read-ahead * strategy="on-find" * page-size="25" * eager-load-group="most" ... the QL is compiled. > NPE in SQLUtil.appendColumnNamesClause > -------------------------------------- > > Key: JBAS-1573 > URL: http://jira.jboss.com/jira/browse/JBAS-1573 > Project: JBoss Application Server > Type: Bug > Components: CMP service > Versions: JBossAS-4.0.1 Final > Environment: Windows XP Pro SP2, JBoss 4.0.1, Sun JDK 1.5.0_01 > Reporter: cgs > Assignee: Alexey Loubyansky > > > ejbSelect JBoss-QL query does not build successfully and throws NPE in > SQLUtil.appendColumnNamesClause. This query works for bean X relating to the > same related bean Y, but not for bean Z. They are both M:N relations. > * @jboss.query > * signature="java.util.Collection > ejbSelectContactList(com.xxx.emm.interfaces.CampaignLocal campaignLocal, int > offset, int limit)" > * query="SELECT DISTINCT OBJECT(co) > * FROM campaign c, > * IN (c.contactList) AS co > * WHERE c = ?1 > * ORDER BY co.id ASC > * OFFSET ?2 > * LIMIT ?3" > * > Here's the stack trace: > 2005-03-12 00:30:05,607 DEBUG > [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.Campaign#ejbSelectContactList] > JBossQL: SELECT DISTINCT OBJECT(co) FROM campaign c, IN (c.contactList) AS > co WHERE c = ?1 ORDER BY co.id ASC OFFSET ?2 LIMIT ?3 > 2005-03-12 00:30:05,607 INFO [STDOUT] java.lang.NullPointerException > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.appendColumnNamesClause(SQLUtil.java:386) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.selectEntity(JDBCEJBQLCompiler.java:1849) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.visit(JDBCEJBQLCompiler.java:1012) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.ejbql.ASTSelect.jjtAccept(ASTSelect.java:25) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.visit(JDBCEJBQLCompiler.java:510) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.ejbql.ASTEJBQL.jjtAccept(ASTEJBQL.java:23) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileJBossQL(JDBCEJBQLCompiler.java:197) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.<init>(JDBCJBossQLQuery.java:43) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createJBossQLQuery(JDBCCommandFactory.java:72) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:260) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:490) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:381) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:157) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > java.lang.reflect.Method.invoke(Method.java:585) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.Invocation.invoke(Invocation.java:72) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891) > 2005-03-12 00:30:05,607 INFO [STDOUT] at $Proxy0.start(Unknown Source) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.system.ServiceController.start(ServiceController.java:416) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > java.lang.reflect.Method.invoke(Method.java:585) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.Invocation.invoke(Invocation.java:72) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) > 2005-03-12 00:30:05,607 INFO [STDOUT] at $Proxy48.start(Unknown > Source) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.EjbModule.startService(EjbModule.java:394) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > java.lang.reflect.Method.invoke(Method.java:585) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.Invocation.invoke(Invocation.java:72) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891) > 2005-03-12 00:30:05,607 INFO [STDOUT] at $Proxy0.start(Unknown Source) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.system.ServiceController.start(ServiceController.java:416) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > java.lang.reflect.Method.invoke(Method.java:585) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.Invocation.invoke(Invocation.java:72) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) > 2005-03-12 00:30:05,607 INFO [STDOUT] at $Proxy22.start(Unknown > Source) > 2005-03-12 00:30:05,607 INFO [STDOUT] at > org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:605) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.MainDeployer.start(MainDeployer.java:964) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.MainDeployer.start(MainDeployer.java:956) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > java.lang.reflect.Method.invoke(Method.java:585) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:122) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.Invocation.invoke(Invocation.java:74) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:131) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.Invocation.invoke(Invocation.java:74) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) > 2005-03-12 00:30:05,617 INFO [STDOUT] at $Proxy8.deploy(Unknown > Source) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:305) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:481) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:204) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:277) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > java.lang.reflect.Method.invoke(Method.java:585) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.Invocation.invoke(Invocation.java:72) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891) > 2005-03-12 00:30:05,617 INFO [STDOUT] at $Proxy0.start(Unknown Source) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.system.ServiceController.start(ServiceController.java:416) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > java.lang.reflect.Method.invoke(Method.java:585) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.Invocation.invoke(Invocation.java:72) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) > 2005-03-12 00:30:05,617 INFO [STDOUT] at $Proxy4.start(Unknown Source) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.SARDeployer.start(SARDeployer.java:261) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.MainDeployer.start(MainDeployer.java:964) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:722) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > java.lang.reflect.Method.invoke(Method.java:585) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:122) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.Invocation.invoke(Invocation.java:74) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:131) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.Invocation.invoke(Invocation.java:74) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) > 2005-03-12 00:30:05,617 INFO [STDOUT] at $Proxy5.deploy(Unknown > Source) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:413) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.system.server.ServerImpl.start(ServerImpl.java:310) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.Main.boot(Main.java:162) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > org.jboss.Main$1.run(Main.java:423) > 2005-03-12 00:30:05,617 INFO [STDOUT] at > java.lang.Thread.run(Thread.java:595) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development
