Action-sets question

[Lionel Crine <cr...@4dconcept.fr>]

Hi,

I have some actions which make some modification (update, commit or 
rollback) in my SQL database.

My trouble is that if the update failed I need to do a rollback. But if 
another user uses the table in which I am making modification, he will 
loses his changes if I make a rollback.
So there is a critical section.

Does an action-sets is a solution to avoid this problem ?

Another solution is to make a big action but  this is not so clean.

Thanks
Lionel





-- 
Lionel CRINE
Ingénieur Systèmes documentaires
Société : 4DConcept
22 rue Etienne de Jouy 78353 JOUY EN JOSAS
Tel : 01.34.58.70.70 Fax : 01.39.46.06.90

Re: Action-sets question

[Antonio Gallardo <ag...@agssa.net>]

On Vie, 11 de Febrero de 2005, 4:41, Lionel Crine dijo:
> Hi,
>
> I have some actions which make some modification (update, commit or
> rollback) in my SQL database.
>
> My trouble is that if the update failed I need to do a rollback. But if
> another user uses the table in which I am making modification, he will
> loses his changes if I make a rollback.

I think this is not the case. If in a DB session you do a rollback it only
affect the specific DB session. The other DB sessions are not rolled back
at all.

> So there is a critical section.
>
> Does an action-sets is a solution to avoid this problem ?
>
> Another solution is to make a big action but  this is not so clean.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org