Fixes are available
9.0.0.9: WebSphere Application Server traditional V9.0 Fix Pack 9
9.0.0.10: WebSphere Application Server traditional V9.0 Fix Pack 10
9.0.0.11: WebSphere Application Server traditional V9.0 Fix Pack 11
9.0.5.0: WebSphere Application Server traditional Version 9.0.5 Refresh Pack
9.0.5.1: WebSphere Application Server traditional Version 9.0.5 Fix Pack 1
9.0.5.2: WebSphere Application Server traditional Version 9.0.5 Fix Pack 2
9.0.5.3: WebSphere Application Server traditional Version 9.0.5 Fix Pack 3
APAR status
Closed as program error.
Error description
If there's some issue with the preTestSQLString, whenever the application requests a connection, an error will be returned and application cannot get any valid connection, and there might be large number of unhandled open connections to DB server established when doing preTest connections.
Local fix
Correct the SQL error
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server data sources * **************************************************************** * PROBLEM DESCRIPTION: Connection leak after sucessfully * * obtaining connection if unable to * * initialize it. * **************************************************************** * RECOMMENDATION: * **************************************************************** If a connection is sucessfully obtained but an error occurs trying to initialize it (for example, if Connection.getSchema fails), the connection is leaked.
Problem conclusion
Code has been updated to trap for errors during initialization and ensure that connection are properly closed out, so as to avoid connection leaks. The fix for this APAR is currently targeted for inclusion in fix pack 9.0.0.9. Please refer to the Recommended Updates page for delivery information: http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
Temporary fix
Comments
APAR Information
APAR number
PI98542
Reported component name
WEBS APP SERV N
Reported component ID
5724H8800
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-05-30
Closed date
2018-06-08
Last modified date
2018-06-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WEBS APP SERV N
Fixed component ID
5724H8800
Applicable component levels
R900 PSY
UP
Document Information
Modified date:
01 November 2021