You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Mark W (JIRA)" <ji...@apache.org> on 2014/04/09 22:10:16 UTC
[jira] [Updated] (DBCP-413) Closing a Connection does not close
Statement objects created on that connection, by way of the close() method.
[ https://issues.apache.org/jira/browse/DBCP-413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mark W updated DBCP-413:
------------------------
Description:
While using the MS SQL 2012 jdbc drivers with dbcp, I noticed that if you create a connection, then create a preparedStatement from that connection, and close the connection object, PreparedStatement.isClosed() will return false, but you will get a SQLException stating the statement has been closed if you attempt to call any of the set or execute methods.
>From the JDBC spec:
Connection.close
An application calls the method Connection.close() to indicate that it has finished using a connection. All Statement objects created from a given Connection object will be closed when the close method for the Connection object is called.
was:While using the MS SQL 2012 jdbc drivers with dbcp, I noticed that if you create a connection, then create a preparedStatement from that connection, and close the connection object, PreparedStatement.isClosed() will return false, but you will get a SQLException stating the statement has been closed if you attempt to call any of the set or execute methods.
> Closing a Connection does not close Statement objects created on that connection, by way of the close() method.
> ---------------------------------------------------------------------------------------------------------------
>
> Key: DBCP-413
> URL: https://issues.apache.org/jira/browse/DBCP-413
> Project: Commons Dbcp
> Issue Type: New Feature
> Affects Versions: 1.4
> Reporter: Mark W
> Priority: Minor
>
> While using the MS SQL 2012 jdbc drivers with dbcp, I noticed that if you create a connection, then create a preparedStatement from that connection, and close the connection object, PreparedStatement.isClosed() will return false, but you will get a SQLException stating the statement has been closed if you attempt to call any of the set or execute methods.
> From the JDBC spec:
> Connection.close
> An application calls the method Connection.close() to indicate that it has finished using a connection. All Statement objects created from a given Connection object will be closed when the close method for the Connection object is called.
--
This message was sent by Atlassian JIRA
(v6.2#6252)