H2 Database Engine

H2 Database Engine 2.4.240 is a lightweight, open-source Java SQL database that supports embedded, server, and in-memory database modes. H2 provides high-performance relational database capabilities, JDBC compatibility, transaction support, and a browser-based web console, making it suitable for application development, testing, prototyping, and production deployments.

Key Features of H2 Database Engine:

• Open-source relational database management system written in Java.
• Supports embedded, server, and in-memory database deployment modes.
• Provides full JDBC API support for Java applications.
• Lightweight database engine with a small installation footprint.
• Browser-based H2 Console for database administration and monitoring.
• Supports transactions, indexes, views, triggers, and referential integrity.
• Compatible with popular Java frameworks such as Spring Boot, Hibernate, and JPA.
• Supports disk-based persistent databases and in-memory databases.
• Includes TCP server mode for remote client connectivity.
• Offers SQL compatibility modes for MySQL, PostgreSQL, Oracle, SQL Server, and DB2.
• Suitable for development, testing, proof-of-concept, and production workloads.
• Can be deployed on virtual machines, cloud environments, development workstations, and servers.
• Provides high-performance data storage with minimal resource requirements.

H2 Database Engine Usage:

$ sudo su

# Verify H2 Package
$ ls -lh h2-2.4.240.jar

# Verify Installed H2 Version
$ unzip -p h2-2.4.240.jar META-INF/MANIFEST.MF | grep -i version

# Start H2 Server
$ java -cp h2-2.4.240.jar org.h2.tools.Server \
  -web \
  -webAllowOthers \
  -tcp \
  -tcpAllowOthers

# Verify Running Process
$ ps -ef | grep org.h2.tools.Server | grep -v grep

# Verify Listening Ports
$ ss -tulpn | grep -E '8082|9092'

# Verify H2 Web Console
$ curl http://localhost:8082

  

Disclaimer:
H2 Database Engine is an open-source database project developed and maintained by the H2 Group and contributors. H2 and related trademarks belong to their respective owners. This software is not affiliated with, endorsed by, or sponsored by any cloud provider, operating system vendor, database vendor, application framework, or third-party software mentioned for compatibility, integration, or deployment purposes. Any references to third-party products, technologies, or services are provided solely for informational and compatibility purposes. Users are responsible for reviewing and complying with the respective licensing terms, documentation, security practices, and usage policies of all software and services used in conjunction with H2 Database Engine.