tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Smith <d...@cornell.edu>
Subject Re: java.sql.SQLException: Already closed..strange!
Date Mon, 29 Dec 2008 04:59:01 GMT
>
> DBCP documentation says you need to validateConnection(connection) before you close it



No you don't.  Just close the connection DBCP returned when you called
DataSource.getConnection()

--David

Martin Gainty wrote:
> 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
>   


-- 
David Smith
Programmer/Analyst
College of Agriculture and Life Sciences
Cornell University
B32 Morrison Hall
Ithaca, NY 14853
Phone: (607) 255-4521



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message