[Java] Relationship between H2DB and JDBC

H2 Database features

The main features of H2 are:

  • Very fast, open source, JDBC API
  • Embedded and server modes; in-memory databases
  • Browser based Console application
  • Small footprint: around 2 MB jar file size
H2 Derby HSQLDB MySQL PostgreSQL
Pure Java Yes Yes Yes No No
Memory Mode Yes Yes Yes No No
Encrypted Database Yes Yes Yes No No

From H2 Database Engine

server modes

in-memory databases modes

Embedded modes

Relationship between H2 and JDBC


Recommended Posts

[Java] Relationship between H2DB and JDBC
Relationship between kotlin and java access modifiers
[Java] Difference between == and equals
Relationship between Controller and View
Relationship between package and class
JDBC, CP, JPA, ORM .. Organize those between Java and RDB
[Java] Difference between Hashmap and HashTable
Relationship between ActiveRecord with_lock and cache
Use JDBC with Java and Scala.
Relationship between database and model (basic)
[JAVA] Difference between abstract and interface
[Java] Difference between array and ArrayList
Differences between Java and .NET Framework
[Java] Difference between Closeable and AutoCloseable
[Java] Difference between StringBuffer and StringBuilder
[Java] Difference between length, length () and size ()
[Java] Introductory structure Class definition Relationship between class and instance Method definition format
The relationship between strict Java date checking and daylight savings time
About the relationship between the Java String equality operator (==) and initialization. Beginners
Conversion between Kotlin nullable and Java Optional
Difference between final and Immutable in Java
[For beginners] Difference between Java and Kotlin
[Java] Differences between instance variables and class variables
[About JDBC that connects Java and SQL]
[Note] Cooperation between Java and DB (basic)
Java and Derby integration using JDBC (using NetBeans)
Relationship between Eclipse m2e plugin and Maven
[Java] Difference between Intstream range and rangeClosed
Difference between int and Integer in Java
HashMap # putAll () behaves differently between Java 7 and Java 8
Interpret the relationship between Java methods and arguments into a biochemical formula
Java and JavaScript
XXE and Java
[Java] Understand the difference between List and Set
Difference between next () and nextLine () in Java Scanner
Summarize the differences between C # and Java writing
Distinguish between positive and negative numbers in Java
[Java] Difference between "final variable" and "immutable object"
Relationship between UI test and recording, implementation method
Getters and setters (Java)
[Java] Thread and Runnable
Java true and false
[Java] String comparison and && and ||
About the relationship between HTTP methods, actions and CRUD
[Java] Difference between static final and final in member variables
[JAVA] What is the difference between interface and abstract? ?? ??
Java --Serialization and Deserialization
[Java] Arguments and parameters
Verification of the relationship between Docker images and containers
Switch between JDK 7 and JDK 8
timedatectl and Java TimeZone
[Java] Branch and repeat
Difference between vh and%
Mutual conversion between Java objects and JSON using Moshi
[Java] Variables and types
Difference between i ++ and ++ i
What is the difference between Java EE and Jakarta EE?
java (classes and instances)
[Java beginner] Difference between length and length () ~ I don't know ~
[Java] Overload and override
[Java Bronze learning] Differences between encapsulation, data hiding, and information hiding