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

[Kenneth Hensel]

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&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130125/b67804cd/attachment.html