About Question enthuware.oce-ejbd.v6.2.620 :
Moderator: admin
-
- Posts: 14
- Joined: Sat Jan 19, 2013 8:42 am
- Contact:
About Question enthuware.oce-ejbd.v6.2.620 :
Hi, I have a doubt...
Will Runtime Exception cause the database Rollback or not in this case. i.e. if we change the Seq of updates in Option 1 and 2 will that work? Please explain.
Will Runtime Exception cause the database Rollback or not in this case. i.e. if we change the Seq of updates in Option 1 and 2 will that work? Please explain.
-
- Site Admin
- Posts: 10113
- Joined: Fri Sep 10, 2010 9:26 pm
- Contact:
Re: About Question enthuware.oce-ejbd.v6.2.620 :
A runtime exception (assuming that it is not marked as ApplicationException), will cause a transaction to be marked for rollback.
If you like our products and services, please help us by posting your review here.
-
- Posts: 358
- Joined: Fri Nov 29, 2013 8:26 pm
- Contact:
Re: About Question enthuware.oce-ejbd.v6.2.620 :
Since the question does not mention the RuntimeException is an application exception or system exception, I would eliminate the first three options.
The last two options specify that there will be a system exception thrown if the database update fails.
That leads me to choose the last two options.
The last two options specify that there will be a system exception thrown if the database update fails.
That leads me to choose the last two options.
-
- Posts: 197
- Joined: Mon Jun 20, 2016 5:06 pm
- Contact:
Re: About Question enthuware.oce-ejbd.v6.2.620 :
This mean that Active Directory could (theoretically) be in inconsistent state (partially updated) ?If the Active Directory update fails..
If yes, is this indeed good solution?
-
- Site Admin
- Posts: 10113
- Joined: Fri Sep 10, 2010 9:26 pm
- Contact:
Re: About Question enthuware.oce-ejbd.v6.2.620 :
No, why do you think so? The update may also fail because the server is down, data violates some business rule, security, or any such reason. That doesn't mean the data is inconsistent.
If you like our products and services, please help us by posting your review here.
-
- Posts: 197
- Joined: Mon Jun 20, 2016 5:06 pm
- Contact:
Re: About Question enthuware.oce-ejbd.v6.2.620 :
I am not saying it be definitely be the case, but there is a possibility.
For example, AD server went down during update.
For example, AD server went down during update.
-
- Site Admin
- Posts: 10113
- Joined: Fri Sep 10, 2010 9:26 pm
- Contact:
Re: About Question enthuware.oce-ejbd.v6.2.620 :
Yes, there is always a possibility of inconsistent data no matter what you do. You can only minimize it but cannot eliminate it. Even two phase commit is not 100% correct. Such data is fixed manually based on business rules. So I am not sure what is your point.
If you like our products and services, please help us by posting your review here.
-
- Posts: 197
- Joined: Mon Jun 20, 2016 5:06 pm
- Contact:
Re: About Question enthuware.oce-ejbd.v6.2.620 :
Thank you for your reply. Everything is clear.
Who is online
Users browsing this forum: Google [Bot] and 15 guests