Subject AW: AW: [Firebird-Java] jabird / Select / Update
Author Steffen Heil (Mailinglisten)

> If I remember correctly (need to check sources), that your SELECT will be
> fetched first to the client completely, before you will be able to perform
> operation on result set (the SCROLL_INSENSITIVE flag should instantiate a
> called cached result set, which means - "first cache everything in memory,
> then allow operations on result set).

That's something I feared.

> The only flag that does not perform result set caching is FORWARD__ONLY,
> but I am not sure tthat it is compatible with the UPDATABLE result set.

Obviously that would be very intresting form e.
Would it be hard to check?

> The approach with one statement for SELECT (no flags will mean
> FORWARD_ONLY and READ_ONLY) and one statement for updates is better -
> in that case you are in control of everything. Just remember to switch-off
> auto-commit mode.

Autocommit is off, of course.


[Non-text portions of this message have been removed]