[Pgpool-general] JDBC Query Not Working in Parallel Mode
kitagawa at sraoss.co.jp
Mon Jun 6 02:38:38 UTC 2011
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
SRA OSS, Inc. Japan
More information about the Pgpool-general