H2 Database Engine 1.2.147 /
This page displays all H2 Database Engine 1.2.147 / versions from Softpedia
Soft85 only provide legal software, please help us keeping pur site legal, if you think this page is violating copyrights please let us know by clicking here Here
All H2 Database Engine 1.2.147 / versions from Softpedia sources and versions
H2 Database Engine 1.2.147 /
H2 Database Engine 1.2.147 / Description
- H2 Database Engine is an open source and free graphical software written in the Java programming language and providing a very fast JDBC API, featuring a browser based console that leaves a very small footprint, around 1.5 MB.H2 Database Engine also comes with an embedded mode (in-memory databases), which is faster than the client-server mode. The software features support for encrypted database, ODBC driver, full-text search, and multi version concurrency.Being written in Java, H2 Database Engine is a platform-independent software that supports Linux, Microsoft Windows and other POSIX operating systems where Java is installed. Requirements:Java 2 Standard Edition Runtime Environment What's New in This Release: [ read full changelog ]EXPLAIN was incorrect for queries with"ANY"or"SOME"conditions.CallableStatement with"out"parameters: running the same statement twice could result in an exception ("parameter not set").Union queries: duplicate rows could be returned if the sub-queries contained"order by".The GEOMETRY data type now works for user defined functions that return a result set.PostgreSQL compatibility: the PgServer was not working properly when the setting database_to_upper was set to false.JdbcDataSource: the methods setUrl and getUrl where added as aliases for setURL and getURL. This should solve problems with the HikariCP (Hikari connection pool).Issue 537: H2 Console: when loading the schema, incorrect JDBC calls where issued, which caused the exception"Column PRECISION not found".Improved Geometry processing (issue 535).The collation can now be set in the database URL, even if there are data tables, if the collection is the same as the current collation.Improved Oracle compatibility f... �.You can free download H2 Database Engine 1.2.147 / from Softpedia now.
H2 Database Engine 1.2.147 /
H2 Database Engine 1.2.147 / Description
- H2 Database Engine is based on the open source, JDBC API, it features a browser based console application an leaves a very small footprint, at 1MB.H2 also comes with an embedded mode which is faster than the client-server mode.Product's homepage Requirements: · Java 2 Standard Edition Runtime Environment What's New in This Release: [ read full changelog ] · This version improves MySQL and PostgreSQL compatibility, improves the MVStore storage engine, and adds the new data type"geometry"for spatial data. �.You can free download H2 Database Engine 1.2.147 / from Softpedia now.
H2 Database Engine 1.2.147 /
H2 Database Engine 1.2.147 / Description
- H2 Database Engine is based on the open source, JDBC API, it features a browser based console application an leaves a very small footprint, at 1MB.H2 also comes with an embedded mode which is faster than the client-server mode.Product's homepage Requirements: · Java 2 Standard Edition Runtime Environment What's New in This Release: [ read full changelog ] · Security: the TCP server did not correctly restrict access rights of clients in some cases. This was specially a problem when using the flag"tcpAllowOthers". · H2 Console: the session timeout can now be configured using the system property"h2.consoleTimeout". · Issue 431: Improved compatibility with MySQL: support for"ENGINE=InnoDB charset=UTF8"when creating a table. · Issue 249: Improved compatibility with MySQL in the MySQL mode: now the methods DatabaseMetaData methods stores*Case*Identifiers return the same as MySQL when using the MySQL mode. · Issue 434: H2 Console didn't work in the Chrome browser due to a wrong viewport argument. · There was a possibility that the .lock.db file was not deleted when the database was closed, which could slow down opening the database. · The SQL script generated by the"script"command contained inconsistent newlines on Windows. · When using trace level 4 (SLF4J) in the server mode, a directory"trace.db"and an empty file was created on the client side. This is no longer made. · Optimize IN(...) queries: there was a bug in version 1.3.170 if the type of the left hand side didn't match the type of the right hand side. Fixed. · Optimize IN(...) queries: there was a bug in version 1.3.170 for comparison of the type"X IN(NULL, NULL)". Fixed. · Timestamps with timezone that were passed as a string were not always converted correctly. For example"2012-11-06T23:00:00.000Z"was converted to"2012-11-06"instead of to"2012-11-07"in the timezone CET. Thanks a lot to Steve Hruda for reporting the problem! · New table engine"org.h2.mvstore.db.MVTableEngine"that internally uses the MVStore to persist data. To try it out, append";DEFAULT_TABLE_ENGINE=org.h2.mvstore.db.MVTableEngine"to the database URL. This is still very experimental, and many features are not supported yet. The data is stored in a file with the suffix".mv.db". · New connection setting"DEFAULT_TABLE_ENGINE"to use a specific table engine if none is set explicitly. This is to simplify testing the MVStore table engine. · MVStore: encrypted stores are now supported. Only standardized algorithms are used: PBKDF2, SHA-256, XTS-AES, AES-128. · MVStore: improved API thanks to Simo Tripodi. · MVStore: maps can now be renamed. · MVStore: store the file header also at the end of each chunk, which results in a further reduced number of write operations. · MVStore: a map implementation that supports concurrent operations. · MVStore: unified exception handling; the version is included in the messages. · MVStore: old data is now retained for 45 seconds by default. · MVStore: compress is now disabled by default, and can be enabled on request. · Support ALTER TABLE ADD ... AFTER. Patch from Andrew Gaul (argaul at gmail.com). Fixes issue 401. · Improved OSGi support. H2 now registers itself as a DataSourceFactory service. Fixes issue 365. · Add a DISK_SPACE_USED system function. Fixes issue 270. · Fix a compile-time ambiguity when compiling with JDK7, thanks to a patch from Lukas Eder. · Supporting dropping an index for Lucene full-text indexes. · Optimized performance for SELECT ... ORDER BY X LIMIT Y OFFSET Z queries for in-memory databases using partial sort (by Sergi Vladykin). · Experimental off-heap memory storage engine"nioMemFS:"and"nioMemLZF:", suggestion from Mark Addleman. · Issue 438: JdbcDatabaseMetaData.getSchemas() is no longer supported as of 1.3.169. · MySQL compatibility: support for ALTER TABLE tableName MODIFY [COLUMN] columnName columnDef. Patch from Ville Koskela. · Issue 404: SHOW COLUMNS FROM tableName does not work with ALLOW_LITERALS=NUMBERS. · Throw an explicit error to make it clear we don't support the TRIGGER combination of SELECT and FOR EACH ROW. · Issue 439: Utils.sortTopN does not handle single-element arrays. �.You can free download H2 Database Engine 1.2.147 / from Softpedia now.