- Connection handle has been closed and is unusable

Google

Mailing List

Home

Forum Home

JBoss - Java Application Server

Tomcat - JSP/Servlet container

Struts - A MVC web framework

iText - An open source PDF Java Library

JDOM - JDOM XML Parser

J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition

JSP - A mailing list about Java Server Pages specification and reference

J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog

Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology

Struts & Hibernate

Subjects

•	JSP editor plugin for eclipse ?
•	org apache jasper JasperException: Unable to compile class for JSP
•	Tomcat: Connection reset by peer: socket write error
•	Cannot retrieve definition for form bean null
•	Struts Tiles Tutorial (free Struts training)
•	Where do I download Tomcat 4 0 6?
•	Data Access Object (DAO) pattern, example DAO 's
•	Where to download Tomcat v 4 1 24 from?
•	Tomcat 5 0 16 Requested resource not available
•	Oracle Connection Pooling in 3 2 2
•	Servlet : Session invalidate
•	Servlet action is currently unavailable
•	Tomcat/Struts Unicode Encoding/Decoding problems
•	Tomcat and webapplication specific java library path
•	Running a Simple JMS Example
•	Mapping in workers2 properties
•	org apache jasper JasperException
•	Cannot find message resources under key org apache struts action MESSAGE
•	problem with html:text bean throwing exception
•	Cannot find message resources under key org apache struts action MESSAGE
•	invalid direct reference problem with solution
•	Tool for jsp debug Try Sysdeo Eclipse Plugin
•	Tomcat 5 Cannot load JDBC driver class 'null ' SQL state: null
•	weblogic ejbc
•	java properties file
•	Jboss 3 2 3 Coyote Can 't re
•	Tomcat 5, Apache2 and mod jk2 integration problem
•	JBoss example problem new to J2EE
•	url string for connecting jboss to oracle
•	Value attribute of <html:checkbox
•	javax servlet ServletException: BeanUtils populate
•	HTTP Status 404 The requested resource is not available
•	5 0 18: Windows XP Pro vs Windows 2000

- Connection handle has been closed and is unusable

- Connection handle has been closed and is unusable

2007-08-08 - By msduk

Back
Hi. There is a huge amount of noise relating to this error all over the place.
I'm not really sure if it is a seam/AS/Hibernate issue.

The stack is as follows

Caused by: java.sql.SQLException

: Connection handle has been closed and is
unusable
| at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus
(WrappedConnection.java:537)
| at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction
(WrappedConnection.java:524)
| at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement
(WrappedConnection.java:184)
| at org.hibernate.jdbc.AbstractBatcher

Source code of org.hibernate.jdbc.AbstractBatcher

(AbstractBatcher
.java:497)
| at org.hibernate.jdbc.AbstractBatcher

(AbstractBatcher
.java:415)
| at org.hibernate.jdbc.AbstractBatcher

(AbstractBatcher.java:139)
| at org.hibernate.loader.Loader

Source code of org.hibernate.loader.Loader

(Loader.java:1560)
| at org.hibernate.loader.Loader

(Loader.java:661)
| at org.hibernate.loader.Loader

(Loader.java:224)
| at org.hibernate.loader.Loader

(Loader.java:1918)

This was occurring frequently and I added

<valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss
.MysqlValidConnectionChecker</valid-connection-checker-class-name>
| <check-valid-connection-sql>SELECT count(warehouseId) FROM
warehouse</check-valid-connection-sql> which I dont think had an effect (the
errors were still common). I upgraded the hibernate versions in Seam 1.2.1 to
the latest hibernate which definitely reduced the frequency however they are
still there. Any suggestions welcome.

(Just in case it helps)
One thing I did notice which admittedly is likely a red herring is that the
errors seem to happen where concurrent modification is likely i.e. separate
threads modifying the same data. As one thread is only reading ever then I cant
see that this could be an issue.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic
&p=4072233#4072233

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode
=reply&p=4072233
__ ____ ____ ____ ____ ____ ____ ____ ____ ____
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user