[jboss-user] [Datasource Configuration] - Problem with Closed Connection jboss-as-7.1.1(2, 3)

Kenneth Hensel [https://community.jboss.org/people/khensel] created the discussion "Problem with Closed Connection jboss-as-7.1.1(2,3)" To view the discussion, visit: https://community.jboss.org/message/794406#794406 -------------------------------------------------------------- I have been struggling with this for awhile and I'm not sure if it's a problem with jboss or on the database side or the VPN. Our configuration is as such: We are connectin to a DB2 mainframe from Redhat Linux.  The Linux machine has a VPN in place that encrypts the data as it comes across.  We have DB2 Connect installed, but I am bypassing it by going directly to the MF through the VPN using type 4 DB2 driver.  I am running JBoss-as-7.1.3 (compiled from source).  I am running CXF Restful Web Services to get data to pass on to another application.  The error occurs in the DAOs.   Things will run OK for awhile after I clean start JBoss 7, then we intermittently get the following types of errors: 10:21:58,719 ERROR [edu.berkeley.eas.enrollment.dao.classlist.TelebearsClassListDao] (http-/127.0.0.1:8380-74) +++ Exception occurred in stuprod.sect205f: CallableStatementCallback; SQL [{call stuprod.sect205f(?, ?, ?, ?, ?)}]; [jcc][t4][10335][10366][3.57.110] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003; nested exception is com.ibm.db2.jcc.am.io: [jcc][t4][10335][10366][3.57.110] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003: org.springframework.dao.DataAccessResourceFailureException: CallableStatementCallback; SQL [{call stuprod.sect205f(?, ?, ?, ?, ?)}]; [jcc][t4][10335][10366][3.57.110] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003; nested exception is com.ibm.db2.jcc.am.io: [jcc][t4][10335][10366][3.57.110] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 Caused by: com.ibm.db2.jcc.am.io: [jcc][t4][10335][10366][3.57.110] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 The errors happen more and more until all I get in the log are these errors.  They happen in every stored procedure call (DAO), so it's no specific one. I have attached the custom standalone.xml (enrollment-services.xml).  I have tried many combinations of connection pool, threads (jca) etc and it always happens again.   I am also attaching sample java classes for DAO and a service class. This has become a real problem as this morning my production log has 5 million lines in it.  Please help if you can. Let me know if you need any more information. Thanks, Ken -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/794406#794406] Start a new discussion in Datasource Configuration at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]