Re: setUseServerPrepare & typecasts - Mailing list pgsql-jdbc

Scott Lamb wrote:
> Aaron Mulder wrote:
>>     But I don't think you're supposed to use setObject for a null
>> value.  Instead, try
>>
>> setNull(1, Types.INTEGER)
>
> Hmm. Yeah, I guess the API docs don't really describe what setObject is
> supposed to do on null. But setNull(1, Types.INTEGER) seems to have the
> same problem.

Ahh, but the JDBC 3.0 specification does. Section 13.2.2.3 says "if a
Java null is passed to any of the setter methods that take a Java
object, the parameter will be set to JDBC NULL". So it should work.

Thanks,
Scott