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 »

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.

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

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

Post by admin »

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 »

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: 197
Joined: Mon Jun 20, 2016 5:06 pm
Contact:

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

Post by johnlong »

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?

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

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

Post by admin »

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: 197
Joined: Mon Jun 20, 2016 5:06 pm
Contact:

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

Post by johnlong »

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

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

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

Post by admin »

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: 197
Joined: Mon Jun 20, 2016 5:06 pm
Contact:

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

Post by johnlong »

Thank you for your reply. Everything is clear.

Post Reply

Who is online

Users browsing this forum: No registered users and 27 guests