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

Re: Can PostgreSQL do data type automated casting in prepared

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tjioe Ai Xin <xinxincute(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Can PostgreSQL do data type automated casting in prepared
Date: 2005-11-21 23:08:47
Message-ID: Pine.BSO.4.61.0511211806430.23994@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

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


In response to

Responses

pgsql-jdbc by date

Next:From: Benjamin StookeyDate: 2005-11-21 23:27:27
Subject: Deploying my application (nesting the jar)
Previous:From: Kris JurkaDate: 2005-11-21 23:06:37
Subject: Re: Deadlock problem

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