Re: Java equivalent data type for chkpass.

From: Kris Jurka <books(at)ejurka(dot)com>
To: Saurabh Jain <saurabhjain_2010(at)yahoo(dot)co(dot)in>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Java equivalent data type for chkpass.
Date: 2010-01-21 15:22:23
Message-ID: alpine.BSO.2.00.1001211021180.25745@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 21 Jan 2010, Saurabh Jain wrote:

> I am updating chkpass data type column using JDBC preparedstatement, but it
> give me following exception.
>
> org..postgresql.util.PSQLException: ERROR: column "password" is of type
> chkpass but expression is of type character varying
>
> Is anybody aware of the data type we should set for this password column?
>

You should use setObject(index, value, Types.OTHER) to indicate that it's
not the exact type of value (String apparently), but something else
instead.

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message deanhiller 2010-01-21 20:51:15 XA DataSource ServerName not working
Previous Message Kris Jurka 2010-01-21 15:20:53 Re: How to use JDBC to update LargeObject