Home

Welcome to the cifojava2022-4 wiki!

How to connect Java Project with JDBC to H2 SQL Database

What is H2 Database

H2 is pure Java SQL database, which means you can embed H2 directly in your Java applications without any database installation.

• Very fast, open source, JDBC API compatible.
• You can use H2 in different modes, depending on your need: in-memory, embedded or client/server.
• H2 provides a browser-based console application which you can use to access SQL database.
• Lightweight: about 2.5MB jar file size. With such features, H2 can be used for rapid prototype development,** testing purpose or embedded in Java applications**.

H2 Java DataBase

Java JDBC: demoMavenH2

Project repo

Entity Manager Factory: test-hibernate-jpa

Project repo

JPA: libraryH2Command

Project repo