[DBCP-23] [dbcp] SQLException When PoolablePreparedStatement Already Closed

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2
• Fix Version/s: 1.3

Environment

Operating System: All
Platform: All

• Bugzilla Id: 32441
• Assignee: Unassigned
• Reporter: Jacob Zwiers
• Created: 30/Nov/04 12:33
• Updated: 25/Mar/08 08:11
• Resolved: 19/Jul/07 04:13

Description

When closing an already closed
org.apache.commons.dbcp.PoolablePreparedStatement, a SQLException is thrown when
the isClosed() method returns true.

This seems to violate the contract of java.sql.Statement (super interface of
implemented PreparedStatement) whose javadoc reads " Calling the method close on
a Statement object that is already closed has no effect."

Work around exists – when ever closing a statement, also null out. Then,
before closing, check that it's non-null.