H2 Database Engine Portable is an advanced application designed for SQL users. JDBC and ODBC APIs are supported.
Embedded and server modes are available. A Web console application is included. Clustering is supported.
· Very fast database engine
· Open source
· Written in Java
· Supports standard SQL, JDBC API
· Embedded and Server mode, Clustering support
· Strong security features
· The PostgreSQL ODBC driver can be used
· Multi version concurrency
What's New in This Release:
· Issue 294: The Maven source bundle now contains a manifest file that allows Eclipse to automatically attach the source code (if Maven is used).
· A query with an explicit LIMIT 0 will now return no rows (so far it meant no limit), which is compatible with PostgreSQL and MySQL. A negative limit value, (as well as LIMIT NULL) mean no limit (so far a negative limit meant a limit of one row). There were similar problems with OFFSET.
· A new encrypting file system has been implemented. The idea is to allow encrypting all files, not just database files. Also implemented is a simple file system shell tool. At some point, this might replace the Backup, ChangeFileEncryption, DeleteDbFiles, and Restore tools.
· Lob in database: storing lob objects was not correctly synchronized. This was specially a problem when using Connection.createBlob() / createClob().
· Updated the license page (thanks a lot to Abe to help me with this).
· Support for database paths with '' on non-Windows systems. ...