Hi,
Suppose I have a table like:
CREATE TABLE test
( id DECIMAL(10)
);
When executing the following statement from the psql command prompt:
INSERT INTO test(id) VALUES ('12345');
That will succeed.
When executing the following from JDBC:
PreparedStatement stmt =
con.prepareStatement("INSERT INTO test(id) VALUES (?)");
stmt.setString("12345");
stmt.executeUpdate();
This will fail. With the message:
Cause: ERROR: column "id" is of type numeric but expression is of type
character varying
I think this shouldn't fail. This exact same piece of Java code does work
with all other databases that I work with. And psql doesn't seem to mind
taking a string value either, so why should the PreparedStatement?
Regards,
Bert
