Re: [PATCHES] JDBC2 Array Patch (New feature)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Greg Zoller <gzoller(at)hotmail(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org, PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [PATCHES] JDBC2 Array Patch (New feature)
Date: 2001-08-08 15:19:32
Message-ID: 200108081519.f78FJW315466@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-patches


Your patch has been added to the PostgreSQL unapplied patches list at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

> Hello...
>
> This is my first contribution for Postgresql, so I hope its
> found the proper home.
>
> The patch adds Array support to the JDBC2 library (to myknowledge
> Arrays aren't part of JDBC 1.0(?)). Specifically you can now use
> the ResultSet.getArray() method to return an java.sql.Array object.
> Its a really convenient way to load up a Java array with one
> columns' worth of results.
>
> It is mostly implemented, except for a few less common data types
> that I wasn't sure how to correctly pack into the tuples. The
> JDBC Array method variants that use type Map objects are likewise
> unsupported because the corresponding code in ResultSet has yet
> to be enabled. Other than that its all there.
>
> The patch is for the 7.1.2 "latest" build. I tried building the
> snapshot build but for some reason it wouldn't compile for me,
> so the "latest" was the best available.
>
> To apply the patch:
>
> > cd to <postgresql_src_dir>/src/interfaces/jdbc/org/postgresql
> > patch -p1 < /PATH_TO_PATCH_FILE/patch.txt
> > cd ../..
> > ant
>
> This will build the new postgresql.jar in the jars directory.
> Please forward any comments to gzoller(at)hotmail(dot)com(dot)
>
> Thanks
> Greg Zoller
>
> ps. I would be very grateful if the owner/maintainer of the
> JDBC interface would fire off a short email to tell me if my
> Array code is worthy of inclusion in the next Postgresql
> release!
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2001-08-08 16:50:11 Re: JDBC 2.0 conformance, documentation and todo list
Previous Message Dave Cramer 2001-08-08 13:59:05 RE: Bug found in the driver

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-08-08 15:20:00 Re: Revised Patch to allow multiple table locks in "Unison"
Previous Message Doug McNaught 2001-08-08 14:00:54 Re: Re: Still wondering about random numbers...