PQ72451, 5.0: Prepared Statement not properly closed
 Downloadable files
 
Abstract
Prepared statement is not properly closed if duplicate exists using WebSphere prepared statement cache feature
 
Download Description

USERS AFFECTED: WebSphere Application Server users of prepared statement caching and prepare an SQL statement with the same SQL string more than once in a single transaction, and do not close the prepared statement between prepare API calls.

PROBLEM DESCRIPTION: WebSphere Users will notice that the application will continue to function normally, however the JVM memory footprint may continue to grow. If the customer then reviews a java heap dump, they will notice a large number of objects awaiting finalization.

RECOMMENDATION: The SQL string is the key for the prepared statement cache,
allowing only one of the duplicate prepared statements to be preserved in the cache.
The references to others are dropped without invoking the JDBC driver close method. This causes these statements to consume memory until JVM garbage collection occurs.
 
Prerequisites
Install/swg24001908.html
 
 
Installation Instructions
Please review the readme.txt for detailed installation instructions.
 
URL LANGUAGE SIZE(Bytes)
Readme US English 4767
 
Download package
What is DD?
Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
PQ72451 3/27/2003 US English 4982 FTP DD
 
Technical support
1-800-IBM-SERV (U.S. calls only)
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
Problems (APARS) fixed
PQ72451
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): Windows
Software version: 5.0
Software edition:
Reference #: 4004565
IBM Group: Software Group
Modified date: Apr 11, 2003