Return-Path: <brandon.goodin@gmail.com>
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 57335 invoked by uid 99); 1 Jan 2005 20:21:14 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of brandon.goodin@gmail.com
 designates 64.233.170.198 as permitted sender)
Received: from rproxy.gmail.com (HELO rproxy.gmail.com) (64.233.170.198)
  by apache.org (qpsmtpd/0.28) with ESMTP; Sat, 01 Jan 2005 12:21:11 -0800
Received: by rproxy.gmail.com with SMTP id c16so247501rne
        for <ibatis-user-java@incubator.apache.org>;
 Sat, 01 Jan 2005 12:21:09 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
        b=JZQhELAYc+UaR/J+W8FKbDCOP8P7Q5oh5ndP4a3WpeSH1DEpE+9qcIIpp139tX25/euhNgTzXygckbRNT/6SkL8H3w5+SQnjuNi72Yvzj079GpL9Evo0LURDgoivrq3A4zI+na4VxxSprwLg2cSwabESsd9o7s9AGqH7Hf+xc4A=
Received: by 10.38.81.67 with SMTP id e67mr446826rnb;
        Sat, 01 Jan 2005 12:21:09 -0800 (PST)
Received: by 10.38.74.57 with HTTP; Sat, 1 Jan 2005 12:21:09 -0800 (PST)
Message-ID: <2fe5ef5b050101122178e8a8ed@mail.gmail.com>
Date: Sat, 1 Jan 2005 13:21:09 -0700
From: Brandon Goodin <brandon.goodin@gmail.com>
Reply-To: Brandon Goodin <brandon.goodin@gmail.com>
To: ibatis-user-java@incubator.apache.org
Subject: Re: Turning transaction auto-commit off.
In-Reply-To: <6.1.1.1.2.20050101135024.02578a90@express.cites.uiuc.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <6.1.1.1.2.20050101135024.02578a90@express.cites.uiuc.edu>
X-Virus-Checked: Checked

if you want it off... shouldn't it be...
<property name="JDBC.DefaultAutoCommit" value="false" />


On Sat, 01 Jan 2005 14:18:05 -0600, Albert L. Sapp <asapp@uiuc.edu> wrote:
> In reading over information on the Oracle JDBC driver, it says that I must
> use this command to turn auto-commit off.
> 
> Connection.setAutoCommit(false);
> 
> In the sql-map-config.xml file, I find this property line.
> 
> <property name="JDBC.DefaultAutoCommit" value="true" />
> 
> So I figure all I need to do is change this to false and recompile and
> redeploy the application.  Does not work.  Still can not do a group of
> executeUpdate commands and get them to rollback or commit as a whole.  They
> are all inside a startTransaction/commitTransaction block with a
> endTransaction being executed if a exception is thrown.
> 
> I start checking all our files to see if I can find where anything like the
> Connection command is being done.  No good, nothing like it.
> 
> So, I am stuck.  I am trying to learn all this as I use it.  I have only
> been working with Java, iBatis, Struts and xml for about a year.
> 
> Any pointers that any of you could give would be greatly appreciated.
> 
> Al
> 
>