Retain a particular value of a variable even when transaction fails

Question

1.00/5 (1 vote)

See more:

Say, I have a global int variable called JohnDoe = 0. I have a transaction which performs many actions, including updating my JohnDoe variable to 5. Now, when the transaction succeeds, all the values are committed and JohnDoe now becomes 5. But if my transaction fails, all the values are rolled back and JohnDoe becomes 0. Is there any way I can commit the value of this variable alone even if the transaction fails ? Even if the transaction fails, I want to retain the value of JohnDoe as 5, though all other actions should be rolled back ? Is there any way I can accomplish this ?

Posted 7-Jul-14 1:41am

Divakar Raj M

Add a Solution

Comments

johannesnestler 7-Jul-14 10:18am

from your question it sounds like the JohnDoe variable should not take part in the transaction at all. Maybe you can describe your requriment for this?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2014-07-07T01:47:00

No - when a roll-back occurs, it is intended to restore the original state of the DB so that it is left in a manageable condition. It can't leave some bits changed and some not, because it doesn't know what bits are important to you and which aren't.

The best you can do is change your variable outside the transaction, or nest transactions so that you can roll back the inner one independently of the outer.