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

Re: [JDBC] number of transactions doubling

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: "Oliver Jowett" <oliver(at)opencloud(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 22:52:15
Message-ID: 6992E470F12A444BB787B5C937B9D4DF060E5B05@ca-mail1.cis.local (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbc
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).

I had the following 2 lines in my postgres-ds.xml which I commented

<!--
<new-connection-sql>select 1</new-connection-sql>
-->
<!--
<check-valid-connection-sql>select 1</check-valid-connection-sql>
-->

Even after this, I am seeing twice the number of transactions.

-----Original Message-----
From: Oliver Jowett [mailto:oliver(at)opencloud(dot)com] 
Sent: Thursday, September 28, 2006 3:24 PM
To: Sriram Dandapani
Cc: pgsql-jdbc(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
Subject: Re: [JDBC] number of transactions doubling

Sriram Dandapani wrote:

> The target table has triggers that route data to appropriate tables.
The 
> tables to which data is routed has check constraints that do further 
> inserts. (All of this happens in 1 jdbc transaction)
> 
> I expect  JDBC Batching to generate fewer transactions depending on 
> batch size.

Have you turned autocommit off?

-O

Responses

pgsql-admin by date

Next:From: Sriram DandapaniDate: 2006-09-28 23:03:38
Subject: Re: [JDBC] number of transactions doubling
Previous:From: Oliver JowettDate: 2006-09-28 22:24:28
Subject: Re: [JDBC] number of transactions doubling

pgsql-jdbc by date

Next:From: Sriram DandapaniDate: 2006-09-28 23:03:38
Subject: Re: [JDBC] number of transactions doubling
Previous:From: Oliver JowettDate: 2006-09-28 22:24:28
Subject: Re: [JDBC] number of transactions doubling

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