Apache OpenOffice Community Forum

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.

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...