Skip site navigation (1) Skip section navigation (2)

Re: Cannot pass null in Parameter in Query for ISNULL

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Bernard <bht237(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Cannot pass null in Parameter in Query for ISNULL
Date: 2012-04-24 17:44:56
Message-ID: CADK3HHK=-C+F=iMjB6E5ModGLMAwUwy+cKW2ARfW9+xFe33uDQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Bernard,

Do you know what their fix was ?

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Tue, Apr 24, 2012 at 1:39 PM, Bernard <bht237(at)gmail(dot)com> wrote:
> It no longer is contentious - they fixed it in Apache Derby.
>
> Bernard
>
> On Tue, 24 Apr 2012 05:37:37 -0400, you wrote:
>
>>More evidence that it's a contentious issue.
>>
>>Dave Cramer
>>
>>dave.cramer(at)credativ(dot)ca
>>http://www.credativ.ca
>>
>>
>>On Tue, Apr 24, 2012 at 2:59 AM, Bernard <bht237(at)gmail(dot)com> wrote:
>>> Dave,
>>>
>>> I have filed issues with Hibernate and EclipseLink. No activity at
>>> Hibernate. EclipseLink has a workaround for this but it does not work
>>> with Postgresql. It is quite difficult to get them to do anything
>>> because they are fine with their preferred databases e.g. Oracle,
>>> Mysql.
>>>
>>>
>>> I found this interesting:
>>>
>>> "Add support for setObject(<arg>, null)"
>>> https://issues.apache.org/jira/browse/DERBY-1938
>>>
>>> Bernard
>>>
>>>
>>> On Mon, 23 Apr 2012 15:15:56 -0400, you wrote:
>>>
>>>>> [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

pgsql-jdbc by date

Next:From: BernardDate: 2012-04-24 18:43:02
Subject: Re: Cannot pass null in Parameter in Query for ISNULL
Previous:From: BernardDate: 2012-04-24 17:39:03
Subject: Re: Cannot pass null in Parameter in Query for ISNULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group