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.