JDBC : Rollback
I am using JDBC as Receiver and my req is getting file(FTP) and (delete * from tables ) then (insert * into tables) using JDBC) /multiple tables.
Its like this.Part of data from file into one table and 2nd part into other table,but remember before inserting data from file to DB i have to delete all from DB.
My question is ...In this process,after deletion and before inserting if some thing happens do we have an option to rollback everything in DB.
Please let me know