Any One care to respond .....JTA!_NEWLINE_!connecting to multiple databases..
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   venkatesh_y
Posted On:   Tuesday, September 4, 2001 11:45 PM


			

			
				I need to coomunicate t multiple databases
				

				

				withinin the single transaction context so one
				

				database is updated and the other is rolled back
				

				

				how to handle this situation
Report | Quote This | Send private message | Reply | Print

Re: Any One care to respond .....JTA!_NEWLINE_!connecting to multiple databases..

Posted By:   Bozidar_Dangubic  
Posted On:   Thursday, September 6, 2001 11:37 AM

transaction = all success or transaction = all fails. you cannot have something that commits and something that rollbacks in the same transaction. rememer ACID properties of the transaction. the answer to your question is in "A" of the ACID, Atomic. transaction is atomic and therefore it either commits or it fails.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact