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.