Embedding the Java h2 database programmatically

by

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:

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

More Related Contents:

  1. H2 in-memory database. Table not found
  2. Can I have H2 autocreate a schema in an in-memory database?
  3. H2 database error: Database may be already in use: “Locked by another process”
  4. Simple export and import of a SQLite database on Android
  5. How to implement a db listener in Java
  6. proper hibernate annotation for byte[]
  7. Why do I need Transaction in Hibernate for read-only operations?
  8. “eval” in Scala
  9. Hibernate saveOrUpdate behavior
  10. When should we use a PreparedStatement instead of a Statement?
  11. Is the IN relation in Cassandra bad for queries?
  12. How is driver class located in JDBC4
  13. Filling combobox from database by using hibernate in Java
  14. Ways to save enums in database
  15. Spring Boot default H2 jdbc connection (and H2 console)
  16. Embed files into Excel using Apache POI
  17. No results returned by the Query error in PostgreSQL
  18. Room – Schema export directory is not provided to the annotation processor so we cannot export the schema
  19. How to simulate a DB for testing (Java)?
  20. How can I detect a SQL table’s existence in Java?
  21. com.mysql.jdbc.PacketTooBigException
  22. Create MySQL database from Java
  23. Save child objects automatically using JPA Hibernate
  24. Light weight alternative to Hibernate? [closed]
  25. How do I unit test jdbc code in java? [closed]
  26. Hibernate, spring, JPS & isolation – custom isolation not supported
  27. How to listen for Firebase setValue completion
  28. HQL joined query to eager fetch a large number of relationships
  29. Embedding mysql in java desktop application
  30. When to use JCR (content repository) over other options?

Leave a Comment