| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Alessandro Di Bella <aldibella(at)gmail(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Bug in org.postgresql.jdbc2.AbstractJdbc2Array |
| Date: | 2007-07-05 17:47:35 |
| Message-ID: | 468D2EB7.3060209@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | baisa, darwin | 2007-07-06 11:31:10 | Connection is closed. Operation is not permitted. ------HELP.... |
| Previous Message | Alessandro Di Bella | 2007-07-05 15:05:31 | Bug in org.postgresql.jdbc2.AbstractJdbc2Array |