Re: streaming result sets: progress

On Thursday 14 November 2002 04:14 pm, nferrier(at)tapsellferrier(dot)co(dot)uk wrote:
> Message-ID: <uu1iki0vx(dot)fsf(at)tapsellferrier(dot)co(dot)uk>
> Lines: 35
> MIME-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> --text follows this line--
>
> snpe <snpe(at)snpe(dot)co(dot)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?

I add AbstractJdbc3Statement missing method from AbstractJdbc2Statement and
it work.I don't test complete, but simple command on table with 1 mil. rows
work fine.
>
> > 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.

You send this :
BEGIN; DECLARE JDBC_CURS_1 CURSOR FOR select * from tab FETCH FORWARD 100
FROM JDBC_CURS_1;
I change and send :
BEGIN; DECLARE JDBC_CURS_1 CURSOR FOR select * from tab; FETCH FORWARD 100
FROM JDBC_CURS_1;

>
> > 3) JDBC in cvs changed, but patch doesn't work with current cvs
>
> I'll do a resync and reissue the patch tonight.
>
>

regards
Haris Peco