hi all ,
while getting data from oracle database by using adapter templates ,if database was down means will the data loss or exist? if exists where is stored.

pls anybody reply me for my query

If it is a select query, once the ‘select adapter template’ executes successfully, you will have the data in the pipeline. Doesn’t matter if ur db goes down after that.

If it is other adapter templates (update, delete, insert), this will be handled as transaction. While executing these db statements, if your db is down, transaction will fail. Data will remain as same in database unless commit/rollback executes.

-Senthil

Thank you so much…senthil