From: | Antony Paul <antonypaul24(at)gmail(dot)com> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | Silvio Bierman <sbierman(at)jambo-software(dot)com>, PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: FW: PreparedStatement#setString on non-string parameters |
Date: | 2005-03-09 03:58:40 |
Message-ID: | 2989532e05030819582e7c8d0a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Does this new stuff added in 8.0 driver adds to performance ?. I had
this setString() problem and I tested 7.4.x driver which works and
performs better than 8.0 driver.
On Wed, 09 Mar 2005 10:47:34 +1300, Oliver Jowett <oliver(at)opencloud(dot)com> wrote:
> Silvio Bierman wrote:
>
> > Either the JDBC drivers for the databases I mentioned earlier do the
> > conversion or the database backends do it on the server side. Any way, this
> > works in all cases. PostgreSQL is the first database to break our
> > application due to this behaviour. We have had problems on earlier versions
> > of MySQL because of lack of subselect support etc. but never these issues.
>
> I'd suggest using CAST in your SQL -- that in theory should work
> everywhere and reflects your application's intent (to interpret a string
> as a numeric value).
>
> The problem with reverting to the old way of doing parameters (direct
> text substitution into the query) is that we cannot take advantage of
> most of the new stuff in the V3 protocol -- that means no server-side
> prepared statement reuse, no low-overhead transfer of large parameters,
> and reduced support for cursor-based resultsets.
>
> -O
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
--
rgds
Antony Paul
http://www.geocities.com/antonypaul24/
From | Date | Subject | |
---|---|---|---|
Next Message | Silvio Bierman | 2005-03-09 09:08:10 | Re: FW: PreparedStatement#setString on non-string parameters |
Previous Message | Lennie De Villiers | 2005-03-08 21:51:21 | PostGreSQL Date Query? |