Re: streaming result sets: progress - Mailing list pgsql-jdbc

From snpe
Subject Re: streaming result sets: progress
Date
Msg-id 200211141607.10866.snpe@snpe.co.yu
Whole thread Raw
In response to Re: streaming result sets: progress  (Nic Ferrier <nferrier@tapsellferrier.co.uk>)
Responses Re: streaming result sets: progress  (nferrier@tapsellferrier.co.uk)
List pgsql-jdbc
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)
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
3) JDBC in cvs changed, but patch doesn't work with current cvs

regards
Haris Peco





pgsql-jdbc by date:

Previous
From: snpe
Date:
Subject: Re: [HACKERS] PostgreSQL JDBC and sub-select
Next
From: "M. A. Sridhar"
Date:
Subject: Re: Help with NPE