Re: JDBC gripe list

Dave Cramer  wrote:

> My sense is that for basic read/write/update/delete the driver
> works just fine. However I'd like to compile a list of everyone's
> gripe.

At the top of my list is the need to use a cursor to avoid
materializing the entire result set in heap during execution of an
execute method.  Pulling data off the wire should be done in
ResultSet.next() method.  Yes I know this is not a trivial change,
and yes I know that it means that you can get errors during the
next() method which currently happen during execute.

There are several reasons this can improve performance, as well as
eliminating a commonly reported problem with OutOfMemoryError
exceptions when people don't know about the issue or accidentally
miss one of the requirements.

-Kevin