[ https://issues.apache.org/jira/browse/DBCP-351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phil Steitz closed DBCP-351. ---------------------------- > setAutoCommit called too many times > ----------------------------------- > > Key: DBCP-351 > URL: https://issues.apache.org/jira/browse/DBCP-351 > Project: Commons Dbcp > Issue Type: Bug > Affects Versions: 1.4 > Reporter: OD > Fix For: 2.0 > > > 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) > { > conn.setAutoCommit(_defaultAutoCommit); > } -- This message was sent by Atlassian JIRA (v6.2#6252)