commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "OD (JIRA)" <>
Subject [jira] Created: (DBCP-351) setAutoCommit called too many times
Date Tue, 01 Feb 2011 12:48:29 GMT
setAutoCommit called too many times

                 Key: DBCP-351
             Project: Commons Dbcp
          Issue Type: Bug
    Affects Versions: 1.4
            Reporter: OD

passivateObject in PoolableConnectionFactory sets autoCommit to true, even if defaultAutoCommit
is set to false. This results in two extra db queries for every use of the connection (set
false, do work, set true). This creates a significant amount of overhead, even if the connection
is never even used.

I propose it be changed to:

if(conn.getAutoCommit() != _defaultAutoCommit)

This message is automatically generated by JIRA.
For more information on JIRA, see:


View raw message