Hi, On Fri, 03 Jun 2011 08:10:16 -0700 Vincent Sheffer <[email protected]> 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 <[email protected]> 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 > >> [email protected] > >> http://pgfoundry.org/mailman/listinfo/pgpool-general > >> > > > > -- > > Toshihiro Kitagawa > > SRA OSS, Inc. Japan > > > -- Toshihiro Kitagawa SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
