Re: UDT arrays - Mailing list pgsql-jdbc

From Radosław Smogura
Subject Re: UDT arrays
Date
Msg-id 201102091029.28960.rsmogura@softperience.eu
Whole thread Raw
In response to UDT arrays  (Lukas Eder <lukas.eder@gmail.com>)
Responses Re: UDT arrays
List pgsql-jdbc
Actully I've done support for Structs, with fixation of metdata bugs for those
types (JDBC spec is not clear, about metadata), but only in binary mode. I
will, probably, don't give support for text protocol, because I belive binary
protocol is future (but here is ?).

Currently
1. I need to give full support for SQLData, Input & Output, as well implement
last type (time with timezone).
2. I need do something with DISTINCTS/DOMAINS

Problem is with timestamap with timezone, as on this field backend is
incompatible with JDBC, so probably driver will need to extend database, or I
need to do some "unsafe" operations or throw exception for some situations.

In both of this I need to do / write full tests for many compilations of
resultset/arrays/structs.

Some functionality will temporaly go away (eg. updating result sets, arrays
returning result sets for mulitdimensional array, geometric types, and all
PG*Objects will be sleeped too).

I want to resolve some serius bugs about resultsets and SQLXML, too, before
release (this with result set may wait, if only one person found it, and not
even found full problem...), but SQLXML is important as XML is popular
solution.

Maybe "true" async notifications based on listener pattern will be included in
release.

Have a nice day

Lukas Eder <lukas.eder@gmail.com> Tuesday 08 February 2011 00:26:58
> Hello,
>
> I was wondering, is JDBC driver support for the combination of UDT's
> and arrays planned for the near future? I couldn't find any
> documentation on the JDBC drivers website.
>
> Is there any specific reason (apart from the fact that UDT's and/or
> ARRAYs are not used often) for this lack of implementation? Clearly,
> the database itself supports this combination. I can easily insert and
> select data from a table holding UDT arrays
>
> Cheers
> Lukas

pgsql-jdbc by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: ResultSet.getClob() causing problems when used with JPA's @Lob
Next
From: Oliver Jowett
Date:
Subject: Re: ResultSet.getClob() causing problems when used with JPA's @Lob