Java equivalent data type for chkpass.

From: Saurabh Jain <saurabhjain_2010(at)yahoo(dot)co(dot)in>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Java equivalent data type for chkpass.
Date: 2010-01-21 14:47:29
Message-ID: 278314.65519.qm@web8501.mail.in.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

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
Hint: You will need to rewrite or cast the expression.
Position: 73
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
at com.servient.processor.utilities.ToolUtils.main(ToolUtils.java:58)

Is anybody aware of the data type we should set for this password column?

Thanks
--Saurabh

The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2010-01-21 15:20:53 Re: How to use JDBC to update LargeObject
Previous Message Satish Burnwal (sburnwal) 2010-01-21 12:10:29 Re: How to use JDBC to update LargeObject