[Pgpool-general] Trouble with the JDBC drivers...

[Toshihiro Kitagawa]

On Fri, 21 Oct 2011 10:09:54 -0400
Bryan Varner <bvarner at polarislabs.com> wrote:

> >> If the error is caused by the bug, it should be solved by
> >> setting load_balance_mode to off.
> >
> > One of the main drivers for us to use pgpool is to distribute the load
> > for read transactions across our database nodes. If I turn off
> > load_balance, doesn't pgpool stop sending selects to standby nodes?
> 
> Turning off load_balance mode certainly did make things work better, but 
> without load-balancing selects to the standby nodes, the only real value 
> I get from pgpool is failover & promotion in master_slave, which I 
> already have implemented using other means.
> 
> If I could get master_slave && load_balance working with the JDBC 
> drivers, this would be an incredible tool to have.
> 
> Has anyone put much thought into if this is even feasible? Is there 
> anyone working on this? What can I do to help?

Is autocommit setting of your application true?
If so, can you set autocommit to false by using setAutoCommit(false)?

-- 
Toshihiro Kitagawa
SRA OSS, Inc. Japan