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

[Bryan Varner]

>>     Caused by: org.postgresql.util.PSQLException: ERROR: prepared
>>     statement "S_18" does not exist
>
> I guess this problem is a known bug which was fixed in 3.1.
>
>    - Fix bug which cannot use the cursors of JDBC driver on standby
>      node. The transaction commands come to be sent to all nodes by
>      this fix in master/slave mode(Kitagawa)
>
> Does the error occur in 3.1?

Yes, it does occur in 3.1 -- that's the version I'm currently evaluating 
/ testing.

> 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?

Regards,
-Bryan