Re: Cannot pass null in Parameter in Query for ISNULL

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Cannot pass null in Parameter in Query for ISNULL
Дата
Msg-id CADK3HH+8DP-6CMfbe+mLcMZBhHKX+b=fm21PveO=eyaE_+So0w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Cannot pass null in Parameter in Query for ISNULL  (Bernard <bht237@gmail.com>)
Ответы Re: Cannot pass null in Parameter in Query for ISNULL  (Bernard <bht237@gmail.com>)
Список pgsql-jdbc
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@gmail.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
>

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Bernard
Дата:
Сообщение: Re: Cannot pass null in Parameter in Query for ISNULL
Следующее
От: jonathan.lister@vaisala.com
Дата:
Сообщение: Please could we have support for isValid() method in JDBC driver?