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

Re: Cannot pass null in Parameter in Query for ISNULL

From: Bernard <bht237(at)gmail(dot)com>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Cannot pass null in Parameter in Query for ISNULL
Date: 2012-04-24 18:43:02
Message-ID: nqsdp71egdhn04ot2sj0pks2chkjh17ugt@4ax.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi Dave,

Their fix is

https://issues.apache.org/jira/browse/DERBY-1938

I don't think their fix is complete, but in the issue that contentious
issue was discussed.

Bernard

On Tue, 24 Apr 2012 13:44:56 -0400, you wrote:

>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

pgsql-jdbc by date

Next:From: Prasanth ReddyDate: 2012-04-25 18:58:23
Subject: 9.1 JDBC 4 driver
Previous:From: Dave CramerDate: 2012-04-24 17:44:56
Subject: Re: Cannot pass null in Parameter in Query for ISNULL

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