Обсуждение: Java equivalent data type for chkpass.

Поиск
Список
Период
Сортировка

Java equivalent data type for chkpass.

От
Saurabh Jain
Дата:
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.

Re: Java equivalent data type for chkpass.

От
Kris Jurka
Дата:

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