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.
What's New in This Release:
· Issue 407: The TriggerAdapter didn't work with CLOB and BLOB columns.
· PostgreSQL compatibility: support for data types BIGSERIAL and SERIAL as an alias for AUTO_INCREMENT.
· Issue 417: H2 Console: the web session timeout didn't work, resulting in a memory leak. This was only a problem if the H2 Console was run for a long time and many sessions were opened.
· Issue 412: Running the Server tool with just the option "-browser" will now log a warning.
· Issue 411: CloseWatcher registration was not concurrency-safe.
· MySQL compatibility: support for CONCAT_WS. Thanks a lot to litailang for the patch!
· PostgreSQL compatibility: support for EXTRACT(WEEK FROM dateColumn). Thanks to Prashant Bhat for the patch!
· Fix for a bug where we would sometimes use the wrong unique constraint to validate foreign key constraints.
· Support BOM at the beginning of files for the RUNSCRIPT command
· Fix in calling SET @X = IDENTITY() where it would return NULL incorrectly
· Fix ABBA deadlock between ad...