🚀 go-pugleaf

Hello friends ,

    Please help me to solve this problem ...

I have a method in which I have two or three insert or delete or update
statements. I want to rollback to the starting of the method if anything
goes wrong or any of these statements fail.

I tried using db.setautocommitt(false) at the beginning of the method
and

db.committ; and
db.setautocommitt(true) at the end of the method

and

db.rollback; and
db.setautocommitt(true) in case of any exception.

But, this happens to place an exclusive lock on the table we are
accessing and we are not able to access any of the rows in that table.
Is there a way of placing a shared lock? If so what should be specified?

Thanks in Advance,

Sankar S.