Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: 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: number of transactions doubling
- Date: Thu, 28 Sep 2006 23:13:41 +0000
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
- References:
- Re: number of transactions doubling
- From: Sriram Dandapani
- Re: number of transactions doubling
- Prev by Date: Re: number of transactions doubling
- Next by Date: Re: [ADMIN] number of transactions doubling
- Previous by thread: Re: number of transactions doubling
- Next by thread: Re: number of transactions doubling
- Indexes: