Rollbacking of the Data to Database

, ,
1

Hi,

  1. How do we Rollback the data to the database when jdbc adapter is disconnected to the due to some unknown reasons.

  2. Also if there are 2 or more errors in the flatfile table, when we send the data from FlatFile To Database, it should show all the errors simultaneously while rollbacking the data.

2
  1. To rollback the transaction explicitly you we will have to either use local or XA transaction in your JDBC connection. Their are many post which talks about this. In brief you will have to follow somthing like

pub.art.transaction:startTransaction

main{
try{
BatchInsertAdapterService
pub.art.transaction:commitTransaction
}
Catch{

pub.art.transaction:rollbackTransaction

}

2) What you mean by flat file table ?