H2 Database Engine
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
- 27 Jun 2009 09:41
Changes: The new storage mechanism is now alpha quality. java.util.UUID is now supported. The Polish translation has been improved. The fulltext search has been improved.
- 02 Jun 2009 08:38
Changes: Java 1.5 is now required. Updating the full-text search is now faster. A bug in the b-tree was fixed. The recovery tool now works when using referential integrity. The installation on Windows Vista has been improved.
- 21 May 2009 18:39
Changes: A second level soft-references cache is now supported. Compatibility with MS SQL Server has been improved: linked tables with NVARCHAR and similar are now supported. When using Android, read-only databases in zip files should now work. When deleting or updating many rows in a table, the space in the index file was not re-used. This is the last version compiled against Java 1.4; the next version will use Java 1.5.
- 02 May 2009 11:19
Changes: A file system implementation can now be registered (to simplify using the Google App Engine). MERGE now returns 0 as the generated on update. The EclipseLink platform was improved. The login timeout of the connection pool is now 5 minutes.
- 10 Apr 2009 11:08
Changes: In-memory databases can now run inside the Google App Engine. The Shell tool no longer truncates results with only one column. Queries that are ordered by an indexed column returned no rows in certain cases. The wrong exception was thrown when using unquoted text for some SQL statements. The built-in connection pool did not roll back transactions and enable autocommit after closing a connection. Sometimes, a StackOverflow occurred when checking for deadlock.
