PQ57315: NO REAP TIME PARAMETER IN 2.0 CONNECTION MANAGER IN WAS 3.5

A fix is available
3.5.4-3.5.7, 4.0.2-4.0.7: Component cumulative Connection Manager fix

APAR

APAR status
Closed as program error.

Error description
Customer requests that the reap time and reuse parameters be ena
bled for the 2.0 connection manager included in WAS 3.5.  Custom
er would like to be able to change this settings to close unused
database connections.
Local fix
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Servers users of       *
*                 WebSphere's 2.0 Connection Manager in 3.5.   *
****************************************************************
* PROBLEM DESCRIPTION: Users are unable to set connection      *
*                      pooling parameters, they can be set     *
*                      using IBMConnPoolSpec, but they do not  *
*                      take effect                             *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Setting connection pool parameters for the pool created using
IBMConnMgr does not work when using the IBMConnPoolSpec.
While the IBMConnPoolSpec allows the parameters to be set,
the object does not pass these on to the connection pool.
Problem conclusion
A workaround is provided that allows the application to
change the default parameters for the WAS20ConnMgr.
Note that this only works before getting the connection pool
from the IBMConnMgr and can not be used to change the
parameters on the pool after the pool has been created.
Example:
    import com.ibm.ejs.dbm.jdbcext.*;
    import com.ibm.ejs.dbm.was20.*;

    PoolSpec defPS = WAS20ConnMgr.getDefaultPoolSpec();
    defPS.setMinConnections(2);    // Set min to 2
    defPS.setMaxConnections(6);    // Set max to 6
    defPS.setOrphanTimeout(30);    // Set orphan to 30 sec
    defPS.setIdleTimeout(60);      // Set idle to 60 seconds
    defPS.setTimeout(90);          // Set conn timeout 90 sec
    com.ibm.servlet.connmgr.IBMJdbcConnSpec jdbcConnSpec = null;

    jdbcConnSpec = new
        com.ibm.servlet.connmgr.IBMJdbcConnSpec(poolname,
            true, driver, URL, userID, password);

    connectionManager = com.ibm.servlet.connmgr.
                      IBMConnMgrUtil.getIBMConnMgr();

    if ("".equals(getOwnerClass()))
        setOwnerClass((this.getClass()).getName());

    if ("".equals(getOwnerClass()))
        ibmJdbcConn = (com.ibm.servlet.connmgr.IBMJdbcConn)
            connectionManager.getIBMConnection(jdbcConnSpec);
   else
        ibmJdbcConn = (com.ibm.servlet.connmgr.IBMJdbcConn)
            connectionManager.getIBMConnection(jdbcConnSpec,
             getOwnerClass());
Example:import com.ibm.ejs.dbm.jdbcext.*;import com.ibm.ejs.dbm.was20.*;PoolSpec defPS = WAS20ConnMgr.getDefaultPoolSpec();defPS.setMinConnections(2); // Set min to 2defPS.setMaxConnections(6); // Set max to 6defPS.setOrphanTimeout(30); // Set orphan to 30 secdefPS.setIdleTimeout(60); // Set idle to 60 secondsdefPS.setTimeout(90); // Set conn timeout 90 seccom.ibm.servlet.connmgr.IBMJdbcConnSpec jdbcConnSpec = null;jdbcConnSpec = newcom.ibm.servlet.connmgr.IBMJdbcConnSpec(poolname,true, driver, URL, userID, password);connectionManager = com.ibm.servlet.connmgr.IBMConnMgrUtil.getIBMConnMgr();if ("".equals(getOwnerClass()))setOwnerClass((this.getClass()).getName());if ("".equals(getOwnerClass()))ibmJdbcConn = (com.ibm.servlet.connmgr.IBMJdbcConn)connectionManager.getIBMConnection(jdbcConnSpec);elseibmJdbcConn = (com.ibm.servlet.connmgr.IBMJdbcConn)connectionManager.getIBMConnection(jdbcConnSpec,getOwnerClass());
Temporary fix
Comments
APAR information
APAR numberPQ57315
Reported component nameWAS STANDARD AI
Reported component ID5648C8300
Reported release350
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Submitted date2002-01-30
Closed date2002-02-18
Last modified date2002-02-18

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:APAR is sysrouted FROM one or more of the following:


Modules/Macros
JDBC
APAR is sysrouted TO one or more of the following:Modules/Macros

Fix information
Fixed component nameWAS STANDARD AI
Fixed component ID5648C8300

Applicable component levels
R350 PSYUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ57315
IBM Group: Software Group
Modified date: 2002-02-18