Rick, thanks for all your hard work on making this release happen!
-jean
Rick Hillegas wrote:
> The Apache Derby project is pleased to announce a new feature release
> of Derby, 10.2.1.6.
>
> Apache Derby is a subproject of the Apache DB project.
> Derby is a pure Java relational database engine which conforms to the
> ANSI SQL and JDBC standards. Derby aims to be easy for developers
> and end-users to work with.
>
> Derby 10.2.1.6 can be obtained from the Derby download site:
>
> http://db.apache.org/derby/derby_downloads.html.
>
> Derby 10.2.1.6 introduces the following new featues:
>
> * Tools
> o The ij SQL interpreter now has command-line help
> and two new commands: show tables and describe.
> o The ij connect statement now works in the J2ME/CDC environment.
> o Tools can now be invoked without specifying a classpath
> just by typing "java -jar derbyrun.jar <toolName>".
>
> * Security
> o Databases can now be re-encrypted.
> o Secure connections can now be required.
> o Support has been added for DRDA userid/password substitution.
> o SQL Standard GRANT/REVOKE support has been added
> for authenticated users.
>
> * Administration
> o New scripts have been added in the bin directory which
> follow Apache conventions.
> o System tables have been added for access to diagnostic information
> previously available only through non-standard VTIs.
> o Online backup is enhanced to allow updates to the database, during
> backup.
> o Various Net Servlet improvements have been made.
> o The network server now logs startup/shutdown messages
> to the server log file.
>
> * JDBC
> o The network driver now supports statement timeouts.
> o Large object streaming has been improved in the network driver.
> o The FOR UPDATE clause is no longer required when declaring an
> updatable ResultSet.
> o Scrollable, updatable, insensitive ResultSets are now supported.
> o Network client messages have been internationalized.
> o Source-only JDBC 4 drivers are included, based on a proposed final draft
> of JSR-221 and beta build 99 of Java SE 6.
>
> * SQL
> o Expressions are now allowed in the GROUP BY clause.
> o Identity columns can be reset to start at a new value.
> o New XML datatype and operators for storing and querying XML data
> have been introduced, based on SQL/XML 2006.
> o New builtin math functions have been added and wired-in as
> JDBC escape functions.
> o Unary +/- are now allowed for ? parameters.
> o Optimizer overrides have been added.
> o Triggers can now call Java procedures.
> o The nullability of a column can be changed now.
>
> Regards,
> -Rick
>
|