The Apache Derby project is pleased to announce feature release 10.11.1.1. Apache Derby is a subproject of the Apache DB project. Derby is a pure Java relational database engine which conforms to the ISO/ANSI SQL and JDBC standards. Derby aims to be easy for developers and end-users to work with.
Derby 10.11.1.1 can be obtained from the Derby download site: http://db.apache.org/derby/derby_downloads.html. Derby 10.11.1.1 contains the following new features: * MERGE statement - MERGE is a single, join-driven statement which INSERTs, UPDATEs, and DELETEs rows. * Deferrable constraints - Constraint enforcement can now be deferred, typically to the end of a transaction. * WHEN clause in CREATE TRIGGER - An optional WHEN clause has been added which determines which rows fire a trigger. * Rolling log file - The Derby diagnostic log can now be split across a sequence of files. * Experimental Lucene support - Derby text columns can now be indexed and queried via Apache Lucene. * Simple case expression - The "simple" and "extended" syntax for CASE expressions has been added. * Better concurrency for identity columns - The concurrency of identity columns has been boosted. * New ij HoldForConnection command - A new ij command has been added to change the default cursor holdability. * Standard syntax for altering column nullability - Standard syntax has been added for altering the nullability of columns. In addition, Derby 10.11.1.1 contains many bug, security, and documentation fixes. Please try out this new release.
