[Pgpool-general] Is pgpool compatible with protocolVersion=3 of jdbc?

[Tatsuo Ishii]

> Is there any significant difference in using pg connection string
> "protocolVersion=2"?
> 
> By default pg driver uses protocol V3, this causes the temp table creation
> from application to fail.

What error do you have with temp table creation?

> If we change the connection string to
> "protocolVersion=2" everything works fine
> 
> eg: Connection c =
> DriverManager.getConnection("jdbc:postgresql://db_host:db_port/reporting?protocolVersion=2","car",
> "");
> 
> Is there any negative impact of using protocolversion 2.

Yes. Protocolversion 2 is inefficient comparing with 3. Also you will
lose some important features those are available with only 3. For
example, load balance, insert lock etc.
--
Tatsuo Ishii
SRA OSS, Inc. Japan