H2 Database Engine download

H2 Database Engine 2.1.214 Build 2022-06-13

Download 1 Screenshots

No review

No Video

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)

H2 Database Engine Download Information

  • License:
    Freeware
  • Platform:
    Windows
  • Publisher:
  • File size:
    6.60 Mb
  • Updated:
    Jun 14, 2022
  • User Rating:
    4.0 / 5 (2 votes)
  • Editors' Review:
    Not yet reviewed
  • Downloads:
    1,473
Similar software
GLPK 4.53
Solve various linear problems with this tool.
37 / 3,845
AccessImagine 1.74
A practical application that lets you efficiently process and store images in your Microsoft Access or SQL database projects
4 / 7,115
PNG reference library 1.6.37
Portable Network Graphics library.
13 / 1,198
BCGControlBar Professional Edition 33.10
MFC extension library for customizable GUI
13 / 1,776
PHP for Windows 7.2.3
The PHP Package
25 / 11,300
GdPicture.NET SDK 14.1.185
A comprehensive Royalty Free Imaging Document Imaging SDK
10 / 1,511