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."
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 >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
