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