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.
| Tags | Database Database Engines/Servers Java |
|---|---|
| Licenses | MPL |
| Operating Systems | OS Independent |
| Implementation | Java SQL |
Recent releases


Release Notes: This release fixes a bug that could cause indexes on wide columns (columns larger than half the page size) to become corrupt.


Release Notes: The CSV tool has been improved a bit. The update statement now supports limiting the number of rows changed. Compatibility with other databases (PostgreSQL and MySQL) has been improved a bit.


Release Notes: Updating a result set in a trigger is now supported.


Release Notes: Compatibility with other databases has been improved. Creating a Lucene fulltext index is now faster.


Release Notes: Compatibility with the Java 7 file system abstraction has been improved. Large databases (hundreds of GB) are now faster.
Recent comments
13 Feb 2011 13:45
I have been grappling with MySQL for a project and came across this. If it works like it says it does then a pure Java solution will mean no MySQL install is required which is great. Also, I have a need for an in-memory function for data collection so, if I can have two databases one fast (in Memory) and the other backing store (on disk) running at the same time then I will be a hero!