H2 is an SQL database engine written in Java that implements the JDBC API. Embedded, server, and clustering modes are available. A browser based console application is included. The database has strong security features. Disk based and in-memory databases and tables are supported.


The parameter meta data now returns the right data type for most cases. A new column for getting the unique index name of a constraint was added to the information schema. Some SET statements no longer commit a transaction. The SYSTEM_RANGE table now supports parameters. Compatibility with PostgreSQL and MySQL was improved. Negative scale values, infinite values, and NaN (not a number) are now supported. The full-text search now supports CLOB. A security risk when passing the password as a character array was fixed.

URL: H2 Database Engine