Skip site navigation (1) Skip section navigation (2)

Re: Can PostgreSQL do data type automated casting in prepared

From: Tjioe Ai Xin <xinxincute(at)gmail(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Can PostgreSQL do data type automated casting in prepared
Date: 2005-11-23 12:05:52
Message-ID: 200511231905.53085.xinxincute@gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Dear Kris,

Where I can set protocolVersion=2?
And how about the performance?

Thanks in advance.
Xin Xin

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 
> you.
> 
> Kris Jurka
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

In response to

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2005-11-23 13:13:15
Subject: Re: Can PostgreSQL do data type automated casting in prepared
Previous:From: Oliver JowettDate: 2005-11-23 11:31:54
Subject: Re: Reg : Exception ( Postgresql with Java -JDBC)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group