Re: domains handling problem - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: domains handling problem
Date
Msg-id alpine.BSO.2.00.1103192100090.28447@leary.csoft.net
Whole thread Raw
In response to domains handling problem  (Віталій Тимчишин <tivv00@gmail.com>)
Responses Re: domains handling problem
List 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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Failing test in org.postgresql.test.jdbc2.DateTest
Next
From: Kris Jurka
Date:
Subject: Re: Issue getColumns(): Nonstandard use of \\ in a string literal