I only have one question regarding this.

Does this functionality, fetching all data to the client, comply with
some newer standard?

Interclient and Oracle Java clients do not fetch the data all at once,
but only record by record using the next() method.

We are about to change our code to compy to Jaybirds way of doing this
but I would like to know that we are becoming more standard and not
less standard.

Stephen

> In autocommit mode (default) all data are fetched to the client. This
> means that JayBird tries to load your 250,000 into memory.

> > If I comment the autocommit and commit statements I get an out of
> > memory message. If I add a first statement I can open the SELECT for
> > the first 70'000 records, if I put a higher number I get the
> > following output:
>