Re: Bug in org.postgresql.jdbc2.AbstractJdbc2Array

Alessandro Di Bella wrote:
> Hi,
> I found a bug in the org.postgresql.jdbc2.AbstractJdbc2Array class that
> causes the following exception when an array contains a null value:
>
> Caused by: org.postgresql.util.PSQLException: Bad value for type date :
> NULL
>    at
> org.postgresql.jdbc2.TimestampUtils.loadCalendar(TimestampUtils.java:246)
>    at org.postgresql.jdbc2.TimestampUtils.toDate(TimestampUtils.java:402)
>    at
> org.postgresql.jdbc2.AbstractJdbc2Array.getArrayImpl(AbstractJdbc2Array.java:210)
>
>
> I attached a patch that fixes the problem. If you are happy with it,
> please merge it with the HEAD stream.

Thanks!

There's a little problem with the patch; it will transform a text column
with the string "NULL" to a null.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com