ganeshk, you could have AutoCommit "ON" by default and for those transactions (before), turn it off and either "commit" or "rollback" the transaction. According to Apache::DBI's doc:

... However, because a connection may have set other parameters, the h
+andle is reset to its initial connection state before it is returned 
+for a second time.
[download]