Question
How can a transaction be retried after an exception?
Answers
The following method can be used to retry a transaction after an exception is raised:

The transaction should be written within a sub-block
The sub-block can be placed inside a loop that repeats the transaction.
Mark a savepoint before starting the transaction. If the transaction succeeds, then commit and exit from the loop. If the transaction fails, the control is transferred to the exception handler where the transaction is rolled back to the savepoint to undo the changes, and then try to fix the problem.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q Give the classification of Crab in animal kingdom?
  • Q Narton is a mixture of baking soda and salt what was it used for
  • Q What is the function of vitamin?
  • Q Explain why it is necessary to develop non-conventional method of generating electrical energy.
  • Q How would Ashmans phenomenon be described?
  • Q What does it mean for a message to be?
  • Q What is the purpose of the cash flow statement?
  • Q What company first guaranteed satisfaction or your money back
  • Q Smallest Taluk in Kerala:
  • Q there are two merchants in france one is carrying 200 barrels of wine and other 120 first one paid 40 franc and 5 barrel of wine, as a charge other paid 2 barrel of wine and received 40 franc in return what is charge of barrel and what is the tax on barrel
  • Q On which river is the German town of Wittenburg?