By kah on Apr 18, 2013
The Derby community voted to approve Apache Derby 10.10.1.1 earlier this week, and now it has been released. Get it from http://db.apache.org/derby/derby_downloads.html and try it out for yourself!
This release contains a number of new features, as well as bug fixes and other improvements. Here are the headlights from the release announcement:
- JDBC 4.2 - Derby supports the Java 8 enhancements to JDBC.
- Small device profile - Derby runs on the small CP2 profile of Java 8. See the corresponding JEP at http://openjdk.java.net/jeps/161
- User-defined aggregates - Applications can create their own aggregate operators. See the "CREATE DERBY AGGREGATE" section in the Derby Reference Manual.
- Varargs routines - SQL routines can be bound to user-written Java methods which have variable length argument lists.
- Optional tools - Derby has new, optional tools to support data migration and metadata queries. See the "Optional tools" section in the Derby Tools and Utilities Guide.
- SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS - Derby has a new system procedure for invalidating stored prepared statements when you think that your metadata queries or triggers are misbehaving--for example if they throw a NoSuchMethodError on execution. See the section on this new system procedure in the Derby Reference Manual.
- Faster query compilation - A number of changes have made SQL compilation faster.
- Unencrypting databases - Encryption can be turned off on existing databases. See the section on the decryptDatabase attribute in the Derby Reference Manual.