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

Re: [JDBC] number of transactions doubling

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Sriram Dandapani <sdandapani(at)counterpane(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [JDBC] number of transactions doubling
Date: 2006-09-28 23:13:41
Message-ID: 451C5725.4070905@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbc
Sriram Dandapani wrote:
> Autocommit is set to off once a connection is obtained from the jboss
> pool. It is turned back on when it is closed (so that any idle
> transactions are committed).

Don't know what to suggest then -- if autocommit is off then the JDBC 
driver should be sending BEGIN before the first query & COMMIT or 
ROLLBACK when you explicitly delimit a transaction. There's nothing 
special about batches.

You could set loglevel=2 as a JDBC URL parameter to see exactly what the 
JDBC driver is sending, perhaps. Or turn on logging on the server side, 
though I'm not sure at exactly which server version the logging of the 
extended query protocol became useful.

-O

In response to

pgsql-admin by date

Next:From: Jim C. NasbyDate: 2006-09-29 00:40:42
Subject: Re: transaction id wraparound
Previous:From: Sriram DandapaniDate: 2006-09-28 23:03:38
Subject: Re: [JDBC] number of transactions doubling

pgsql-jdbc by date

Next:From: Jim C. NasbyDate: 2006-09-29 00:47:36
Subject: Re: number of transactions doubling
Previous:From: Sriram DandapaniDate: 2006-09-28 23:03:38
Subject: Re: [JDBC] number of transactions doubling

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