Re: [Gnumed-devel] pooling connections

[Horst Herb]

On Sun, 1 Sep 2002 09:33 pm, Julio Jiménez wrote:

> It's true.. "commits" are at connections levels. But I think you musn't
> have 20 connections for it. you
> must issolate and serialize the transactions (don execute cursors for
> insert, update... until really need to be upgraded, then apply
> connection.commit()) this is the way i usually use.

Let us assume you have the processes A and B.
Both request a connection C, and get the same connection.
A begins a long transaction, B a short one.
B commit fails, rollback is triggered.
If A and B share the same connection, *both* transactions would be rolled 
back, wouldn't they? 

Horst