Re: Cannot pass null in Parameter in Query for ISNULL

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
Cc: PG-JDBC Mailing List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Cannot pass null in Parameter in Query for ISNULL
Date: 2012-04-23 19:15:56
Message-ID: CADK3HH+HyAqdSANnYYJvH3nNjCsRZBR-wb37PpvVQaonuXXrVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

> [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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Maciek Sakrejda 2012-04-23 19:23:47 Re: Cannot pass null in Parameter in Query for ISNULL
Previous Message Maciek Sakrejda 2012-04-23 17:00:35 Fwd: Cannot pass null in Parameter in Query for ISNULL