Re: PreparedStatement#setString on non-string parameters - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: PreparedStatement#setString on non-string parameters
Date
Msg-id 422D9B80.6080306@fastcrypt.com
Whole thread Raw
In response to PreparedStatement#setString on non-string parameters  ("Silvio Bierman" <sbierman@jambo-software.com>)
Responses Re: PreparedStatement#setString on non-string parameters
List pgsql-jdbc
Silvio,

I presume you are talking about setObject ??? I can't find a
setString(non-string param)

Dave

Silvio Bierman wrote:

>Hello all,
>
>I have just finished a few hours of testing our product that already runs on
>Oracle, SQLServer, MySQL, MaxDB and McKOI on PostgreSQL. I always liked what
>I read about this database apart from the fact that it used to not run
>natively on Windows. Since many of our customers run Windows servers I never
>bothered with PostgreSQL before.
>
>However, starting with version 8 there is a native Windows version which I
>installed and ran our product on. At first everything was fine and I was
>very impressed with both the performance as the ease of use of the admin
>tools.
>
>But when I starting doing writes to the database SQL exceptions started to
>occur. They where all over the application code but where all the same
>error: doing a setString on a numeric parameter. I know this is usually
>suboptimal but since we handle a lot of XML data throughout the (heavily
>distributed) application many numeric values are available as Strings so it
>would be a matter of converting them to numeric values ourselves or letting
>the JDBC driver do that.
>
>The JDBC drivers we used for the other databasse I mentioned never
>complained. Unfortunately PostgreSQL does. I read somewhere that using the
>pre-version-8 JDBC driver will work with 8 and not show this behaviour, the
>8 driver has deliberately changed the behaviour.
>
>The JDBC spec requires the driver to attempt a conversion when a
>setString is done on a non-string parameter. This will break a lot of
>conformant code, not only ours. Is there any chance this can be corrected?
>
>Regards,
>
>Silvio Bierman
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561


pgsql-jdbc by date:

Previous
From: "Silvio Bierman"
Date:
Subject: PreparedStatement#setString on non-string parameters
Next
From: Guillaume Cottenceau
Date:
Subject: Re: PreparedStatement#setString on non-string parameters