NPE in SQLUtil.appendColumnNamesClause

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)