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 fixProblem 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 fixComments
APAR information | APAR number | PQ57315 | Reported component name | WAS STANDARD AI | Reported component ID | 5648C8300 | Reported release | 350 | Status | CLOSED PER | PE | NoPE | HIPER | NoHIPER | Submitted date | 2002-01-30 | Closed date | 2002-02-18 | Last modified date | 2002-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 APAR is sysrouted TO one or more of the following:Modules/Macros
|
Fix information |
Fixed component name | WAS STANDARD AI | Fixed component ID | 5648C8300 |
Applicable component levels | R350 PSY | UP |
|