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

Re: JDBC driver build 215 slow when index contains column

From: Roland Walter <rwa(at)mosaic-ag(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC driver build 215 slow when index contains column
Date: 2005-03-09 13:27:44
Message-ID: 422EF9D0.5090303@mosaic-ag.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Oliver Jowett schrieb:

> Roland Walter wrote:
>
>> I use PostgreSQL 7.4.6 and the JDBC-driver build 215. [...]
>
>
>> Have I to do a typecast to ::bigint with build 215 in the 
>> PreparedStatement
>> to get the same performance as with build 310?
>
>
> Against a 7.4.x server, yes.
>
>> That would be bad, as I had to
>> form the PreparedStatement incompatible to other databases.
>
>
> Why can't you use build 310? It's intended to work against 7.4.x 
> servers as well as 8.0.x.
>
Will use it now. 

I wanted to avoid finding the places in the application where setString 
is used for BIGINT values.

But im just doing that now.

-- 
Roland Walter
MOSAIC SOFTWARE AG
Telefon: 02225/882-411 Fax: 02225/882-201
http://www.mosaic-ag.com


In response to

pgsql-jdbc by date

Next:From: Mican BicanDate: 2005-03-09 15:54:40
Subject: java is locked when select for update
Previous:From: Oliver JowettDate: 2005-03-09 13:26:20
Subject: Re: FW: PreparedStatement#setString on non-string parameters

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