Where I can set protocolVersion=2?
And how about the performance?
Thanks in advance.
On Tuesday 22 November 2005 06:08, Kris Jurka wrote:
> On Mon, 21 Nov 2005, Tjioe Ai Xin wrote:
> > My code is like this: I have query: "Select count(*) / paramPage from
> > tblFirst where condition"; The paramPage were filled from parameter
> > which I specified as string data type. So I using setString method for
> > my prepared statement for passing paramPage value. When I'm using the
> > old jdbc driver pg74jdbc3.jar, I got no problem at all. But when I try
> > to upgrade my PostgreSQL to 8.0.3. I got problem data type error.
> > Can PostgreSQL do data type automated casting in prepared statement again?
> > So I do not need change my code :)
> Yes, and no. You can restore the old behavior by adding
> ?protocolVersion=2 to your connection URL, but using the older protocol
> also means some new features and performance gains will be unavailable to
> Kris Jurka
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
In response to
pgsql-jdbc by date
|Next:||From: Dave Cramer||Date: 2005-11-23 13:13:15|
|Subject: Re: Can PostgreSQL do data type automated casting in prepared|
|Previous:||From: Oliver Jowett||Date: 2005-11-23 11:31:54|
|Subject: Re: Reg : Exception ( Postgresql with Java -JDBC)|