Re: streaming result sets: progress

Message-ID: <uu1iki0vx.fsf@tapsellferrier.co.uk>
Lines: 35
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
--text follows this line--
snpe <snpe@snpe.co.yu> writes:

> On Wednesday 13 November 2002 11:57 pm, Nic Ferrier wrote:
> >...
> > > It was purely illustrative at this stage, and I missed (accidentally
> > > as it happens) the extra classes. I'll send another patch tonight.
> >
> > So I don't have to run the diff again whilst including this file,
> > here's the extra class. It goes in:
> >
> >    src/interfaces/jdbc/org/postgresql/PGResultSet.java
> > ..
> I have tried this patch.Table have 1048576 rows and standard jdbc doesn't work
> (select * from tab)
> With Your patch it works.That is cool, but I have some problems :
> 1) I have made jdbc with jdk 1.4.1, but it is for jdbc2 (I guess)

It doesn't work with 1.4.1?

> 2) method nic_execute create query like :
> BEGIN; DECLARE JDBC_CURS_1 CURSOR FOR select * from tab FETCH FORWARD 100 FROM
> JDBC_CURS_1;
> I add ";" before FETCH

Hmmm... that's odd. Does the statement you supply have a ";" on the
end of it? My patch only works if it does.


> 3) JDBC in cvs changed, but patch doesn't work with current cvs

I'll do a resync and reissue the patch tonight.


Nic