Hello,
A new version of H2 is available for download at http://www.h2database.com
(you may have to click 'refresh').
Changes and new functionality:
- Row level locking for MVCC is now enabled.
- Multiple processes can now access the same database by appending
;AUTO_SERVER=TRUE to the database URL.
- The database supports the SHOW command for better MySQL and
PostgreSQL compatibility.
- Result sets with just a unique index can now be updated.
- Linked tables can now share the connection.
- Linked tables can now be read-only.
- Linked tables: the schema name can now be set.
- Linked tables: worked around a bug in Oracle with the CHAR data type.
- Temporary linked tables are now supported.
- Faster storage re-use algorithm thanks to Greg Dhuse from cleversafe.com.
- Faster hash code calculation for large binary arrays.
- Multi-Version Concurrency may no longer be used when using
the multi-threaded kernel feature.
- The H2 Console now abbreviates large texts in results.
- SET SCHEMA_SEARCH_PATH is now documented.
- Can now start a TCP server with port 0 (automatically select a port).
- The server tool now displays the correct IP address if networked.
Bugfixes:
- Multiple UNION queries could not be used in derived tables.
- It was possible to create tables in read-only databases.
- SET SCHEMA did not work for views.
- The maximum log file size setting was ignored for large databases.
- The data type JAVA_OBJECT could not be used in updatable result sets.
- The system property h2.optimizeInJoin did not work correctly.
- Conditions such as ID=? AND ID>? were slow.
For details, see the 'Change Log' at
http://www.h2database.com/html/changelog.html
For future plans, see the 'Roadmap' page at
http://www.h2database.com/html/roadmap.html
Have fun,
Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
