[Pgpool-general] Confused about JDBC and load balancing

[Matt Solnit]

On Jul 28, 2011, at 1:39 AM, "Toshihiro Kitagawa" <kitagawa at sraoss.co.jp<mailto:kitagawa at sraoss.co.jp>> wrote:

Hi,

The source code for the PostgreSQLValidConnectionChecker class includes the following validity check:

     try
     {
        stmt = cn.createStatement();
        stmt.execute("");
     }
     // etc..

This empty-string query is exactly what's causing the problem.  When I disable the connection checker by commenting out the XML element shown above, everything works correctly.

I committed the patch to avoid this problem.
Load balancing will work correctly with next releases(3.0.5, 3.1.0)
even if JBoss sends empty-queries.

--
Toshihiro Kitagawa
SRA OSS, Inc. Japan

Thank you very much!

-- Matt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110728/46229db5/attachment.html>