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: - OSGi meta data is included in the manifest file. - Queries with more than 10 tables are now faster. - Opening large database is now faster. - Opening a connection with AUTO_SERVER=TRUE is now fast. - There is now a default timeout of 2 seconds to connect to a server. - Improved Glassfish / Toplink support in H2Platform. - New functions ISO_YEAR, ISO_WEEK, ISO_DAY_OF_WEEK. - IF [NOT] EXISTS is supported for named constraints. - The methods getTableName() and getColumnName() now return the real names. - In SQL scripts created with SCRIPT TO, schemas are now only created if they don't exist yet. - Local temporary tables now support indexes. - RUNSCRIPT no longer uses a temporary file. - New system table INFORMATION_SCHEMA.SESSION_STATE. - After an automatic re-connect, part of the session state stays. - After re-connecting to a database, the database event listener (if set) is informed about it. - New system property h2.maxReconnect (default 3). - The error messages have been translated to Spanish by Dario V. Fassi. - The date functions DAYOF... are now called DAY_OF_... (the old names still work). - Linked tables: compatibility with MS SQL Server has been improved. - The default value for MAX_MEMORY_UNDO is now 50000. - Fulltext search: new method FT_DROP_INDEX. Bugfixes: - Linked tables: the automatic connection sharing didn't work. - The wrong parameters were bound to subqueries with parameters. - Unset parameters were not detected when the query was re-compiled. - An out of memory error could result in a strange exception. - Renaming tables that have foreign keys didn't work. - Auto-reconnect didn't work when using auto-server. - The optimization to group using an index didn't work sometimes. - The build didn't work if the directory temp didn't exist before. - WHERE .. IN (SELECT ...) could throw a NullPointerException. 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 -~----------~----~----~----~------~----~------~--~---
