tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Gainty <mgai...@hotmail.com>
Subject RE: java.sql.SQLException: Already closed..strange!
Date Mon, 29 Dec 2008 01:56:55 GMT

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: gbattine@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-unsubscribe@tomcat.apache.org> For additional commands, e-mail:
users-help@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
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message