[Pgpool-general] load balancing and autocommit?

[Daniel.Crespo at l-3com.com]

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: pgpool-general-bounces at pgfoundry.org [mailto:pgpool-general-
> bounces at pgfoundry.org] On Behalf Of Kevin Kempter
> Sent: Tuesday, December 01, 2009 4:26 PM
> To: pgpool-general at pgfoundry.org
> 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
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general