[Libreoffice-bugs] [Bug 118809] Firebird: XDatabaseMetaData implementation returns NULL strings for DatabaseProductName and DatabaseProductVersion

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Julien Nabet from comment #2)
> Drew: we currently use Firebird 3.0.0
> Now version retrieved must work with embedded Firebird and not embedded
> Firebird.

My .02 worth:

(Hopefully if I have any details wrong someone will correct me.)

Both the Base embedded Firebird and Base file Firebird use the Firebird
embedded engine, which in the Firebird server configuration is referred to as
an 'engine12' connection when configuring access to managed files. Server
managed .fdb files can be configured to accept 'engine12' connections or reject
them.

It could make sense then to return a string of 'Firebird (engine12)' for the 
DatabaseProductName property as it would be the most precise and would be
accurate for both scenarios of an embedded database file and an external
database file using the firebird sdbc driver. 

If a user is connecting to a Firebird server with a jdbc or odbc driver the
server would see that connection as 'remote' or 'loopback', using tcp/ip or or
wnet or whathaveyou, for a file on the local machine or remote machine. 

Having 'engine12' in the sdbc designation could help if someone tries to create
a Base odc and pointed to a managed .fdb file only to be refused connection
attempts. 

> For last one, obviously, we can't use a fixed string to display the version.
> For first case, should we display the built Firebird version in LO or the
> Firebird version corresponding to the moment we created the file?

The version number could be retrieved at runtime by executing

SELECT rdb$get_context('SYSTEM', 'ENGINE_VERSION') 
             as version from rdb$database;

currently (6.0, 6.1, 6.2) Base sdbc connections return 3.0.0. If the binaries
for the Firebird engine going forward are updated that should reflect any
change.

-- 
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/20180723/999d3752/attachment-0001.html>