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

Re: Can PostgreSQL do data type automated casting in prepared

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Tjioe Ai Xin <xinxincute(at)gmail(dot)com>
Cc: Kris Jurka <books(at)ejurka(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Can PostgreSQL do data type automated casting in prepared
Date: 2005-11-23 13:13:15
Message-ID: 1D9D2DAF-EA25-4129-A188-84DAEAD94D4B@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Please see the following for all the connection parameters.

http://jdbc.postgresql.org/documentation/head/connect.html#connection- 
parameters

Dave
On 23-Nov-05, at 7:05 AM, Tjioe Ai Xin wrote:

> 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
>>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>


In response to

pgsql-jdbc by date

Next:From: Rob KirkbrideDate: 2005-11-23 13:24:37
Subject: Re: Switching user within connection.
Previous:From: Tjioe Ai XinDate: 2005-11-23 12:05:52
Subject: Re: Can PostgreSQL do data type automated casting in prepared

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