FYI..I use the postgres8.1.404 jdbc driver -----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
