Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot pass null in Parameter in Query for ISNULL - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Cannot pass null in Parameter in Query for ISNULL
Date
Msg-id CADK3HH+HyAqdSANnYYJvH3nNjCsRZBR-wb37PpvVQaonuXXrVA@mail.gmail.com
Whole thread Raw
In response to Fwd: Cannot pass null in Parameter in Query for ISNULL  (Maciek Sakrejda <msakrejda@truviso.com>)
Responses Re: Cannot pass null in Parameter in Query for ISNULL  (Maciek Sakrejda <msakrejda@truviso.com>)
Re: Cannot pass null in Parameter in Query for ISNULL  (Bernard <bht237@gmail.com>)
List pgsql-jdbc
Tree view 
> [1] (from PreparedStatement.setObject): "Note: Not all databases allow
> for a non-typed Null to be sent to the backend. For maximum
> portability, the setNull or the setObject(int parameterIndex, Object
> x, int sqlType) method should be used instead of setObject(int
> parameterIndex, Object x). "
> ---


This was essentially Oliver's argument. The spec specifically tells
you what to do.

Bernard, if you point this out to the projects in question what do they say ?

Dave

pgsql-jdbc by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Fwd: Cannot pass null in Parameter in Query for ISNULL
Next
From: Maciek Sakrejda
Date:
Subject: Re: Cannot pass null in Parameter in Query for ISNULL