Hi everyone. I'm trying to understand why load balancing doesn't work with the
PostgreSQL JDBC driver, and what (if anything) can be done about it. I have to
admit, I find the documentation a bit confusing. Here is what it currently
says at http://pgpool.projects.postgresql.org/pgpool-II/doc/
On Wed, 20 Jul 2011 11:58:45 -0400
Matt Solnit wrote:
> Hi everyone. I'm trying to understand why load balancing doesn't work with
> the PostgreSQL JDBC driver, and what (if anything) can be done about it. I
> have to admit, I find the documentation a bit confusing. Here is what it
> curren
Op 21-07-11 08:16, Toshihiro Kitagawa schreef:
On Wed, 20 Jul 2011 11:58:45 -0400
Matt Solnit wrote:
Hi everyone. I'm trying to understand why load balancing doesn't work with the
PostgreSQL JDBC driver, and what (if anything) can be done about it. I have to
admit, I find the documentation
On Thu, 2011-07-21 at 10:41 +0200, David Hartveld wrote:
> Op 21-07-11 08:16, Toshihiro Kitagawa schreef:
> > On Wed, 20 Jul 2011 11:58:45 -0400
> > Matt Solnit wrote:
> >
> >> Hi everyone. I'm trying to understand why load balancing doesn't work
> >> with the PostgreSQL JDBC driver, and what (i
On Jul 20, 2011, at 11:16 PM, Toshihiro Kitagawa wrote:
> On Wed, 20 Jul 2011 11:58:45 -0400
> Matt Solnit wrote:
>
>> Hi everyone. I'm trying to understand why load balancing doesn't work with
>> the PostgreSQL JDBC driver, and what (if anything) can be done about it. I
>> have to admit, I
On Jul 21, 2011, at 11:04 PM, Matthew Solnit wrote:
> On Jul 20, 2011, at 11:16 PM, Toshihiro Kitagawa wrote:
>
>> On Wed, 20 Jul 2011 11:58:45 -0400
>> Matt Solnit wrote:
>>
>>> Hi everyone. I'm trying to understand why load balancing doesn't work with
>>> the PostgreSQL JDBC driver, and wha
> Found the problem. It's in the PostgreSQL "valid connection checker" class
> provided by JBoss. A typical JBoss data source configuration file for
> PostgreSQL
> includes the following XML:
>
>
> org.jboss.resource.adapter.jdbc.vendor.PostgreSQLValidConnectionChecker
>
> The source cod
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
On Jul 28, 2011, at 1:39 AM, "Toshihiro Kitagawa"
mailto:kitag...@sraoss.co.jp>> wrote:
Hi,
The source code for the PostgreSQLValidConnectionChecker class includes the
following validity check:
try
{
stmt = cn.createStatement();
stmt.execute("");
}
// etc..