Re: Problems with protocol V3 after migration to latest driver

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