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?