Re: Java equivalent data type for chkpass. - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Java equivalent data type for chkpass.
Date
Msg-id alpine.BSO.2.00.1001211021180.25745@leary.csoft.net
Whole thread Raw
In response to Java equivalent data type for chkpass.  (Saurabh Jain <saurabhjain_2010@yahoo.co.in>)
List 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


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: How to use JDBC to update LargeObject
Next
From: deanhiller
Date:
Subject: XA DataSource ServerName not working