Skip site navigation (1) Skip section navigation (2)

Re: confused about transactions and connection pools

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kris Jurka <books(at)ejurka(dot)com>, David Goodenough <david(dot)goodenough(at)btconnect(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: confused about transactions and connection pools
Date: 2006-10-31 11:54:16
Message-ID: 45473968.1050703@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Tom Lane wrote:
> I'm a bit
> dubious that the prepared-statement machinery actually results in a win
> compared to just issuing simple Query messages.

The driver has no infrastructure for issuing simple Query messages in v3 
mode, and anyway we want to batch the BEGIN up with the query that 
follows it.

COMMIT/ROLLBACK might be of dubious value but I don't know if it's worth 
having a completely separate code path in the driver just for that one case.

-O

In response to

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2006-10-31 11:55:22
Subject: Re: confused about transactions and connection pools
Previous:From: Tom ArthursDate: 2006-10-31 10:45:00
Subject: Re: Date time format out of range????

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group