Hi,
the autocommit is handled on the database side. Depending on the database at hand, the table where the insert is done, is locked, such that queries on this table are queued until the insert is either commited or rolled back. So, yes, you have to commit/rollback (although usually the rollback is done automatically after some timeout).
Usually you use autocommit=off to be sure about having multiple inserts done "simultaenously", i.e. do some insert statements after each other. If all go well, commit, if one of them fails, rollback (all) of them.
Titus
