Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (nike.apache.org: domain of
 eduardo.cavalcanti@eversystems.com.br designates 201.91.216.22 as permitted
 sender)
Message-ID: <4B61F6AD.3040709@eversystems.com.br>
Date: Thu, 28 Jan 2010 17:42:21 -0300
From: "Eduardo M. Cavalcanti" <ecavalcanti@eversystems.com.br>
Organization: Eversystems
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US;
 rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: CommitRequired attribute of transactionManager in iBatis 3
References: <27353435.post@talk.nabble.com>
 <000c01caa002$36882030$a3986090$@com>
In-Reply-To: <000c01caa002$36882030$a3986090$@com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

Hello,
The CommitRequired attribute of transactionManager, present in iBatis 2 
is no longer necessary in iBatis 3?

Quote from iBatis 2 manual:

"The <transactionManager> element also allows an optional attribute 
commitRequired that can be true or
false. Normally iBATIS will not commit transactions unless an insert, 
update, or delete operation has been
performed. This is true even if you explicitly call the 
commitTransaction() method. This behavior
creates problems in some cases. If you want iBATIS to always commit 
transactions, even if no insert,
update, or delete operation has been performed, then set the value of 
the commitRequired attribute to true.
Examples of where this attribute is useful include:

1. If you call a stored procedures that updates data as well as 
returning rows. In that case you would
call the procedure with the queryForList() operation � so iBATIS would 
not normally commit the
transaction. But then the updates would be rolled back.
2. In a WebSphere environment when you are using connection pooling and 
you use the JNDI
<dataSource> and the JDBC or JTA transaction manager. WebSphere requires 
all transactions on
pooled connections to be committed or the connection will not be 
returned to the pool."


How to proceed in iBatis 3 in the example cases mentioned?

Thank you.


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