New extension jdbcDriverOOo

Discussions about using 3rd party extension with OpenOffice.org
Post Reply
psilocybe
Posts: 107
Joined: Thu Jun 15, 2017 5:33 am

New extension jdbcDriverOOo

Post by psilocybe »

Hi all,

This jdbcDriverOOo new version, which replaces the HsqlDBDriverOOo extension, now includes 3 JDBC drivers:
  • - HsqlDB version 2.61
    - H2 version 2.1.212
    - Apache Derby version 10.15.2.0
It allows very easy use of these 3 databases in Base without having to configure anything except a Java JRE version 11 minimum.
It has been tested only under LibreOffice Base, problems of API UNO divergence are to be feared under OpenOffice Base.
It manages autoincremented keys in Base with HsqlDB and Derby, problems remain to be solved concerning H2.
It allows by accessing: Tools -> Options -> Base drivers -> JBDC Driver , to add any jar archive of JDBC driver and to make its use, in Base, as simple as for the drivers already embedded.

Voilà and thank you for your feedback.
LibreOffice 5.3.3.2 - Lubuntu 16.10 - LxQt 0.11.0.3
psilocybe
Posts: 107
Joined: Thu Jun 15, 2017 5:33 am

Re: New extension jdbcDriverOOo

Post by psilocybe »

Hi there,

The new version of jdbcDriverOOo now allows the management of users and roles (groups) and their associated privileges.

This has only been tested with HsqlDB, malfunctions are to be expected with H2 and Derby or any other JDBC driver, this remains to be tested...

Voila, I hope this can be useful...
LibreOffice 5.3.3.2 - Lubuntu 16.10 - LxQt 0.11.0.3
Post Reply