Embedding the Java h2 database programmatically

Question

Yes, you can run H2 in embedded mode. You just use the JDBC driver and connect to an embedded url like this (their example):

This database can be used in embedded
mode, or in server mode. To use it in
embedded mode, you need to:
* Add h2.jar to the classpath
* Use the JDBC driver class: org.h2.Driver
* The database URL jdbc:h2:~/test opens the database 'test' in your user home directory

Example of connecting with JDBC to an embedded H2 database (adapted from http://www.h2database.com/javadoc/org/h2/jdbcx/JdbcDataSource.html ):

import org.h2.jdbcx.JdbcDataSource;
// ...
JdbcDataSource ds = new JdbcDataSource();
ds.setURL("jdbc:h2:˜/test");
ds.setUser("sa");
ds.setPassword("sa");
Connection conn = ds.getConnection();

If you’re looking to use H2 in a purely in-memory / embedded mode, you can do that too. See this link for more:

http://www.h2database.com/html/features.html#in_memory_databases

You just need to use a special URL in normal JDBC code like “jdbc:h2:mem:db1”.

Leave a Comment Cancel reply