Subject Re: [Firebird-Java] Yet about (Jaybird 2.0.1 + JDBC 3.0) x 1.5.5
Author Roman Rokytskyy
> You're saying that in a new version of the driver, it will be possible
> to setup HOLD_CURSORS_OVER_COMMIT by default in a connection, without to
> configure each new Statement, aren't you?

Yes, that's exactly what I say.

> And what's the real cost of memory? Because I use also other RDBMSs/JDBC
> drivers and I don't experiment any problems with memory usage, either in
> medium/large systems, with more than 500 (up to 1000) users
> simultaneosly using a Servlet system.

As I wrote few of times before, the complete result is cached in the memory.
That is <number of rows> * <size of the row> until the result set is closed
or statement is re-executed.