Return-Path: 
 <user-java-return-15625-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 91071 invoked from network); 21 Nov 2008 18:13:16 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 21 Nov 2008 18:13:16 -0000
Received: (qmail 77334 invoked by uid 500); 21 Nov 2008 18:13:24 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 76990 invoked by uid 500); 21 Nov 2008 18:13:22 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 76979 invoked by uid 99); 21 Nov 2008 18:13:22 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Nov 2008 10:13:22 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of Christian.Poitras@ircm.qc.ca
 designates 207.162.51.9 as permitted sender)
Received: from [207.162.51.9] (HELO MGATE.ircm.qc.ca) (207.162.51.9)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Nov 2008 18:11:59 +0000
Received: from Poste.ircm.qc.ca (unverified [172.16.9.32]) by MGATE.ircm.qc.ca
  (Vircom SMTPRS 4.5.654.0) with ESMTP id <B0008351640@MGATE.ircm.qc.ca> for
 <user-java@ibatis.apache.org>;
  Fri, 21 Nov 2008 13:12:17 -0500
X-Modus-BlackList: 172.16.9.32=OK;Christian.Poitras@ircm.qc.ca=OK
X-Modus-Trusted: 172.16.9.32=YES
X-Modus-Audit: FALSE;0;0;0
Received: from HERMES.ircm.priv ([172.16.9.26]) by hubcli2.ircm.priv
 ([172.16.9.32]) with mapi; Fri, 21 Nov 2008 13:12:20 -0500
From: Poitras Christian <Christian.Poitras@ircm.qc.ca>
To: "'user-java@ibatis.apache.org'" <user-java@ibatis.apache.org>
Date: Fri, 21 Nov 2008 13:12:19 -0500
Subject: RE: Beginner question on transactions...
Thread-Topic: Beginner question on transactions...
Thread-Index: AclMA6/PHYcAJXx7S+SRbuR5ERz3KwAAOPMg
Message-ID: <93B0CB1886D4CC48823246865D80DC94032CCB66FF5F@HERMES.ircm.priv>
References: <E851D5A39CC341A6B53F0E98CFD1293C@PADYLAPTOP>
In-Reply-To: <E851D5A39CC341A6B53F0E98CFD1293C@PADYLAPTOP>
Accept-Language: fr-FR, en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
acceptlanguage: fr-FR, en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Checked: Checked by ClamAV on apache.org

Are your tables in InnoDB or MyISAM?

InnoDB tables are required in MySQL to support transactions.

Christian

-----Original Message-----
From: Comcast Mail [mailto:prabha_pady@comcast.net]
Sent: Friday, November 21, 2008 1:04 PM
To: user-java@ibatis.apache.org
Subject: Beginner question on transactions...


Hi.

I have code that does the following:

try {
DaoManager.startTransaction();
// loop and do some inserts
...
DaoManager.commitTransaction();
} catch ( Exception ex ) {
  ...
} finally {
  DaoManager.endTransaction();
}


One of the insert fails but the previous inserts have been committed.
Although the commitTransaction is never reached.

here is my transaction block from sqlmapconfig.xml ( pointing to mysql data=
base )...

<transactionManager type=3D"JDBC" commitRequired=3D"true">

<dataSource type=3D"SIMPLE">

<property name=3D"JDBC.Driver" value=3D"com.mysql.jdbc.Driver"/>

<property name=3D"JDBC.ConnectionURL" value=3D"jdbc:mysql://localhost/test"=
/>

<property name=3D"JDBC.Username" value=3D"..."/>

<property name=3D"JDBC.Password" value=3D"..."/>

<property name=3D"DefaultAutoCommit" value=3D"false"/>

<property name=3D"SetAutoCommitAllowed" value=3D"false"/>

</dataSource>

</transactionManager>



Any ideas. Help appreciated.



Thanks



-- pady