H2 Database Engine for Linux Publisher's description
Welcome to H2, the Java SQL database.
Welcome to H2, the Java SQL database. The main features of H2 are:
Very fast, open source, JDBC API
Embedded and server modes; in-memory databases
Browser based Console application
Small footprint: around 1 MB jar file size
What's New in This Release:В· The following system properties are no longer supported: h2.allowBigDecimalExtensions, h2.emptyPassword, h2.minColumnNameMap, h2.returnLobObjects, h2.webMaxValueLength.
В· When using a VPN, starting a H2 server did not work (for some VPN software).
В· Oracle compatibility: support for DECODE(...).
В· Lucene fulltext search: creating an index is now faster if the table already contains data. Thanks a lot to Angel Leon from the FrostWire Team for the patch!
В· Update statements with a column list in brackets did not work if the list only contains one column. Example: update test set (id)=(id).
В· Read-only databases in a zip file did not work when using the -baseDir option.
В· Issue 334: SimpleResultSet.getString now also works for Clob columns.
В· Subqueries with an aggregate did not always work. Example: select (select count(*) from test where a = t.a and b = 0) from test t group by a
В· Server: in some (theoretical) cases, exceptions while closing the connection were ignored.
В· Server.createTcpServer, createPgServer, createWebServer: invalid arguments are now detected.
В· The selectivity of LOB columns is no longer calculated because indexes on LOB columns are not supported (however this should have little effect on performance, as the selectivity is calculated from the hash code and not the data).
В· New experimental system property "h2.modifyOnWrite": when enabled, the database file is only modified when writing to the database. When enabled, the serialized file lock is much faster for read-only operations.
В· A NullPointerException could occur in TableView.isDeterministic for invalid views.
В· Issue 180: when deserializing objects, the context class loader is used instead of the default class loader if the system property "h2.useThreadContextClassLoader" is set. Thanks a lot to Noah Fontes for the patch!
В· When using the exclusive mode, LOB operations could cause the thread to block. This also affected the CreateCluster tool (when using BLOB or CLOB data).
В· The optimization for "group by" was not working correctly if the group by column was aliased in the select list.
В· Issue 326: improved support for case sensitive (mixed case) identifiers without quotes when using DATABASE_TO_UPPER=FALSE.
System Requirements:В· Java 2 Standard Edition Runtime Environment
Program Release Status: Minor Update
Program Install Support: Install and Uninstall