ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Comcast Mail" <prabha_p...@comcast.net>
Subject Re: Beginner question on transactions...
Date Fri, 21 Nov 2008 18:35:00 GMT

The tables were created with Engine=InnoDB

mysql 5.0.27

Thx

-- pady



----- Original Message ----- 
From: "Poitras Christian" <Christian.Poitras@ircm.qc.ca>
To: <user-java@ibatis.apache.org>
Sent: Friday, November 21, 2008 1:12 PM
Subject: RE: Beginner question on transactions...


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 
database )...

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

<dataSource type="SIMPLE">

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

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

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

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

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

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

</dataSource>

</transactionManager>



Any ideas. Help appreciated.



Thanks



-- pady


Mime
View raw message