Hi:
I think setObject() has been discussed extensively on
this list
(particularly with setting null values). However,
consider the following:
In PSQL:
test=# create table foo (number_column int);
Now in Java:
PreparedStatement ps = con.prepareStatement(
"insert into foo (number_column) values (?)"
);
ps.setObject(1, "123");
ps.executeUpdate();
This will throw a Driver exception. Is this expected
behavior
or should the driver do a Integer.parseInt(...) on the
string value
as needed ?
This is not a show-stopper or even a serious bug in my
code
and is easy to workaround. I'm just curious as to the
"right"
behavior as per the JDBC spec.....
Best regards,
--j
----------------------- Exception ------------------
ERROR: column "number_column" is of type integer but
expression is of type character varying
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
QueryExecutorImpl.java:1527)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(
QueryExecutorImpl.java:1311)
.....
---------------------------------------------------
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com