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

    FinderException after redeploying ear/ejb containing JBossQL

    Jim Newbie

      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
          Jim Newbie

          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