[Pgpool-general] JDBC Query Not Working in Parallel Mode

Toshihiro Kitagawa kitagawa at sraoss.co.jp
Mon Jun 6 02:38:38 UTC 2011


Hi,

On Fri, 03 Jun 2011 08:10:16 -0700
Vincent Sheffer <vincent.sheffer at mac.com> wrote:

> This is what my manual says:
> 
> "The extended query protocol used by JDBC drivers, etc. is not supported. The simple query protocol must be used. This means you can't use prepared statements."
> 
The first sentence means you can't use JDBC drivers in parallel mode.
I think that the last sentence should be fixed or removed because it
is pretty misleading.

> I am not using prepared statements.
> 
> On Jun 2, 2011, at 7:18 PM, Toshihiro Kitagawa wrote:
> 
> > On Thu, 02 Jun 2011 11:27:18 -0700
> > Vincent Sheffer <vincent.sheffer at mac.com> wrote:
> > 
> >> Here are my particulars:
> >> 
> >> pgpool-II 3.0.3
> >> postgresql 9.0.4
> >> JDBC4 driver v9.0-801
> >> JDK 1.6 running on Ubuntu Linux
> >> 
> >> I've got pgpool-II configured in parallel mode and have partitioning rules set up via dist_def and systemdb.  I do a simple, non prepared statement, query in JDBC and get no results back.  The exact same query (that I copied and pasted from the pgpool-II debug log) run through psql returns the correct result set.
> > 
> > It's a restriction in parallel mode.
> > 
> > Excerpts from pgpool-II manual:
> > * Extended Query Protocol (for parallel mode)
> >  The extended query protocol used by JDBC drivers, etc. is not supported. 
> > 
> > JDBC drivers(except earlier ones) use the extended query protocol
> > regardless of prepared statement. On the one hand, the drivers using
> > libpq might use the extended query protocol if API for prepared
> > statement is called.
> > 
> >> 
> >> I am continuing to investigate on my end, but any help here would be greatly appreciated.
> >> 
> >> Thanks,
> >> Vince
> >> 
> >> _______________________________________________
> >> Pgpool-general mailing list
> >> Pgpool-general at pgfoundry.org
> >> http://pgfoundry.org/mailman/listinfo/pgpool-general
> >> 
> > 
> > -- 
> > Toshihiro Kitagawa
> > SRA OSS, Inc. Japan
> > 
> 


-- 
Toshihiro Kitagawa
SRA OSS, Inc. Japan




More information about the Pgpool-general mailing list