When in transaction and SQL statement fails the subsequent SQL statements within that transaction are still processed. This can result in data inconsistency.

Solution: for every execute and select statement if inside a failed transaction return without doing anything.