H2 Database Engine 1.4.182 Beta

An open source Java SQL database (JDBC API) that supports Linux, Windows and Mac

  Add it to your Download Basket!

 Add it to your Watch List!


Rate it!

What's new in H2 Database Engine 1.3.175:

  • EXPLAIN was incorrect for queries with "ANY" or "SOME" conditions.
  • CallableStatement with "out" parameters: running the same statement twice could result in an exception ("parameter not set").
  • Union queries: duplicate rows could be returned if the sub-queries contained "order by".
  • The GEOMETRY data type now works for user defined functions that return a result set.
Read full changelog
send us
an update
Eclipse Public License 
3.5/5 26
ROOT \ Database \ Database Engines
3 H2 Database Engine Screenshots:
H2 Database EngineH2 Database EngineH2 Database Engine
H2 Database Engine is an open source, multiplatform and free graphical software implemented in Java and designed to provide users with a very fast JDBC API that features a browser-based console and leaves a very small footprint (around 1 MB).

The application comes with an embedded mode (in-memory databases), which is faster than the client-server mode. It also features support for encrypted databases, an ODBC (Open Database Connectivity) driver, full-text search, as well as multi version concurrency.

Features at a glance

Key features include a very fast database engine, support for standard SQL and JDBC API, clustering support, powerful security options, support for the PostgreSQL ODBC driver, in-memory tables, in-memory databases, disk-based databases, disk-based tables, temporary tables, support for read-only databases, transaction support and table level locking.

In addition, the software features 2-phase-commit support, cost-based optimizer, support for multiple connections, support for result sets that are updatable and scrollable, support for external result sorting, support for large result sets, support for AES (Advanced Encryption Standard) encrypted databases, SSL (Secure Socket Layer) support, as well as support for SHA-256 encrypted passwords.

Among other features worth mentioning, we can easily name support for information schema and multiple schemas, collation support, support for roles and users, lossless data compression, outer and inner joins, inline views, read-only views, subqueries, referential integrity, check constraints, autoincrement columns, computed columns and sequence columns.

Supported database servers

Currently, H2 Database Engine is fully compatible with the well known MySQL, PostgreSQL, IBM DB2, Apache Derby, Microsoft SQL Server, Oracle and HSQLDB database servers/engines.

Under the hood and supported operating systems

Being written in the Java programming language, the H2 Database Engine project is platform-independent and supports any operating system where the Java Runtime Environment (JRE) is available, including GNU/Linux, Microsoft Windows, Mac OS X, Solaris and BSD.

H2 Database Engine was reviewed by , last updated on November 11th, 2014


#database engine #SQL database #database API #H2 #database #engine #SQL

Add your review!