[ANNOUNCE] Apache Derby 10.4.1.3 released

[dy...@apache.org]

The Apache Derby project is pleased to announce a new feature release
of Derby, 10.4.1.3.

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.4.1.3 can be obtained from the Derby download site:

http://db.apache.org/derby/derby_downloads.html.

Derby 10.4.1.3 introduces the following new capabilities:

* Asynchronous Replication 
  Allows you to maintain an up to date copy of your (master) database on
  a different host (the slave).  In the case of a crash on the master
  database you can perform failover to the copy (slave database) and
  continue serving client requests against your database.

* Security
  o Shutting down the Network Server now supports user authentication, 
    and in fact requires credentials when authentication is enabled.

* SQL
  o Table Functions. Using table functions and standard SQL, you can pose
    sophisticated queries against in-memory collections, flat files, web
    resources, non-relational databases, etc.. Table functions also let
    you efficiently import data from web feeds, sensor logs, and other
    relational databases.

  o Unique constraints on nullable columns.

  o SQL ROW_NUMBER() window function, (for an empty, inlined window 
    specification).

  o Bracketed comments (/* ... */).

* Performance and Memory Usage
  o New buffer manager with better concurrency. 

  o Statement cache in the client driver.

  o Caching of isolation level and current schema in the client
    driver.

* Administration
  o Java Management Extensions (JMX) for Derby, allowing
    local and remote monitoring and management of running Derby instances
    (embedded or Network Server).

  o Continuation prompt. ij adds a short "> " prompt to the next line 
    after a newline has been entered by the user without ending the 
    statement with a semicolon.


Derby 10.4.1.3 also has many bugfixes, including the fix for
DERBY-3347 which can cause unrecoverable database corruption.  All
10.3 users are encouraged to upgrade to avoid potential corruption
issues.


Regards,
Dyre