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,779
Similar software
CTrayNotifyIcon 1.77
Create and test system tray icons for development and functionality purposes with the help of this lightweight and simple program.
142 / 1,906
Simd 4.2.74
A free and open-source image processing library for C and C++ programming languages
25 / 1,847
LibRaw 0.21.2
A library for reading RAW files obtained from digital photo cameras.
21 / 2,037
Active Sound Studio 2020
A versatile software bundle that provides ActiveX controls you can use to add sound recording and editing functionality to other programs
21 / 6,993
DtWinVer 2.68.0.1
Comprehensive operating system detection class to get various information on the OS
23 / 1,478
VintaSoft Imaging .NET SDK 12.4.3.1
Powerful image processing toolkit for .NET developers.
8 / 1,000