H2 Database Engine 1.3.176 / 1.4.181 Beta

An SQL database engine written in Java
H2 is an SQL database engine written in Java (but also available as a native binary). JDBC and ODBC APIs are supported.

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

H2 Database Engine is a web based java database engine.

Main 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).

last updated on:
August 9th, 2014, 10:44 GMT
file size:
7.8 MB
price:
FREE!
developed by:
H2
license type:
Freeware
operating system(s):
Mac OS X
binary format:
-
category:
Home \ Development \ Java

FREE!

In a hurry? Add it to your Download Basket!

user rating 18

2.8/5
 

0/5

3 Screenshots
H2 Database EngineH2 Database EngineH2 Database Engine
What's New in version 1.4.181 Beta
  • Improved MySQL compatibility by supporting "use schema". Thanks a lot to Karl Pietrzak for the patch!
  • Writing to the trace file is now faster, specially with the debug level.
  • The database option "defrag_always=true" did not work with the MVStore.
  • The JDBC escape syntax {ts 'value'} did not interpret the value as a timestamp. The same for {d 'value'} (for date) and {t 'value'} (for time). Thanks to Lukas Eder for reporting the issue.
read full changelog

Add your review!

SUBMIT