Possible to say: [setObject("123")] to insert into int column type ?

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