[Libreoffice-bugs] [Bug 118094] Firebird: Support more XResultSet functions

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118094

--- Comment #13 from Lionel Elie Mamane <lionel at mamane.lu> ---
(In reply to Tamas Bunth from comment #12)
> The Firebird API supports moving the cursor only forward.

${EXPLETIVE}

Now I feel guilty for selecting Firebird as embedded database for LibreOffice.

> They could be implemented though by reopening the result set each time we'd
> go backwards, and seek out the requested row.

I usually consider that is beyond the role of the SDBC driver. An alternative
implementation idea would be to cache the whole resultset...

> After looking around in the documentation of the C API it seems to me that
> it cannot be done, unless we calculate it with a "Select COUNT(...) from
> ..." kind of query. That could be expensive though.

Again, that kind of thing is beyond the role of the SDBC driver.

For the specific thing of isLast, we can fetch one additional row (and cache
it), this would allow to know if the current row is the last...


I looked at the JDBC driver, it seems they cache (at least in some situations)
the resultset in order to be able to implement going backward.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181210/5b70eca3/attachment.html>