Re: domains handling problem

From: Kris Jurka <books(at)ejurka(dot)com>
To: Віталій Тимчишин <tivv00(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: domains handling problem
Date: 2011-03-20 01:00:56
Message-ID: alpine.BSO.2.00.1103192100090.28447@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Tue, 22 Feb 2011, ??????? ???????? wrote:

> Today I've got next exception on postgresql 9..0-801 jdbc4 driver:
> Caused by: org.postgresql.util.PSQLException: Unsupported Types value: 2,001
>         atorg.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statemen
> t.java:1745)
>
> After looking a little deeper I've foudn out that driver report domain type
> as Types.DISTINCT, but does not accept it in setObject call. And spring
> library uses metadata to fill default SQL types to be sent to driver. I did
> a workaround by hard-wiring Types.OTHER, but I suppose this to be driver bug
> as driver should accept any sql type it provides from metadata.
>

I concur. Fixed in CVS for 8.2+.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2011-03-20 03:34:43 Re: Issue getColumns(): Nonstandard use of \\ in a string literal
Previous Message Kris Jurka 2011-03-20 00:12:15 Re: Failing test in org.postgresql.test.jdbc2.DateTest