1 Reply Latest reply on Apr 20, 2004 2:22 PM by triathlon98

    Firebird 1.5 and JBoss 3.0.4 .... Connection Pool Error??

    herinjaka

      I'm trying to use JBoss 3.0.4 with Firebird 1.5.
      I create my EJB, with recomanded patterns (ServiceLocator, Business Delegate) but
      when I compile my application, I note that :

      - If I run the application only at once time, I have no problem!!
      - but if I want to run many times the samy business, like a select statement for
      example I receive this error :

      2004-04-18 16:00:26,674 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException, causedBy:
      com.gefi.utils.ProjetDAOSysException: UtilCompte SQLException: Problem getting connection: javax.resource.ResourceException: Error in use of ManagedConnectionPool: matchManagedConnection failed with subject: Objet :
       Principal : sysdba
       Identité privée : javax.resource.spi.security.PasswordCredential@e8000000
       and ConnectionRequestInfo: org.firebirdsql.jca.FBConnectionRequestInfo@47189c77
       at com.gefi.utils.UtilCompte.getListCompte(UtilCompte.java:119)
       at com.gefi.gestioncompte.CompteMetierBean.getListCompte(CompteMetierBean.java:48)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:660)
       at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
       at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
       at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
       at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:228)
       at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:92)
       at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
       at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
       at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
       at org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invoke(BaseLocalContainerInvoker.java:301)
       at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:81)
       at $Proxy145.getListCompte(Unknown Source)
       at com.gefi.gestioncompte.GestionCompteFacadeBean.getListCompte(GestionCompteFacadeBean.java:53)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:824)
       at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
       at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
       at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:268)
       at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
       at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:228)
       at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:92)
       at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
       at org.jboss.ejb.StatefulSessionContainer.invoke(StatefulSessionContainer.java:380)
       at org.jboss.ejb.Container.invoke(Container.java:712)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
       at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98)
       at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:102)
       at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
       at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
       at org.jboss.proxy.ejb.StatefulSessionInterceptor.invoke(StatefulSessionInterceptor.java:117)
       at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
       at $Proxy144.getListCompte(Unknown Source)
       at com.gefi.gestioncompte.GestionCompteDelegate.getListCompte(GestionCompteDelegate.java:64)
       at org.apache.jsp.ListeCompte_jsp._jspService(ListeCompte_jsp.java:52)
       at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
       at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
       at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
       at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
       at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
       at java.lang.Thread.run(Thread.java:534)
      2004-04-18 16:00:26,684 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException, causedBy:
      com.gefi.utils.ProjetDAOSysException: UtilCompte SQLException: Problem getting connection: javax.resource.ResourceException: Error in use of ManagedConnectionPool: matchManagedConnection failed with subject: Objet :
       Principal : sysdba
       Identité privée : javax.resource.spi.security.PasswordCredential@e8000000
       and ConnectionRequestInfo: org.firebirdsql.jca.FBConnectionRequestInfo@47189c77
       at com.gefi.utils.UtilCompte.getListCompte(UtilCompte.java:119)
       at com.gefi.gestioncompte.CompteMetierBean.getListCompte(CompteMetierBean.java:48)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:660)
       at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
       at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
       at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
       at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:228)
       at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:92)
       at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
       at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
       at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
       at org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invoke(BaseLocalContainerInvoker.java:301)
       at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:81)
       at $Proxy145.getListCompte(Unknown Source)
       at com.gefi.gestioncompte.GestionCompteFacadeBean.getListCompte(GestionCompteFacadeBean.java:53)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:824)
       at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
       at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
       at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:268)
       at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
       at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:228)
       at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:92)
       at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
       at org.jboss.ejb.StatefulSessionContainer.invoke(StatefulSessionContainer.java:380)
       at org.jboss.ejb.Container.invoke(Container.java:712)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
       at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98)
       at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:102)
       at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
       at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
       at org.jboss.proxy.ejb.StatefulSessionInterceptor.invoke(StatefulSessionInterceptor.java:117)
       at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
       at $Proxy144.getListCompte(Unknown Source)
       at com.gefi.gestioncompte.GestionCompteDelegate.getListCompte(GestionCompteDelegate.java:64)
       at org.apache.jsp.ListeCompte_jsp._jspService(ListeCompte_jsp.java:52)
       at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
       at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
       at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
       at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
       at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
       at java.lang.Thread.run(Thread.java:534)
      2004-04-18 16:00:26,694 INFO [STDOUT] GestionCompteDelegate : Tsy mety getListCompte UtilCompte SQLException: Problem getting connection: javax.resource.ResourceException: Error in use of ManagedConnectionPool: matchManagedConnection failed with subject: Objet :
       Principal : sysdba
       Identité privée : javax.resource.spi.security.PasswordCredential@e8000000
       and ConnectionRequestInfo: org.firebirdsql.jca.FBConnectionRequestInfo@47189c77; CausedByException is:
       UtilCompte SQLException: Problem getting connection: javax.resource.ResourceException: Error in use of ManagedConnectionPool: matchManagedConnection failed with subject: Objet :
       Principal : sysdba
       Identité privée : javax.resource.spi.security.PasswordCredential@e8000000
       and ConnectionRequestInfo: org.firebirdsql.jca.FBConnectionRequestInfo@47189c77; nested exception is:
       com.gefi.utils.ProjetDAOSysException: UtilCompte SQLException: Problem getting connection: javax.resource.ResourceException: Error in use of ManagedConnectionPool: matchManagedConnection failed with subject: Objet :
       Principal : sysdba
       Identité privée : javax.resource.spi.security.PasswordCredential@e8000000
       and ConnectionRequestInfo: org.firebirdsql.jca.FBConnectionRequestInfo@47189c77
      2004-04-18 16:00:26,704 INFO [STDOUT] GestionCompteDelegate : Tsy mety close Could not activate; CausedByException is:
       C:\jboss304\server\default\db\sessions\exeGestionCompteFacade\1082286779084.ser (Le fichier spécifié est introuvable)
      2004-04-18 16:00:26,704 ERROR [org.jboss.web.localhost.Engine] StandardWrapperValve[jsp]: "Servlet.service()" pour la servlet jsp a généré une exception
      org.apache.jasper.JasperException
       at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
       at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
       at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
       at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
       at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
       at java.lang.Thread.run(Thread.java:534)
      2004-04-18 16:00:26,704 ERROR [org.jboss.web.localhost.Engine] ----- Root Cause -----
      java.lang.NullPointerException
       at org.apache.jsp.ListeCompte_jsp._jspService(ListeCompte_jsp.java:60)
       at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
       at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
       at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
       at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
       at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
       at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
       at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
       at java.lang.Thread.run(Thread.java:534)
      

      I have seen with FireBird that the opener session is not closed and not reused.
      So I think the jboss closed this before opening another.

      So my question is :

      Is it an error because of incompatibilities between the database server and the
      application server or I make mistake in my programmation. I use the following :
      - driver downloded on ibphoenix.com for Firebird 1.5
      - use firebird-service.xml to register the database in JNDI
      - have create the xml files : ejb-jar, build.

      If somebody have any idea, please respond. I'm going to find solution for this problem
      since last 2 weeks!!! :-(

      Thanks!!


        • 1. Re: Firebird 1.5 and JBoss 3.0.4 .... Connection Pool Error?
          triathlon98

          Why do you post this on the JBoss forums?
          The stack trace clearly indicates that the problem is in your code.

          However, looking at the message, I would guess that something is going wrong with your credentials. In your -ds.xml file, have you set the correct user/password? Do you actually try to modify some settings on the connections?

          Joachim