Bonjour,
Est-il possible de se connecter à la base de données H2 en utilisant "OpenOffice Base" ?
Si oui, pourriez vous m'orienter sur la marche à suivre ?
Merci d'avance
Connexion Base de données H2
Lubuntu 16.04 LTS au travail. Ubuntu 15.04 à la maison. 13 ans sous logiciel propriétaire. OC depuis 2012. Petit Commerce
Comment poser une question sur un forum : http://www.linux-france.org/article/the ... ns-fr.html
Comment poser une question sur un forum : http://www.linux-france.org/article/the ... ns-fr.html
Merci
Using OpenOffice Base
OpenOffice.org Base supports database access over the JDBC API. To connect to a H2 database using OpenOffice Base, you first need to add the JDBC driver to OpenOffice. The steps to connect to a H2 database are:
Start OpenOffice Writer, go to [Tools], [Options]
Make sure you have selected a Java runtime environment in OpenOffice.org / Java
Click [Class Path...], [Add Archive...]
Select your h2 jar file (location is up to you, could be wherever you choose)
Click [OK] (as much as needed), stop OpenOffice (including the Quickstarter)
Start OpenOffice Base
Connect to an existing database; select [JDBC]; [Next]
Example datasource URL: jdbc:h2:~/test
JDBC driver class: org.h2.Driver
Now you can access the database stored in the current users home directory.
Using OpenOffice Base
OpenOffice.org Base supports database access over the JDBC API. To connect to a H2 database using OpenOffice Base, you first need to add the JDBC driver to OpenOffice. The steps to connect to a H2 database are:
Start OpenOffice Writer, go to [Tools], [Options]
Make sure you have selected a Java runtime environment in OpenOffice.org / Java
Click [Class Path...], [Add Archive...]
Select your h2 jar file (location is up to you, could be wherever you choose)
Click [OK] (as much as needed), stop OpenOffice (including the Quickstarter)
Start OpenOffice Base
Connect to an existing database; select [JDBC]; [Next]
Example datasource URL: jdbc:h2:~/test
JDBC driver class: org.h2.Driver
Now you can access the database stored in the current users home directory.