Hi everybody,

thank you for your help.

I'm using Tomcat 4.1.18. DBCP is integrated in Tomcat's common/lib
directory.

My application closes every PreparedStatement in finally blocks, so I
can say connections are correcly released to the pool when an exception
happens.

I would like to make more test to find out a solution, the "problem" is
I'm leaving on holidays this afternoon. I'll be back in two weeks, so I
hope I will solve the problem. Maybe upgrading the Tomcat version could
help.

Again, thank you very much.

Best regards,

Juan Pedro Lopez.

> Hi Juan,
>
> I just tested this with a web app I have running on Tomcat 4.1.24 with
> DBCP
> on Linux (Redhat 8.0) and it re-established the connection with no
> problem.
>
> I went through the following procedure:
>
> 1. Logged in to database with web app.
> 2. Searched the database and got a result set.
> 3. Killed Firebird on the Linux server.
> 4. Did another search, this time I got an error.
> 5. Restarted Firebird on the linux server
> 6. Did another search (without logging in again), and got a result
> set, no
> problem
>
> I did the same as above except I logged into the Tomcat Administrator
> web
> app. After I restarted Firebird I got an error the first time but it
> let me
> in on a second try. I may not have given firebird enough time to
> restart.
>
> What version of DBCP are you running? Tomcat?
>
> One note: The bean I wrote to get connections will catch the exception
> if
> getting a connection fails and try one more time before returning, so
> I may
> not have seen an exception if one was thrown on the first attempt.
>
> I'm not sure if DBCP is throwing an exception and then internally
> re-establishing a connection internally, or what.
>
> Rick
>
> ----- Original Message -----
>
> > Hi,
> >
> > > After you have shut down the db, you need to discard all the
> > pre-existing
> > > connections in the pool. If there is no way to do this with DBCP
> > you could
> > > consider using the built in jca based connection pooling which
> should
> > > discard connections if there is a fatal error (such as the db
> being shut
> > > down).
> > >
> >
> > So, if the solution is discarding pre-existing connections, does
> > anybody know how to do it with DBCP?
> >
> > What about using FBWrappingDataSource? I have tested my problem whit
> > it and it keep the same, so, is there any way to discard connections
> > with this pooling mechanism?
> >
> > What does it exactly mean to use the built-in jca connection
> pooling?
> > Can I use it with Tomcat or do I need a full J2EE application
> server?
> >
> > I could argue that after receiving a FBResourceEception, because of
> > any cause, the connection becomes "corrupted" and it's necessary to
> > close it. So a FBResourceEception can be considered a fatal
> exception
> > in any case. The question is: why is this exception thrown?
> >
> > Thanks.
> >
> > Juan Pedro Lopez
> >
> > >
> > > On 2003.07.31 04:05 Juan Pedro López Sáez wrote:
> > > > Hello all,
> > > >
> > > > I'm using Jaybird 1.0 and Firebird 1.0.3 in a Linux Machine.
> > > >
> > > > I've a JSP web application that access a Firebird database by
> means of
> > > > DBCP pooling mechanism. The database pool is set up in the init
> method
> > > > of a servlet filter (GetDbConnection). Every new http request
> gets
> > a new
> > > > connection from the pool in the doFilter method of the same
> > filter. The
> > > > filter passes the connection as a request attribute, so every
> JSP
> > in my
> > > > web application can retrieve it when needed. Finally, the
> > connection is
> > > > released to the pool, after the chain.doFilter method of the
> filter,
> > > > performing a java.sql.Connection.close(). Every Statement is
> closed in
> > > > the web application so the connection is supposed to be correcly
> > > > released to the pool.
> > > >
> > > > This schema seems to work fine, but I have a problem. Sometimes
> I have
> > > > to shutdown the database to perform some manteinance tasks. If
> the web
> > > > application tries to connect meanwhile, it gets a new connection
> from
> > > > the pool. When it calls
> java.sql.Connection.prepareStatement(String),
> > > > an FBResourceEception is thrown as it is expected (the database
> in
> > shut
> > > > down). The problem is the web application can't ever succeed
> calling a
> > > > conn.prepareStatement(strSel), even if the database is brought
> on
> > line.
> > > > It gets new connections from the pool, but
> > > >
> > > > org.firebirdsql.jca.FBResourceException: local transaction
> active:
> > can't
> > > > begin another
> > > >
> > > > is thrown again a again after every prepareStatement call.
> > > >
> > > > I must reload the web application in order to make things work.
> > > >
> > > > I think the problem is related to a kind of connection state
> > corruption.
> > > > After the first exception, because of the database shutdown,
> > connection
> > > > is released to the pool but it keeps in a wrong state. When the
> next
> > > > request retrieves the same pooled connection, it gets the
> > > > FBResourceException. When the application is reloaded, tha
> > database pool
> > > > is restarted, so new database connections are in a correct
> state.
> > > >
> > > > I have tested the same situation without pooled connections.
> After the
> > > > first exception, connection is closed. When the database is
> again on
> > > > line, new connections are error free and everything works fine.
> > > >
> > > > See below the web application's stack trace.
> > > >
> > > > Thank you in advance.
> > > >
> > > > Juan Pedro Lopez
> > > >
> > > >
> > > > 2003-07-29 20:50:36,664 FATAL
> com.altiria.wasp.mktSMS.beans.Promotion
> > > > Client:1 User:1 sId:9625C9334E83704AB0B018DAFB3C0B4E -
> .getBasicPromo:
> > > > Exception searching for K_PROMOTION field.
> > > > java.sql.SQLException: ResourceException:
> > > > org.firebirdsql.jca.FBResourceException: database
> > > > /var/lib/firebird/data/test_mktsms_R_1_0.gdb shutdown
> > > > Reason: database /var/lib/firebird/data/test_mktsms_R_1_0.gdb
> shutdown
> > > > at
> > > >
> >
> org.firebirdsql.jdbc.FBConnection.ensureInTransaction(FBConnection.java:100=
> > 3)
> > > > at
> > > >
> >
> org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:77=
> > )
> > > > at
> > > >
> >
> org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:243)
> > > > at
> > > >
> >
> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingCon=
> > nection.java:187)
> > > > at
> > > >
> >
> com.altiria.wasp.mktSMS.beans.Promotion.getBasicPromo(Promotion.java:834)
> > > > at
> > > >
> >
> org.apache.jsp.instantPushSimple_jsp._jspService(instantPushSimple_jsp.java=
> > :146)
> > > > 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(Applicatio=
> > nFilterChain.java:247)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC=
> > hain.java:193)
> > > > at
> > > >
> >
> com.altiria.wasp.mktSMS.filters.GetDbConnection.doFilter(GetDbConnection.ja=
> > va:103)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio=
> > nFilterChain.java:213)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC=
> > hain.java:193)
> > > > at
> > > >
> >
> com.altiria.wasp.mktSMS.filters.CheckActivity.doFilter(CheckActivity.java:5=
> > 5)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio=
> > nFilterChain.java:213)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC=
> > hain.java:193)
> > > > at
> > > >
> >
> com.altiria.wasp.mktSMS.filters.SetLoggingContext.doFilter(SetLoggingContex=
> > t.java:77)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio=
> > nFilterChain.java:213)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC=
> > hain.java:193)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j=
> > ava:260)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(StandardPipeline.java:643)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline.0invoke(StandardPipeline.java:480=
> > )
> > > > at
> > > >
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j=
> > ava:191)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(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.StandardContext.invoke(StandardContext.java:2415)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18=
> > 0)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(StandardPipeline.java:643)
> > > > at
> > > >
> >
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve=
> > .java:170)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(StandardPipeline.java:641)
> > > > at
> > > >
> >
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17=
> > 2)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(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.jav=
> > a:174)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(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.processConn=
> > ection(Http11Protocol.java:386)
> > > > at
> > > >
> >
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
> > > > at
> > > >
> >
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja=
> > va:530)
> > > > at java.lang.Thread.run(Thread.java:536)
> > > > 2003-07-29 20:50:38,490 DEBUG com.altiria.wasp.mktSMS.beans.User
> > > > Client:1 User:1 sId:9625C9334E83704AB0B018DAFB3C0B4E - In
> error.jsp
> > > > 2003-07-29 20:50:38,490 ERROR com.altiria.wasp.mktSMS.beans.User
> > > > Client:1 User:1 sId:9625C9334E83704AB0B018DAFB3C0B4E - Error
> page
> > shown.
> > > > 2003-07-29 20:50:38,491 DEBUG
> > > > com.altiria.wasp.mktSMS.filters.GetDbConnection Client:1 User:1
> > > > sId:9625C9334E83704AB0B018DAFB3C0B4E - GetDbConnection:
> Connection
> > > > closed.
> > > > 2003-07-29 20:50:38,491 DEBUG
> > > > com.altiria.wasp.mktSMS.filters.SetLoggingContext Client:1
> User:1
> > > > sId:9625C9334E83704AB0B018DAFB3C0B4E - SetLoggingContext:
> Removed
> > > > logging context
> > > >
> > > > ------ Now database in on line --------
> > > >
> > > > 2003-07-29 20:52:00,083 DEBUG
> > > > com.altiria.wasp.mktSMS.filters.GetDbConnection Client: User:
> sId: -
> > > > GetDbConnection: Connection opened
> > > > 2003-07-29 20:52:00,088 DEBUG com.altiria.wasp.mktSMS.beans.User
> > Client:
> > > > User: sId: - Enter isClientValid
> > > > 2003-07-29 20:52:00,088 FATAL com.altiria.wasp.mktSMS.beans.User
> > Client:
> > > > User: sId: - .isClientValid: Exception checking client id.
> > > > java.sql.SQLException: ResourceException:
> > > > org.firebirdsql.jca.FBResourceException: local transaction
> active:
> > can't
> > > > begin another
> > > > Reason: local transaction active: can't begin another
> > > > at
> > > >
> >
> org.firebirdsql.jdbc.FBConnection.ensureInTransaction(FBConnection.java:100=
> > 3)
> > > > at
> > > >
> >
> org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:77=
> > )
> > > > at
> > > >
> >
> org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:243)
> > > > at
> > > >
> >
> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingCon=
> > nection.java:187)
> > > > at
> com.altiria.wasp.mktSMS.beans.User.isClientValid(User.java:453)
> > > > at org.apache.jsp.dirlogin_jsp._jspService(dirlogin_jsp.java:84)
> > > > 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.ApplicationDispatcher.invoke(ApplicationDispatcher=
> > .java:684)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatc=
> > her.java:432)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatche=
> > r.java:356)
> > > > at
> > > >
> >
> org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)=
> >
> > > > at org.apache.jsp.index_jsp._jspService(index_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(Applicatio=
> > nFilterChain.java:247)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC=
> > hain.java:193)
> > > > at
> > > >
> >
> com.altiria.wasp.mktSMS.filters.GetDbConnection.doFilter(GetDbConnection.ja=
> > va:103)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio=
> > nFilterChain.java:213)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC=
> > hain.java:193)
> > > > at
> > > >
> >
> com.altiria.wasp.mktSMS.filters.SetLoggingContext.doFilter(SetLoggingContex=
> > t.java:77)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio=
> > nFilterChain.java:213)
> > > > at
> > > >
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC=
> > hain.java:193)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j=
> > ava:260)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(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.j=
> > ava:191)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(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.StandardContext.invoke(StandardContext.java:2415)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18=
> > 0)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(StandardPipeline.java:643)
> > > > at
> > > >
> >
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve=
> > .java:170)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(StandardPipeline.java:641)
> > > > at
> > > >
> >
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17=
> > 2)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(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.jav=
> > a:174)
> > > > at
> > > >
> >
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
> > keNext(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.processConn=
> > ection(Http11Protocol.java:386)
> > > > at
> > > >
> >
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
> > > > at
> > > >
> >
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja=
> > va:530)
> > > > at java.lang.Thread.run(Thread.java:536)
> > > > 2003-07-29 20:52:01,198 ERROR com.altiria.wasp.mktSMS.beans.User
> > Client:
> > > > User: sId: - Error page shown
> > > > 2003-07-29 20:52:01,199 DEBUG
> > > > com.altiria.wasp.mktSMS.filters.GetDbConnection Client: User:
> sId: -
> > > > GetDbConnection: Connection closed.
> > > > 2003-07-29 20:52:01,199 DEBUG
> > > > com.altiria.wasp.mktSMS.filters.SetLoggingContext Client: User:
> sId: -
> > > > SetLoggingContext: Removed logging context
> > > >
> > > > --
> > > > Juan Pedro López Sáez
> > > > ALTIRIA TIC, S.L.L.
> > > > www.altiria.com
> > > >
> > > >
> > > >
> > > >
> > > > To unsubscribe from this group, send an email to:
> > > > Firebird-Java-unsubscribe@yahoogroups.com
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > > >
> > > >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Firebird-Java-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> click here
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
Juan Pedro López Sáez
ALTIRIA TIC, S.L.L.
www.altiria.com