[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