H2 Database Engine

H2 Database Engine

2.2.224 Build 2023-09-17

H2 Database Engine: SQL database engine written in Java

SQL database engine written in Java

JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported.

H2 Database Engine features :

- Fast database engine
- Free, source code is included
- Supports standard SQL
- Written in Java
- Disk based or in-memory databases
- Browser base Console application
- JDBC API
- Limited ODBC support
- Embedded and client/server (network) mode
- High availablility support (clustering / failover)
- Wide range of data types including large objects (BLOB/CLOB)
- Strong security features (SSL, users, roles, encrypted files)
- Multiple connections, table level locking
- Cost based optimizer, using a genetic algorithm for complex queries
- Transaction support (serializable transaction isolation)
- Zero-administration, automatic recovery
- Large resultset, external sorting
- Scrollable and updatable resultset support
- Read only views and inline views
- Inner and outer joins, subqueries
- Many functions already built-in
- Triggers and Java functions / stored procedures
- Referential integrity / foreign key constraints with cascade, check constraints
- Multiple schema support
- Compatibility modes for HSQLDB, MySQL and PostgreSQL
- Sequence and autoincrement columns
- Well tested (high code coverage, randomized stress tests)
- Small footprint (smaller than 1 MB)
- Uses a small number of database files
- Can be compiled to native code using GCJ
- Primary keys, multiple index types (b-tree, linear hash, tree, hash)
- ORDER BY, GROUP BY, HAVING, UNION, LIMIT
- Information Schema
- Multiple connections
- Collation support
- EXPLAIN PLAN support
- The database can generate SQL script files
- Support for linked tables, and a built-in virtual 'range' table
- Automatic re-compilation of prepared statements
- Sophisticated trace options
- Low memory requirements
- Easy to understand exception messages
- Standard handling of NULL values
- Multilanguage console application (at this time, English and German)

Download Details

  • License:
    Freeware
  • Platform:
    Windows
  • Publisher:
  • File size:
    6.50 Mb
  • Updated:
    Sep 21, 2023
  • User Rating:
    4.0 / 5 (2 votes)
  • Editors' Review:
    Not yet reviewed
  • Downloads:
    1,747
Similar software
TeeChart for .NET 4.2024.3.15
.NET Charting Component Library
13 / 1,073
Eclipse SDK 4.7.3a
Open-source Java IDE and platform for apps
86 / 93,511
Universal Data Access Components 10.1.0
Useful component library that provides users with a way of accessing databases from their preferred programming environment.
5 / 703
HXTT DBF 7.1.252
One of the best set of components for Xbase database JDBC drivers
40 / 2,069
QxOrm 1.4.9
An ORM database library you can use to integrate Object Relational Mapping into C++ and Qt-based software
19 / 1,535
Lazarus 3.0
A powerful Delphi programming environment with an intuitive IDE
36 / 3,234