Suppose you have block of sql statements which contains only one insert or update statement , rest are just queries. Like the following

try {

query1
query2
query3
insert
} catch ( exception e ) {

}


Is the rollback needed in case there is exception ? I can not think of a scenario where it is need. Can anybody think of a scenario where database integrity will be compromised or unexpected result will occur if you do not do rollback when exception occurs...