ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Koka Kiknadze" <226...@gmail.com>
Subject Re: Autocommit not properly handled in Ibatis.
Date Thu, 25 Jan 2007 15:21:20 GMT
>
>   In iBATIS SELECT case, no commit or rollback is executed ...
>
> *Question:*
> How do you interpret this fact?
>
>

Not sure what kind of interpretation you ask for ;)

Again, if the code looks like (you can leave out startTransaction /
commitTransaction in defaultAutocommit=true mode, as iBatis will internally
add those for any SQL statement) :
sqlMapClient.startTransaction();
sqlMapClient..queryFor...();
sqlMapClient.commitTransaction();

Underlying connection object's commit() method is NOT called if
commitRequired property is set to false (it would get called if it were
insert/update etc.), and vice versa - connection.commit() IS called if
commitRequired = true. Setting commitRequired =false saves extra commit
calls when no data has changed.

Mime
View raw message