DBCP documentation says you need to validateConnection(connection) before you
close it e.g.http://wiki.apache.org/commons/DBCPMartin
______________________________________________ Disclaimer and confidentiality
note Everything in this e-mail and any attachments relates to the official
business of Sender. This transmission is of a confidential nature and Sender
does not endorse distribution to any party other than intended recipient.
Sender does not necessarily endorse content contained within this transmission.
> Date: Sun, 28 Dec 2008 12:25:05 -0800> From: gbatt...@alice.it> To:
users@tomcat.apache.org> Subject: java.sql.SQLException: Already
closed..strange!> > > Hello guys,> I've a strange problem with my jsp
application.> I use Tomcat 6.0.18.> I use connection pool with dbcp and this is
context.xml of my application> > > <?xml version="1.0" encoding="UTF-8"?>> <!--
Connessione al db sul server jsys-->> <Context path="/xxx" docBase="xxx"
debug="5" reloadable="true"> crossContext="true">>> <Resource auth="Container"
driverClassName="com.mysql.jdbc.Driver"> maxActive="200" maxIdle="200"
maxWait="200"> name="jdbc/x_db1" password="pwd" type="javax.sql.DataSource">
url="jdbc:mysql://xxx.x.xxx.x:3308/x_db1"> username="usrn"
removeAbandoned="true" removeAbandonedTimeout="60"> logAbandoned="true"/>>
</Context>> > > When I run application it works correctly.> Sometimes (I'm not
able to understand why) I've got, running application,> this error:> > > HTTP
Status 500 - > >
-------------------------------------------------------------------------------->
> type Exception report> > message > > description The server encountered an
internal error () that prevented it> from fulfilling this request.> > exception
> > org.apache.jasper.JasperException: javax.servlet.ServletException:>
java.sql.SQLException: Already closed.> >
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)>
>
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)>
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)>
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)> > > root cause >
> javax.servlet.ServletException: java.sql.SQLException: Already closed.> >
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)>
>
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)>
org.apache.jsp.index_jsp._jspService(index_jsp.java:256)>
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)>
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)> >
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)>
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)>
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)> > > root cause >
> java.sql.SQLException: Already closed.> >
org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:84)>
>
org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)>
org.apache.jsp.index_jsp._jspService(index_jsp.java:155)>
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)>
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)> >
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)>
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)>
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)> > > note The full
stack trace of the root cause is available in the Apache> Tomcat/6.0.16 logs.>
> >
-------------------------------------------------------------------------------->
> Apache Tomcat/6.0.16> > > If I add index.jsp to url (for example
www.myapps.it/index.jsp) it works> correctly, not showing previous error.> >
Another way to solve problem is to restart tomcat and it works correctly for>
many days...> It's not clear to me...could someone help me to understand?> Is
there some error with my connection pool?> > Thanks,> Regards > -- > View this
message in context:
http://www.nabble.com/java.sql.SQLException%3A-Already-closed..strange%21-tp21195800p21195800.html>
Sent from the Tomcat - User mailing list archive at Nabble.com.> > >
---------------------------------------------------------------------> To
unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org> For additional
commands, e-mail: users-h...@tomcat.apache.org>
_________________________________________________________________
Send e-mail faster without improving your typing skills.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_speed_122008
