[jira] [Created] (DBCP-558) DelegatingConnection setReadOnly and setAutoCommit sometimes caches the wrong value

["Louis Latreille (Jira)" <ji...@apache.org>]

Louis Latreille created DBCP-558:
------------------------------------

             Summary: DelegatingConnection setReadOnly and setAutoCommit sometimes caches the wrong value
                 Key: DBCP-558
                 URL: https://issues.apache.org/jira/browse/DBCP-558
             Project: Commons DBCP
          Issue Type: Bug
    Affects Versions: 2.2.0
            Reporter: Louis Latreille
             Fix For: 2.7.1


DelegatingConnection caches the input of setReadOnly and setAutoCommit directly without checking if the underlying connection succeeded in setting the configuration parameter. This results in wrong return value from isReadOnly and getAutoCommit if the underlying connection doesn't support read-only/non-read-only or auto-commit/non-auto-commit connections, as with SqlServerConnection.

 

To reproduce the issue:
 # Create a DelegatingConnection with an underlying SqlServerConnection
 # Set the connection read-only `con.setReadOnly(true)`
 # Query the read-only state on the DelegatingConnection, you will get true
 # Query the read-only state of the underlying SqlServerConnection, you will get false (SqlServer JDBC driver doesn't support read-only connections)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)