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
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 |