Re: Throwing NumberFormat exception for preparedStatement.setObjcet()

From: Srinivas Gunnam <srinivas_gunnam(at)persistent(dot)co(dot)in>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Throwing NumberFormat exception for preparedStatement.setObjcet()
Date: 2010-01-12 05:40:33
Message-ID: 14B8F27D7CE40C4C9E481B2B845C2E0D72467E0F@EXCHANGE.persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Thanks for your reply.
Here columnType value is 3 and inputdata value is always string type.
-----Original Message-----
From: davecramer(at)gmail(dot)com [mailto:davecramer(at)gmail(dot)com] On Behalf Of Dave Cramer
Sent: Tuesday, January 12, 2010 1:45 AM
To: Srinivas Gunnam
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Throwing NumberFormat exception for preparedStatement.setObjcet()

On Mon, Jan 11, 2010 at 7:58 AM, Srinivas Gunnam
<srinivas_gunnam(at)persistent(dot)co(dot)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 intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2010-01-12 11:45:17 Re: Throwing NumberFormat exception for preparedStatement.setObjcet()
Previous Message Dave Cramer 2010-01-11 20:15:28 Re: Throwing NumberFormat exception for preparedStatement.setObjcet()