Bug #26592 PreparedStatement is not closed in BlobFromLocator.getBytes

• Submitted: 23 Feb 2007 14:35
• Modified: 13 Apr 2007 10:33
• Reporter: Constantine Bozhkov
• Status: Closed
• Category: Connector/J
• Severity: S2 (Serious)
• Version: 5.0.4
• OS: Any (All)

[23 Feb 2007 14:35] Constantine Bozhkov

Description:
Method BlobFromLocator.getBytes(long, int) creates a new PreparedStatement, which is not
closed afterwards. The code in the 'finally' block attempts to close a result set, which
is never initialized in this method.

In a web application using a pool to connect to the DB these PreparedStatements
accumulate and finally cause OutOfMemoryError.

How to repeat:
No need to repeat, the bug is obvious when looking at code.

Suggested fix:
Replace blobRs with pStmt in the finally block and remove blobRs variable.

[1 Mar 2007 23:00] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/20950

[13 Apr 2007 10:33] MC Brown

A note has been added to the 5.0.6 changelog.