Re: streaming result sets: progress

On Friday 22 November 2002 07:16 pm, Nic Ferrier wrote:
> snpe <snpe(at)snpe(dot)co(dot)yu> writes:
> > Yet another sugestion :
> >
> > When make createStatement, we haven't to do fetch - command is same
> > except begin; declare xxx cursor (I think that and begin will not be
> > required soon) When we call first ResultSet.next (or like) we call fetch
> > if don't rows in memory. It is way in another databases : execute is
> > prepare and bind (without fetch) and then is fetch JDBC specification
> > tell same - execute don't nothing with row
>
> JDBC spec doesn't require any particular behaviour... what we've got
> kinda works.
>

JDBC spec requires that after executeStatement there is nothing in ResultSet.

Execute and fetch are different command - only in PostgreSQL they are one command.
PostgreSQL with cursors work execute and fetch , too

regards
Haris Peco

regrads