|Subject||Re: [Firebird-Java] Yet about (Jaybird 2.0.1 + JDBC 3.0) x 1.5.5|
> You're saying that in a new version of the driver, it will be possibleYes, that's exactly what I say.
> to setup HOLD_CURSORS_OVER_COMMIT by default in a connection, without to
> configure each new Statement, aren't you?
> And what's the real cost of memory? Because I use also other RDBMSs/JDBCAs I wrote few of times before, the complete result is cached in the memory.
> 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.
That is <number of rows> * <size of the row> until the result set is closed
or statement is re-executed.