X++ transation

(0) Share

Report

Posted on by Tracy wang

113

hello,guys .if in a class ,The transaction has just been committed,next then the Excepction occur in,The previous transaction will still roll-back? as shownbelow, when program walking to int a=1/0,Excepection occured.

I have the same question (0)

All responses (18)

Answers (2)

Tracy wang 113 on at

Like (0)

Report

Because I have no environment test, if not rollback, what can be done

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

No the transaction will commit. It won't roll back. But why are you trying to divide a number by 0? It will surely cause exception. Can you tell the exact requirement?

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Also what is the exception you are getting?

Was this reply helpful? Yes No
Tracy wang 113 on at

Like (0)

Report

for example, i use odata calling other people's interface, and commit my transation,but when walking other people's service ,it occured excepction.it should be roll-back,isn't it?

Was this reply helpful? Yes No
Tracy wang 113 on at

Like (0)

Report

I'm just giving you an example, if i change int a=1/0 to try catch, it will be rollback?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,807 Most Valuable Professional on at

Like (1)

Report

The transaction is already committed at line 6, therefore your code at line 7 has no impact on it.

If you want the exeption to rollback the transaction, put your logic inside the transaction.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (1)

Report

Once a transaction means code between ttsbegin and commit is run successfully without error and if you get an error as suggested above then the saved transaction or record won't roll back or delete as transaction is committed. If the error comes before ttscommit due to any validation or something then record won't even save at all. So there is no transaction roll back concept from my knowledge. Either transaction won't happen or will happen that's it.

Hope you understood.

If you want to play around the code you can make the said changes in your code and try.

Was this reply helpful? Yes No
Martin Dráb 237,807 Most Valuable Professional on at

Like (1)

Report

A transaction rollback means undoing changes already done (such as reverting updated records) so you can reach the state as if nothing happened.

Details of how it's actually implemented by SQL Server / Azure SQL are quite complicated, but we don't need to worry about them.

Was this reply helpful? Yes No
Tracy wang 113 on at

Like (0)

Report
What you mean is that a transaction must cover any code that might have an exception?
[quote user="Tracy wang"]
hello,guys .if in a class ,The transaction has just been committed,next then the Excepction occur in,The previous transaction will still roll-back? as shownbelow, when program walking to int a=1/0,Excepection occured.
[/quote]

Was this reply helpful? Yes No
Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

I don't know what is so difficult on it. An exception aborts a transaction only if it's thrown in a transaction. Your 'throw' statement isn't in a transaction and therefore there is no transaction it could influence.

If update() (line 5) threw an exception, the transaction would be rolled back, because update() *is* called inside a transaction.

Was this reply helpful? Yes No