From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | DBI driver and transactions |
Date: | 2003-02-03 02:18:11 |
Message-ID: | Pine.LNX.4.21.0302030155580.20150-100000@ponder.fairway2k.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
I'm getting very odd behaviour and am getting quite frustrated at fighting this
thing. So just so I know for the future does anyone know if there are problems
with using transactions when using cached dbi handles?
I was using my own caching of the handle(s) but I didn't have time to work out
who, what, why and where someone was disconnecting it so switched to the DBI
caching connect. Note, this is NOT persistent/pooled connections.
However, either there is something wrong (and it's been fixed since I loaded
the software) or I completely fail to grasp the concept of transactions as
understood by DBI.
With AutoCommit => 0 I see a BEGIN logged right before the
first query I send...
Oh I give up. Trying to clarify what happens when I'm now seeing rollbacks
issued in AutoCommit => mode where I'm not doing any and it's certainly not me
since I've got a trap on my interface layer to DBI for that and it's not been
tripped at all.
So,
a) anyone know of any problems,
b) can I assume it is me and not just give up on this DBI stuff in the future (
I haven't got the time to rewrite my application now; not that I can't see it
being a particularly onerous task for what I use from DBI )
c) can I just issue BEGIN, COMMIT, ROLLBACK when I want to via normal
$dbh->do(...) without causing myself even more problems?
and
d) I've said it before but what's the point of DBI if it's not to make life
easier?
This on a linux debian potato with:
Pg 7.2.3
Perl 5.8.0
DBI 1.30
DBD::Pg 1.13
--
Nigel J. Andrews
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2003-02-03 03:11:36 | Re: Query plan question, and a memory leak |
Previous Message | Alan Gutierrez | 2003-02-03 01:09:18 | Re: History |
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Lee | 2003-02-03 02:35:55 | Re: where is the libpq++ ?? |
Previous Message | Ben Borger | 2003-02-01 00:47:20 | Apache child processes making multiple persistent database connections via Apache::DBI |