On Jul 28, 2011, at 1:39 AM, "Toshihiro Kitagawa" 
<[email protected]<mailto:[email protected]>> 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
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to