Mailing-List: contact user-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Users List" <user@commons.apache.org>
Received-SPF: pass (athena.apache.org: domain of
 kostas.g.papadopoulos@gmail.com designates 72.14.214.228 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=uUH9d78zheMLFeXZIXa7/8CkBm2ig5UNI58yNmBVmTc7ADgXVh661+1c0vMMtUf7sZtX+GSCbLF4TsB1jHLcz9Dv5ilbUHP5N36efVW3eLJHf0vTAD6Y/ngMgjboDieKXRx9YZN02Fc17KFupVyd7o8JhpvIsEVjBxNEaoI4UaA=
Message-ID: <d55d72160710182121t65b084d4ra200a0d28c77e63@mail.gmail.com>
Date: Fri, 19 Oct 2007 07:21:34 +0300
From: "Kostas Papadopoulos" <kostas.g.papadopoulos@gmail.com>
To: "Jakarta Commons Users List" <user@commons.apache.org>
Subject: Re: tomcat and setAutoCommit
In-Reply-To: <4717D0A0.1060906@hanik.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <d55d72160710161250r753e43as6451bb1d7887ee6d@mail.gmail.com>
	 <4717D0A0.1060906@hanik.com>

Thanks,

This was issue DBCP-102. I should have checked there first. It is
marked resolved but it still sets autocommit to true in
passivateObject(), so it will need some work to remove the overhead.

kostas

On 10/19/07, Filip Hanik - Dev Lists <devlists@hanik.com> wrote:
> looks like it is hard coded in commons-dbcp to set autocommit to true
>
> PoolableConnectionFactory.java
>
> public void passivateObject(Object obj) throws Exception {
>         if(obj instanceof Connection) {
>             Connection conn = (Connection)obj;
>             if(!conn.getAutoCommit() && !conn.isReadOnly()) {
>                 conn.rollback();
>             }
>             conn.clearWarnings();
>             if(!conn.getAutoCommit()) {
>                 conn.setAutoCommit(true);
>             }
>         }
>         if(obj instanceof DelegatingConnection) {
>             ((DelegatingConnection)obj).passivate();
>         }
>     }
>
> If you feel this is incorrect, or cause overhead, then file a bug with
> the DBCP folks
>
> Filip
>
> Kostas Papadopoulos wrote:
> > I'm using tomcat/jdbc/mysql with the tomcat suplied DBCP connection
> > pool configured with defaultAutoCommit=false. After tracing the
> > queries sent to the database, I've noticed that a "set autocommit=1"
> > is always followed by "set autocommit=0". I'm not sure who is setting
> > "autocommit=1", probably the connection.close()  in the pool
> > somewhere.
> >
> > Is there a way to make it stop? Can anyone know of a reason why this
> > would be needed?
> >
> > Thanks
> > Kostas
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
> > For additional commands, e-mail: user-help@commons.apache.org
> >
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
> For additional commands, e-mail: user-help@commons.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org