Re: UDT arrays

From: Radosław Smogura <rsmogura(at)softperience(dot)eu>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: Lukas Eder <lukas(dot)eder(at)gmail(dot)com>
Subject: Re: UDT arrays
Date: 2011-02-09 09:29:28
Message-ID: 201102091029.28960.rsmogura@softperience.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)eder(at)gmail(dot)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

In response to

  • UDT arrays at 2011-02-07 23:26:58 from Lukas Eder

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2011-02-09 09:40:00 Re: ResultSet.getClob() causing problems when used with JPA's @Lob
Previous Message Andreas Joseph Krogh 2011-02-09 08:04:05 Re: ResultSet.getClob() causing problems when used with JPA's @Lob