since you are using transaction, you should put this in a try catch block po and rollback the transaction upon failure. 
but in this case, i think that using transactions can be disregarded since its just a single query po.