Re: Problems with protocol V3 after migration to latest driver - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Problems with protocol V3 after migration to latest driver
Date
Msg-id Pine.BSO.4.56.0410261220100.24411@leary.csoft.net
Whole thread Raw
In response to Re: Problems with protocol V3 after migration to latest driver  ("Alexey Yudichev" <Alexey@francoudi.com>)
List pgsql-jdbc

On Tue, 26 Oct 2004, Alexey Yudichev wrote:

> Works perfectly now, thanks.  I have also run the full test suite of my
> largest project with these new drivers and V3 and 7.4.5 server and it
> showed no problems. So the planner problem is the only one that remains
> with V3, is there a way to figure it out or 8.0 server is the only
> solution? Is V3 protocol support in 7.4 server considered experimental
> or is it an issue of JDBC drivers?

An 8.0 server is the only solution.  The V3 protocol was designed around
prepared statements, but in JDBC the use of PreparedStatement isn't always
for a true server prepared statements, it is often used just for
portability/parameter usage.  The 8.0 driver revealed this issue and a
solution was put into the 8.0 server, but is not suitable for backpatching
to 7.4.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: boolean and void CallableStatement return types
Next
From: Kris Jurka
Date:
Subject: Re: Problems with protocol V3 after migration to latest driver