New to ibatis, searched the archives on this but couldn't find the answer. I would like to use the SqlMapClient startTransaction(), commitTransaction(), endTransaction() methods. From the documentation, I am assuming you can do something as simple as this in your code and have transaction support:
sqlMap.startTransaction(); // code to insert into table1 // code to update table2 // code to delete from table3 sqlMap.commitTransaction(); This seems simple and if it works, I believe it should satisfy our requirement. Can someone explain to me how I need to setup my SqlMapConfig.xml to use these calls? Up to now, we have only done single calls and use autocommit. We are using MySQL but not Spring or Hibernate, only ibatis for now. Any assistance would be appreciated. Thanks.