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@opencloud.com]
Sent: Thursday, September 28, 2006 3:24 PM
To: Sriram Dandapani
Cc: pgsql-jdbc@postgresql.org; pgsql-admin@postgresql.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
