jdbc driver patch: refcursor types, cursor based querys.

From: Nic Ferrier <nferrier(at)tapsellferrier(dot)co(dot)uk>
To: pgsql-patches(at)postgresql(dot)org
Subject: jdbc driver patch: refcursor types, cursor based querys.
Date: 2002-12-26 19:24:07
Message-ID: 87wulwpors.fsf@pooh-sticks-bridge.tapsellferrier.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

(Sorry if people have seen this before, I've tried to post it several
times without success: this is my last try before talking to the
admins).

The attached patch provides several things:

1. it allows refcursor ResultSet's to be obtained from a stored proc
returning a refcursor value. The actual value returned is:

org.postgresql.PGRefCursorResultSet

which represents a refcursor as per discussions I had with Barry.
In essence it looks exactly like a ResultSet but is not actually
fetched until next() is called on it.

2. cursor based querys allowing massive fetches.
Calling Statement.setFetchSize(x) causes the driver to use a cursor
and a forward fetch of size x.

3. simplification of the calling routines.
The QueryExecutor has been made more static. Simplifications were
made to reduce the number of method calls.

It should be applied to the latest source tree (which is 7.3.1 I believe).

Note that as far as 3 is concerned I have some more ideas that came
out of discussions about re-(java)packaging with Barry. These can
wait until this patch gets accepted (or not!).

Thanks, and Merry Christmas.

Nic

Attachment Content-Type Size
patchfile text/patch 52.1 KB

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-12-26 22:24:17 Re: MOVE strangeness
Previous Message Tom Lane 2002-12-26 19:14:40 Re: MOVE strangeness