Thanks for your reply.
Here columnType value is 3 and inputdata value is always string type.
-----Original Message-----
From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer
Sent: Tuesday, January 12, 2010 1:45 AM
To: Srinivas Gunnam
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Throwing NumberFormat exception for preparedStatement.setObjcet()
On Mon, Jan 11, 2010 at 7:58 AM, Srinivas Gunnam
<srinivas_gunnam@persistent.co.in> wrote:
> Hi,
>
> In our application we are using the Postgres Sql 8.3.3 and jdbc driver is
> postgresql-8.0-310.jdbc3.
Do you mean 8.0-310 ? if so why not use a more recent driver ?
>
>
>
> When I am trying to set the value for id(int) like as follows throwing
> exception.
>
> ps.setObject(1, inputData,columntype);
>
> where inputdate value is 2
what is the columnType value ?
Dave
DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is
intendedonly for the use of the individual or entity to which it is addressed. If you are not the intended recipient,
youare not authorized to read, retain, copy, print, distribute or use this message. If you have received this
communicationin error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not
acceptany liability for virus infected mails.