1 Reply Latest reply on May 4, 2003 4:05 AM by joe543

FinderException after redeploying ear/ejb containing JBossQL

joe543 May 2, 2003 3:48 AM

Hi,

tomcat406+jboss304, linux 2.4.19-16mdk, ibmjdk1.3.1

I am experiencing the following problem while running a query against JBossQL.

I can run the query(via my cmp2 ejb) after I have started the server. When I redploy, after a full build of my ear, and rerun the query, I get the following:

javax.ejb.FinderException: Find failed: java.lang.NullPointerException
10:24:15,954 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:148)
10:24:15,954 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.execute(JDBCDynamicQLQuery.java:101)
10:24:15,954 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.execute(JDBCSelectorBridge.java:64)
10:24:15,955 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.bridge.EntityBridgeInvocationHandler.invoke(EntityBridgeInvocationHandler.java:96)
10:24:15,955 ERROR [STDERR] at org.jboss.proxy.compiler.Runtime.invoke(Runtime.java:59)
10:24:15,955 ERROR [STDERR] at com.mycompany.myproject.advert.ejbs.AdvertBean$Proxy.ejbSelectBasicSearch()
10:24:15,956 ERROR [STDERR] at com.mycompany.myproject.advert.ejbs.AdvertBean.ejbHomeBasicSearch(AdvertBean.java:592)
10:24:15,956 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
10:24:15,956 ERROR [STDERR] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1138)
10:24:15,957 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
10:24:15,957 ERROR [STDERR] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:206)
10:24:15,957 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
10:24:15,958 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
10:24:15,958 ERROR [STDERR] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90)
10:24:15,958 ERROR [STDERR] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)
10:24:15,959 ERROR [STDERR] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)
10:24:15,967 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:111)
10:24:15,968 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
10:24:15,968 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:52)
10:24:15,969 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)
10:24:15,969 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:129)
10:24:15,969 ERROR [STDERR] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487)
10:24:15,970 ERROR [STDERR] at org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invokeHome(BaseLocalContainerInvoker.java:230)
10:24:15,970 ERROR [STDERR] at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
10:24:15,970 ERROR [STDERR] at $Proxy82.basicSearch(Unknown Source)
10:24:15,971 ERROR [STDERR] at com.mycompany.myproject.Motor.ejbs.MotorSessionBean.basicSearch(MotorSessionBean.java:58)
10:24:15,971 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
10:24:15,971 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:660)
10:24:15,972 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
10:24:15,972 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
10:24:15,972 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
10:24:15,973 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
10:24:15,973 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
10:24:15,973 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
10:24:15,974 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
10:24:15,974 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
10:24:15,974 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:712)
10:24:15,974 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
10:24:15,975 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98)
10:24:15,975 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:102)
10:24:15,975 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
10:24:15,975 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
10:24:15,976 ERROR [STDERR] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:111)
10:24:15,976 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
10:24:15,976 ERROR [STDERR] at $Proxy97.basicSearch(Unknown Source)
10:24:15,977 ERROR [STDERR] at com.mycompany.myproject.Motor.actions.MotorSearchAction.perform(MotorSearchAction.java:104)
10:24:15,983 ERROR [STDERR] at com.mycompany.myproject.common.actions.BaseAction.execute(BaseAction.java:61)
10:24:15,983 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
10:24:15,984 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
10:24:15,984 ERROR [STDERR] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
10:24:15,984 ERROR [STDERR] at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
10:24:15,984 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
10:24:15,985 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
10:24:15,985 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
10:24:15,985 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
10:24:15,986 ERROR [STDERR] at com.mycompany.myproject.common.filters.AuthenticationFilter.doFilter(AuthenticationFilter.java:196)
10:24:15,986 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
10:24:15,986 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
10:24:15,987 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
10:24:15,987 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
10:24:15,987 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
10:24:15,987 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
10:24:15,988 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
10:24:15,988 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
10:24:15,988 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
10:24:15,989 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
10:24:15,990 ERROR [STDERR] at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
10:24:15,990 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
10:24:15,990 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
10:24:15,990 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
10:24:15,991 ERROR [STDERR] at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
10:24:15,991 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
10:24:15,991 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
10:24:15,992 ERROR [STDERR] at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
10:24:15,992 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
10:24:15,992 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
10:24:15,992 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
10:24:15,993 ERROR [STDERR] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
10:24:15,993 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
10:24:15,993 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
10:24:15,994 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
10:24:15,994 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
10:24:15,994 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
10:24:15,994 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
10:24:15,995 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
10:24:15,995 ERROR [STDERR] at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
10:24:15,995 ERROR [STDERR] at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
10:24:15,996 ERROR [STDERR] at java.lang.Thread.run(Thread.java:512)

The second query, as printed to the console prior to invoking the ejbselect, is identical to the first:

jbossQl : SELECT OBJECT(a) FROM AdvertBean a WHERE a.status = 2 ORDER BY a.motor.price asc!

Any help is much appreciated.

Joe

1. Re: FinderException after redeploying ear/ejb containing JBo

joe543 May 4, 2003 4:05 AM (in response to joe543)

Problem solved.

The problem only appeared when I started deploying a fresh copy of postgres-service.xml for each build of my ear.

For some reason, once the sql(dynamic-ql) had been generated and the service file was redeployed, it would bomb when the finder ran.

I have removed the deploy of the service file now as it was only experimental. Any clues as to what was really going on under the covers?

joe
Actions