[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] pooling connections

From: Horst Herb
Subject: Re: [Gnumed-devel] pooling connections
Date: Mon, 2 Sep 2002 08:09:38 +1000
User-agent: KMail/1.4.6

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? 


reply via email to

[Prev in Thread] Current Thread [Next in Thread]