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