PQ44479: CLI0129E NO MORE HANDLES ERROR DETECTED IN WAS STDERR.LOG WITH SELECTSTATEMENT


APAR

APAR status
Closed as program error.

Error description
On AIX 4.3.3, WAS v3.5 with fp1, UDB v7.1 with fp1,
CLI0129E No more handles comes out if SelectStatement
is called 1500 times or more in user servlet.
Using WAS datasource.
The error occures on WAS select bean statement, never
occured in JDBC statement, customer said.
Local fix
Problem summary
****************Note********************
This APAR has been superceded by PQ46883
****************************************
Error "IBM CLI Driver CLI0129E No more handles"
when opening numerous SelectStatements through DataAccessBeans,
which each opened a PreparedStatement (numerous is > 2000,
depending on DB2 APPLHEAPSZ).
Problem conclusion
Problem is that in the PreparedStatement
statement is cached, even though they are no longer necessary.
Therefore, the solution is to make sure that the cached
statement is being closed and not cached.  Code was changed in:
StatementCache.java
statement is being closed and not cached. Code was changed in:StatementCache.java
Temporary fix
Comments
APAR information
APAR numberPQ44479
Reported component nameWAS ADVANCED AI
Reported component ID5648C8400
Reported release350
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Submitted date2000-12-19
Closed date2001-01-31
Last modified date2001-04-06

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
EJS
APAR is sysrouted TO one or more of the following:Modules/Macros

Fix information
Fixed component nameWAS ADVANCED AI
Fixed component ID5648C8400

Applicable component levels
R350 PSYUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ44479
IBM Group: Software Group
Modified date: 2001-04-06