Page 1 sur 1
Connexion Base de données H2
Posté : mer. nov. 23, 2011 11:18 am
par Mart1
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
Re: Connexion Base de données H2
Posté : mer. nov. 23, 2011 5:46 pm
par xantof
Bonjour,
http://www.h2database.com/html/tutorial.html
[approx aux 3/4 de la page]
Stephan
Re: Connexion Base de données H2
Posté : jeu. nov. 24, 2011 11:21 am
par Mart1
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.