About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Freeware
  • Last update: 5 years ago
  • Total downloads: 181
  • Price: Free |
  • Operating system: Linux
  • Publisher: H2 (2 other programs)
See full specifications

linux default iconH2 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

H2 Database Engine for Linux Tags:

Click on a tag to find related softwares

Is H2 Database Engine for Linux your software?

Manage your software

Most Popular

linux default icon A2Billing 1.6.0
A2Billing is a billing system interactive with Asterisk to give any Telecom company traditional offering VOIP... Read more
linux default icon FrontAccounting 2.3.10
FrontAccounting is free and released under the GNU General Public License.
linux default icon PgAdmin III for Linux 1.14.1
pgAdmin is the most popular and feature rich Open Source administration and development platform for... Read more
linux default icon RazorSQL for Linux 5.6.3
RazorSQL is an SQL query tool, database browser, SQL editor,....
linux default icon Salat Book 1.00
Salat / Namaz prayer database and tracking application