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:
· Support empty statements that just contains a comment.
· Server mode: if there was an error while reading from a LOB, the session was closed in some cases.
· Issue 463: Driver name and version are now the same in OsgiDataSourceFactory and JdbcDatabaseMetaData.
· JaQu: The data type VARCHAR is now (again) used for Strings (no longer TEXT, except when explicitly set).
· For in-memory databases, creating an index on a CLOB or BLOB column is no longer supported. This is to simplify the MVTableEngine.
· New column "information_schema.tables.row_count_estimate".
· Issue 468: trunc(timestamp) could return the wrong value (+12 hours), and trunc(number) throw a NullPointerException.
· The expression trunc(number) threw a NullPointerException.
· Fixed a deadlock when updating LOB's concurrently. See TestLob.testDeadlock2().
· Fixed a deadlock related to very large temporary result sets.
· Add "-list" command line option to Shell tool so that result-list-mode can be triggered when reading from a file.
· Issue 474: H...