Return-Path: 
 <tomcat-user-return-130718-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 65560 invoked from network); 2 Aug 2005 13:02:00 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 2 Aug 2005 13:02:00 -0000
Received: (qmail 70795 invoked by uid 500); 2 Aug 2005 13:01:34 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 70691 invoked by uid 500); 2 Aug 2005 13:01:34 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 70678 invoked by uid 99); 2 Aug 2005 13:01:34 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Aug 2005 06:01:34 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [194.247.214.130] (HELO Firewall.ev.co.yu) (194.247.214.130)
    by apache.org (qpsmtpd/0.29) with SMTP; Tue, 02 Aug 2005 06:01:24 -0700
Received: by Firewall.ev.co.yu; (5.65v4.0/1.3/10May95) id AA12440;
 Mon, 2 Aug 1999 15:13:45 +0200
Received: from [192.168.61.128] (brigitte.up.ev.co.yu [192.168.61.128])
	by Uprava.ev.co.yu (8.13.1/8.13.1) with ESMTP id j72Cx6P6013090
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO)
	for <tomcat-user@jakarta.apache.org>;
 Tue, 2 Aug 2005 14:59:07 +0200 (MET DST)
Message-Id: <42EF6EA7.9040102@ev.co.yu>
Date: Tue, 02 Aug 2005 15:01:27 +0200
From: Nikola Milutinovic <Nikola.Milutinovic@ev.co.yu>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.7.10) Gecko/20050716
X-Accept-Language: en-us, en
Mime-Version: 1.0
To: Tomcat Users List <tomcat-user@jakarta.apache.org>
Subject: Re: How to set auto-commit to false on a Tomcat Connection-Pool?
References: <5684A7E6FB10504393A2806C1F4C0210076CE1D2@orion.qas.com>
In-Reply-To: <5684A7E6FB10504393A2806C1F4C0210076CE1D2@orion.qas.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Allistair Crossley wrote:

>I found this on the web for Struts using org.apache.commons.dbcp.BasicDataSource which I believe Tomcat also uses. Therefore perhaps you can try defaultAutoCommit instead.
>
><data-source key="homeDS" type="org.apache.commons.dbcp.BasicDataSource">
><set-property property="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
><set-property property="url" value="jdbc:oracle:thin:@localhost:1521:DBLOCAL" />
><set-property property="username" value="user" />
><set-property property="password" value="pwd" />
><set-property property="maxActive" value="10" />
><set-property property="maxWait" value="5000" />
><set-property property="defaultAutoCommit" value="false" />
><set-property property="defaultReadOnly" value="false" />
><set-property property="validationQuery" value="SELECT SYSDATE FROM DUAL" />
></data-source> 
>  
>

All of these are documented on Jakarta Commons-DBCP page.

Nix.

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