how to handle transaction failure when writing to multiple databases
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Anonymous
Posted On:   Sunday, August 28, 2011 10:41 AM

Hi Gurus, I recently encountered a question from somebody. While a java program is writing to two different databases in same method. We usually set the auto commit to false to both the connections and issue commit to both the connections after successive execution of sequential operations on each database. Question is what if there was a failure while issuing commit in one database or a db server goes offline? Anybody please let me know what is the best way to handle this scenario. Thanks in advance, Purna    More>>

Hi Gurus,



I recently encountered a question from somebody.



While a java program is writing to two different databases in same method. We usually set the auto commit to false to both the connections and issue commit to both the connections after successive execution of sequential operations on each database.



Question is what if there was a failure while issuing commit in one database or a db server goes offline?



Anybody please let me know what is the best way to handle this scenario.



Thanks in advance,

Purna


   <<Less
About | Sitemap | Contact