From: | snpe <snpe(at)snpe(dot)co(dot)yu> |
---|---|
To: | Nic Ferrier <nferrier(at)tapsellferrier(dot)co(dot)uk> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: streaming result sets: progress |
Date: | 2002-11-23 09:51:34 |
Message-ID: | 200211230951.34786.snpe@snpe.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Friday 22 November 2002 11:55 pm, Nic Ferrier wrote:
> Message-ID: <87of8h5fdc(dot)fsf(at)pooh-sticks-bridge(dot)tapsellferrier(dot)co(dot)uk>
> Lines: 27
> 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 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.
>
> No it doesn't. It requires that the result set is not positioned
> until after the first call to next().
>
> Postgresql's behaviour is quite legitimate.
>
Yes, it is legitime, but execute and fetch are separated command.
There isn't good reason for doing fetch with execute - maybe user never call fetch.
regards
Haris Peco
From | Date | Subject | |
---|---|---|---|
Next Message | michael noname | 2002-11-23 10:39:59 | |
Previous Message | Nic Ferrier | 2002-11-22 23:55:27 | Re: streaming result sets: progress |