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 fixProblem 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 fixComments
APAR information | APAR number | PQ44479 | Reported component name | WAS ADVANCED AI | Reported component ID | 5648C8400 | Reported release | 350 | Status | CLOSED PER | PE | NoPE | HIPER | NoHIPER | Submitted date | 2000-12-19 | Closed date | 2001-01-31 | Last modified date | 2001-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 APAR is sysrouted TO one or more of the following:Modules/Macros
|
Fix information |
Fixed component name | WAS ADVANCED AI | Fixed component ID | 5648C8400 |
Applicable component levels | R350 PSY | UP |
|