j.random.programmer wrote:
> 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.....
I've found nothing in the JDBC spec to say that the driver is required
to do an implicit conversion of String to integer (if you found
something that says it is required, can you let me know where?).
If you explicitly specify a target SQL type (i.e.
'setObject(1,"123",Types.INTEGER)'), the driver will do the conversion
for you. But if you don't specify a type, the driver infers the SQL type
from the Java type of the object, per the rules in the JDBC spec -- in
this case, VARCHAR for a String object.
Or you could pass 'stringtype=unspecified' as a JDBC URL parameter which
means that String parameters aren't typed at all when passed to the
server (and the server tries to infer the type from the query).
-O