About Question enthuware.oce-ejbd.v6.2.620 :

Moderator: admin

Post Reply
PMiglani
Posts: 14
Joined: Sat Jan 19, 2013 8:42 am
Contact:

About Question enthuware.oce-ejbd.v6.2.620 :

Post by PMiglani » Sat Dec 07, 2013 3:03 pm

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.

Online
admin
Site Admin
Posts: 8296
Joined: Fri Sep 10, 2010 9:26 pm
Contact:

Re: About Question enthuware.oce-ejbd.v6.2.620 :

Post by admin » Mon Dec 09, 2013 12:47 am

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.

himaiMinh
Posts: 358
Joined: Fri Nov 29, 2013 8:26 pm
Contact:

Re: About Question enthuware.oce-ejbd.v6.2.620 :

Post by himaiMinh » Sat May 23, 2015 10:20 pm

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.

johnlong
Posts: 185
Joined: Mon Jun 20, 2016 5:06 pm
Contact:

Re: About Question enthuware.oce-ejbd.v6.2.620 :

Post by johnlong » Thu Jun 01, 2017 1:11 pm

If the Active Directory update fails..
This mean that Active Directory could (theoretically) be in inconsistent state (partially updated) ?
If yes, is this indeed good solution?

Online
admin
Site Admin
Posts: 8296
Joined: Fri Sep 10, 2010 9:26 pm
Contact:

Re: About Question enthuware.oce-ejbd.v6.2.620 :

Post by admin » Thu Jun 01, 2017 10:24 pm

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.

johnlong
Posts: 185
Joined: Mon Jun 20, 2016 5:06 pm
Contact:

Re: About Question enthuware.oce-ejbd.v6.2.620 :

Post by johnlong » Fri Jun 02, 2017 9:55 am

I am not saying it be definitely be the case, but there is a possibility.
For example, AD server went down during update.

Online
admin
Site Admin
Posts: 8296
Joined: Fri Sep 10, 2010 9:26 pm
Contact:

Re: About Question enthuware.oce-ejbd.v6.2.620 :

Post by admin » Fri Jun 02, 2017 10:07 am

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.

johnlong
Posts: 185
Joined: Mon Jun 20, 2016 5:06 pm
Contact:

Re: About Question enthuware.oce-ejbd.v6.2.620 :

Post by johnlong » Fri Jun 02, 2017 10:11 pm

Thank you for your reply. Everything is clear.

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests