Commit and rollback with CI

[eluser]Relexx[/eluser]
I believe that CI uses PDO not mysql or mysqli, assuming that you are using Database class, so my guess you would need to use mysql or mysqli transaction interface instead if you are explicity using these.

Re: Auto Commit. The whole purpose of a transaction encapsulation is the ability to roll back a number of sql statements without having to undo an already committed transaction. Auto commit is ok when not performing sql in an encapsulated transaction. I would stick with the defaults. If you want to execute multiple inserts, updates, deletes, and if one fails rollback, encapsulate the statements with trans_start trans_complete.