I'm not familiar with JDBC, but I think it should be setable. I googled it and below seems to be the answer.
Connection connection = dataSource.getConnection(); Connection.setAutoCommit(false); // Disables auto-commit. Taken from (http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/ rzaha/transaut.htm) Regards, Daniel > -----Original Message----- > From: [email protected] [mailto:pgpool-general- > [email protected]] On Behalf Of Kevin Kempter > Sent: Tuesday, December 01, 2009 4:26 PM > To: [email protected] > Subject: [Pgpool-general] load balancing and autocommit? > > > > Hi all; > > I have a client using JDBC, we want to use PG POOL II for connection > pooling, > master-slave mode (with SLONY on the db servers) and load balancing > (send all > of our reads to the SLONY slave. However we do NOT wish to use JDBC > autocommit > since that will break our ability to rollback a block of work. > > I'll have a look at the code, in the meanwhile does > anyone know of any work-arounds / have any ideas? > > > Thanks in advance > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
