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