Thomas, I just tried the new version with;
jdbc:h2:file:/mydb/ db;IGNORECASE=TRUE;MODE=Oracle;FILE_LOCK=NO;AUTO_SERVER=TRUE
and I get errors with "function not implemented"...... ? Kind Regards, Nitai On Sep 26, 2008, at 3:49 PM, Thomas Mueller wrote:
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 -~----------~----~----~----~------~----~------~--~---
-- Roozani - memorize everywhere http://www.roozani.com/Razuna - Open Source Digital Asset Management with Web Content Management
http://www.razuna.com/ SixSigns - Enrich people’s lives and web experience http://www.sixsigns.com http://blog.sixsigns.com
smime.p7s
Description: S/MIME cryptographic signature
