JDBC EJB Pool connection threads not getting released
 Technote (FAQ)
 
Problem
Java™ database connectivity (JDBC) EJB Pool connection threads are not released properly. The EJB Stored Procedure shows pool connection threads are not released and the connection count increases by one.
 
Cause
This issue is an application error.
 
Solution
Adding the following line of code in the jvm.properties file helped identify that this issue is an application error:

com.ibm.ws390.ConnectionUsageScopeDefault=SeriallyReusable     

To avoid this problem, review the application code. You must complete the following steps in this order to ensure that the connections close properly:


  1. Open the connection.

  2. Call the Stored Procedure Statement.

  3. Process the results.

  4. Close the Statement.

  5. Close the connection.

 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS > DB Connections/Connection Pooling
Operating system(s): z/OS
Software version: 4.0.1
Software edition:
Reference #: 1166080
IBM Group: Software Group
Modified date: Mar 31, 2006