LO / Firebird DB Integration

[Andrzej J. R. Hunt]

Hi there,

On 15/06/13 20:03, Javier Fernandez wrote:
> Nice work !!! We haven't been able to build Firebird inside libreoffice
> at the beginning, so we movd to the system library instead. Perhaps you
> could take that as reference for the installation details you mentioned.
>
> BTW, I've tested your changes in the branch and this is what I get by
> opening an already created ODB file configured for Firebird:
>
> warn:cppuhelper:664:1:cppuhelper/source/shlib.cxx:501: loading component
> library failed:
> file://$HOME/libo.git/solver/unxlngx6/installation/opt/program/../program/libfirebird-sdbclo.so
> terminate called after throwing an instance of
> 'com::sun::star::loader::CannotActivateFactoryException'
I've finally managed to figure out how to get the install working -- the
driver now loads fine. For the moment however the following is needed
for things to work:

FIREBIRD=./install/program/firebird
LD_LIBRARY_PATH=$(LD_LIBRARY_PATH):./install/program/firebird/lib
./install/program/soffice.bin --base

I'm not entirely sure how to provide these paths within LO to avoid
having to prepend them yet.

I'm also not entirely certain everything will work as expected yet
either -- I haven't found a definitive list of files which Firebird 2.5
requires in embedded mode -- if anything is missing it can be however
easily be added to the bottom of firebird/ExternalPackage_firebird.mk.

The firebird specific libraries (fb builds its own versions
libicuuc/libicudata/etc.) are currently in install/program/firebird/lib
(I've simply copied the firebird installation structure into
install/program/firebird, although I've installed as few files as
possible as most of them seem to only be needed for a full FB server) --
I'm not entirely sure how correct this is, but libfbembed (which is in
the usual place i.e. install/program) doesn't look for
libicuuc/libicudata/etc. in the usual locations (I have little/no idea
of how library loading works yet, or the appropriate terminology
either...), hence it seemed to make more sense to me to just leave them
in the place that firebird expects them to be since the path apparently
needs to be set wherever they are.

> I want to use this email as well to introduce a new section in the wiki,
> related to the Firebird driver implementation:
>
> https://wiki.documentfoundation.org/Development/Base/FirebirdSQL#Firebird_driver_implementation
>
> I've added some notes about the current status of the driver
> implementation and some tasks to organize a bit the work to be done to
> complete the implementation.
>
> I have not too much time at this moment, but I'll try some hours every
> week. Feel free to assign one of those tasks or adding them to your
> personal schedule. I'll be available at the IRC for discussing details
> and help you the best I can, if needed.
Cool! I'm still working on the building of Firebird -- sorting out the
installation details took longer than expected, and it's hard for me to
estimate how long getting the windows build working will actually take
(the installation stuff took me longer than I expected), but hopefully
I'll be able to start work there soon.

ATB,

    Andrzej