You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@db.apache.org by rh...@apache.org on 2012/12/19 19:20:28 UTC
svn commit: r843115 [29/44] - in /websites/production/db/content/derby: ./
binaries/ blogs/ blogs/images/ dev/ docs/ images/ integrate/
integrate/plugin_help/ integrate/plugin_help/images/ logo/ manuals/ papers/
papers/DerbyTut/ releases/ skin/ skin/cs...
Added: websites/production/db/content/derby/releases/release-10.1.3.1.html
==============================================================================
--- websites/production/db/content/derby/releases/release-10.1.3.1.html (added)
+++ websites/production/db/content/derby/releases/release-10.1.3.1.html Wed Dec 19 18:20:21 2012
@@ -0,0 +1,666 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.8">
+<meta name="Forrest-skin-name" content="pelt">
+<meta name="generator" content="">
+<title>Apache Derby 10.1.3.1 Release</title>
+<link type="text/css" href="../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../skin/screen.css" rel="stylesheet">
+<link media="print" type="text/css" href="../skin/print.css" rel="stylesheet">
+<link type="text/css" href="../skin/profile.css" rel="stylesheet">
+<script src="../skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="../skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="../skin/fontsize.js" language="javascript" type="text/javascript"></script>
+<link rel="shortcut icon" href="../">
+</head>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+ |breadtrail
+ +-->
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> > <a href="http://db.apache.org/">db</a><script src="../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<!--+
+ |header
+ +-->
+<div class="header">
+<!--+
+ |start group logo
+ +-->
+<div class="grouplogo">
+<a href="http://db.apache.org/derby"><img class="logoImage" alt="Apache Derby" src="../images/derby-logo-web.png" title="Derby is a zero-admin Java RDBMS"></a>
+</div>
+<!--+
+ |end group logo
+ +-->
+<!--+
+ |start Project Logo
+ +-->
+<div class="projectlogoA1">
+<a href="http://db.apache.org"><img class="logoImage" alt="Apache DB Project" src="../images/db-logo-white.png" title="Apache DB creates and maintains database solutions."></a>
+</div>
+<!--+
+ |end Project Logo
+ +-->
+<!--+
+ |start Tabs
+ +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../quick_start.html">Quick Start</a>
+</li>
+<li class="current">
+<a class="selected" href="../derby_downloads.html">Download</a>
+</li>
+<li>
+<a class="unselected" href="../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="unselected" href="../manuals/index.html">Documentation</a>
+</li>
+<li>
+<a class="unselected" href="../blogs/index.html">Resources</a>
+</li>
+</ul>
+<!--+
+ |end Tabs
+ +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+ |start Subtabs
+ +-->
+<div id="level2tabs"></div>
+<!--+
+ |end Endtabs
+ +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+// --></script>
+</div>
+<!--+
+ |breadtrail
+ +-->
+<div class="breadtrail">
+
+
+ </div>
+<!--+
+ |start Menu, mainarea
+ +-->
+<!--+
+ |start Menu
+ +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../skin/')" id="menu_1.1Title" class="menutitle">Download</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../derby_downloads.html">Overview</a>
+</div>
+</div>
+<!--+
+ |start Search
+ +-->
+<div class="searchbox">
+<hr>
+<form action="http://www.google.com/search" method="get">
+<input value="db.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="18" name="q" id="query" type="text" value="Search the site with google">
+ <input name="Search" value="Search" type="submit">
+</form>
+</div>
+<!--+
+ |end search
+ +-->
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" src="../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+ |alternative credits
+ +-->
+<div id="credit2"></div>
+</div>
+<!--+
+ |end Menu
+ +-->
+<!--+
+ |start content
+ +-->
+<div id="content">
+<div class="trail">Font size:
+ <input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">
+ <input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+ <input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Apache Derby 10.1.3.1 Release</h1>
+<div id="minitoc-area">
+<ul class="minitoc">
+<li>
+<a href="#Distributions">Distributions</a>
+</li>
+<li>
+<a href="#Release+Overview">Release Overview</a>
+</li>
+<li>
+<a href="#Release+Notes">Release Notes</a>
+<ul class="minitoc">
+<li>
+<a href="#Bugs+Fixed">Bugs Fixed</a>
+</li>
+<li>
+<a href="#Improvements">Improvements</a>
+</li>
+<li>
+<a href="#">DERBY-283</a>
+</li>
+<li>
+<a href="#-N103D0">DERBY-526</a>
+</li>
+<li>
+<a href="#-N103FA">DERBY-1327</a>
+</li>
+<li>
+<a href="#-N10434">DERBY-541</a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#Testing">Testing</a>
+</li>
+<li>
+<a href="#Verifying+releases">Verifying releases</a>
+</li>
+</ul>
+</div>
+<a name="N10010"></a><a name="Distributions"></a>
+<h2 class="boxed">Distributions</h2>
+<div class="section">
+<p>Use the links below to download a distribution of Apache Derby from the archives. You should <strong>always</strong> <a href="#Verifying+releases">verify the integrity</a> of distribution files downloaded from a mirror.</p>
+<p>There are four different distributions:</p>
+<ul>
+<li>bin distribution - contains the documentation, javadoc, and jar files for Derby.</li>
+<li>lib distribution - contains only the jar files for Derby.</li>
+<li>lib-debug distribution - contains jar files for Derby with source line numbers.</li>
+<li>src distribution - contains the Derby source tree at the point which the binaries were built.</li>
+</ul>
+<p>
+<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-bin.zip">db-derby-10.1.3.1-bin.zip</a> [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-bin.zip.asc">PGP</a>] [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-bin.zip.md5">MD5</a>]<br>
+<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-bin.tar.gz">db-derby-10.1.3.1-bin.tar.gz</a> [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-bin.tar.gz.asc">PGP</a>] [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-bin.tar.gz.md5">MD5</a>]</p>
+<p>
+<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib.zip">db-derby-10.1.3.1-lib.zip</a> [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib.zip.asc">PGP</a>] [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib.zip.md5">MD5</a>]<br>
+<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib.tar.gz">db-derby-10.1.3.1-lib.tar.gz</a> [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib.tar.gz.asc">PGP</a>] [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib.tar.gz.md5">MD5</a>]</p>
+<p>
+<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib-debug.zip">db-derby-10.1.3.1-lib-debug.zip</a> [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib-debug.zip.asc">PGP</a>] [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib-debug.zip.md5">MD5</a>]<br>
+<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib-debug.tar.gz">db-derby-10.1.3.1-lib-debug.tar.gz</a> [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib-debug.tar.gz.asc">PGP</a>] [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-lib-debug.tar.gz.md5">MD5</a>]</p>
+<p>
+<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-src.zip">db-derby-10.1.3.1-src.zip</a> [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-src.zip.asc">PGP</a>] [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-src.zip.md5">MD5</a>]<br>
+<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-src.tar.gz">db-derby-10.1.3.1-src.tar.gz</a> [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-src.tar.gz.asc">PGP</a>] [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/db-derby-10.1.3.1-src.tar.gz.md5">MD5</a>]</p>
+<p>There are two separate Eclipse plugins for Derby:</p>
+<ul>
+<li>derby_core_plugin - provides the Derby jar files to other plugins in Eclipse.</li>
+<li>derby_ui_plugin - provides an Apache Derby Nature in Eclipse for easy database application development.</li>
+</ul>
+<p>
+<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/derby_core_plugin_10.1.3.zip">derby_core_plugin_10.1.3.zip</a> [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/derby_core_plugin_10.1.3.zip.asc">PGP</a>] [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/derby_core_plugin_10.1.3.zip.md5">MD5</a>]<br>
+<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/derby_ui_plugin_1.1.0.zip">derby_ui_plugin_1.1.0.zip</a> [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/derby_ui_plugin_1.1.0.zip.asc">PGP</a>] [<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.3.1/derby_ui_plugin_1.1.0.zip.md5">MD5</a>]</p>
+<p>Please note: both plugins must be installed for full functionality. For information on installing and using the Derby plugins for Eclipse, please see the <a href="http://db.apache.org/derby/integrate/plugin_howto.html">Using the 10.1 Core and 1.1 UI Derby plug-ins</a> page.</p>
+</div>
+<a name="N100BC"></a><a name="Release+Overview"></a>
+<h2 class="boxed">Release Overview</h2>
+<div class="section">
+<p>Derby is a pure Java relational database engine using standard SQL and JDBC as its APIs. 10.1.3.1 is a bug fix release providing quality improvements for Derby 10.1</p>
+<p>What's new in 10.1.3.1:</p>
+<ul>
+<li>Critical fixes for network client when used with a transaction manager (XA)</li>
+<li>A critical data integrity fix when running in IBM J2RE 1.5.0 SR2. See the description of DERBY-1327 below.</li>
+<li>Improved Network Server stability and reliability</li>
+<li>Improved memory usage for the Network Client</li>
+<li>Improved query performance for UNION queries and subqueries</li>
+<li>Better handling of text encoding on systems with non-ASCII native encoding</li>
+<li>More reliable behavior of scrollable insensitive result sets</li>
+<li>Updated documentation</li>
+<li>A new distribution that includes line number information, lib-debug, has been added to assist in filing and tracking down Derby issues</li>
+<li>Many important fixes to correct issues with data integrity, correct memory leaks and address other product defects</li>
+</ul>
+<p>For a comprehensive list of changes, consult the <a href="#Bugs+Fixed">list of fixed issues</a> below.</p>
+<p>10.1.3.1 functionality includes:</p>
+<ul>
+<li>Embedded engine with JDBC driver</li>
+<li>Network Server</li>
+<li>Network client JDBC driver</li>
+<li>Command line tools: ij (SQL scripting), dblook (schema dump) and sysinfo (system info)</li>
+</ul>
+<p>SQL support:</p>
+<ul>
+<li>Schemas, tables, temporary tables, views, triggers, indexes, savepoints</li>
+<li>Java procedures and functions</li>
+<li>Standard datatypes including BLOB and CLOB</li>
+<li>Sub-queries and joins</li>
+<li>Primary key, foreign key, unique and check constraints</li>
+<li>Referential actions</li>
+</ul>
+<p>Other features:</p>
+<ul>
+<li>Full ACID transaction support with all four isolation levels</li>
+<li>Row and table level locking</li>
+<li>Configurable authentication including LDAP support</li>
+<li>Import/Export</li>
+<li>On-line backup and recovery support</li>
+<li>Optional on-disk encryption</li>
+<li>Platform independent database format</li>
+<li>Full support for Java 2 Security Manager</li>
+</ul>
+<p>JDK/JDBC support:</p>
+<ul>
+<li>JDK 1.3, 1.4, 1.5, and J2ME J2ME/CDC/Foundation Profile</li>
+<li>JSR-169, JDBC 2.1, and JDBC 3.0 support</li>
+</ul>
+</div>
+<a name="N10113"></a><a name="Release+Notes"></a>
+<h2 class="boxed">Release Notes</h2>
+<div class="section">
+<p>Derby version 10.1.3.1 is a bug fix release based on Apache Derby <a href="http://db.apache.org/derby/releases/release-10.1.2.1.html">10.1.2.1.</a>
+</p>
+<p>The following reported JIRA issues were fixed in the 10.1.3.1 release:</p>
+<a name="N1011E"></a><a name="Bugs+Fixed"></a>
+<h3 class="boxed">Bugs Fixed</h3>
+<ul>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-7">DERBY-7</a>] - Bug in NULLIF Function</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-76">DERBY-76</a>] - Stored procedure cannot be invoked with VALUES statement</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-85">DERBY-85</a>] - NPE when creating a trigger on a table and default schema doesn't exist.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-125">DERBY-125</a>] - Network Server can send DSS greater than 32K to client, which breaks DRDA protocol.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-170">DERBY-170</a>] - Inserting large string value into non-existent table causes communication link failure over Network Server.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-298">DERBY-298</a>] - rollforward will not work correctly if the system happens to crash immediately after rollforward backup.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-324">DERBY-324</a>] - AES encryption test fails on Solaris 10</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-331">DERBY-331</a>] - create table fails when a constraint defintion follows a column default</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-387">DERBY-387</a>] - SimpleNetworkClientSample.java network server example has an error which causes it to fail</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-395">DERBY-395</a>] - Server-side "trace on" and "trace off" commands do not appear to be working correctly.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-405">DERBY-405</a>] - SYNONYM should not be allowed in SESSION schema because that can confusion wih temporary tables</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-437">DERBY-437</a>] - SYSCS_UTIL.SYSCS_COMPRESS_TABLE does not work on tables that are created with delimited identifier names.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-463">DERBY-463</a>] - Successive writes to a java.sql.Blob.setBinaryStream(long) seem to reset the file pointer</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-466">DERBY-466</a>] - Distinct in subselect can return wrong results</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-491">DERBY-491</a>] -Protocol exception when Network Server tries to return ~32K of data or greater in a result set for a Java stored procedure.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-575">DERBY-575</a>] - test blobclob4BLOB fails on OS 390</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-583">DERBY-583</a>] - networkserver does not return error message strings in native encoding to ij on zseries</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-614">DERBY-614</a>] - Execution failed because of a Distributed Protocol Error</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-616">DERBY-616</a>] - create index can fail under the SecurityManager when trying to access files in the tmp folder of a database</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-618">DERBY-618</a>] - Make the client driver connection URL work when spaces are in the URL.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-628">DERBY-628</a>] - setNull() using Types.VARCHAR for a CLOB parameter fails in embedded mode.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-649">DERBY-649</a>] - Useful indexes not used in UNION ALL</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-650">DERBY-650</a>] - Hyperlinks in demo/demo.html are broken</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-652">DERBY-652</a>] - Documentation and demos have incubator references</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-657">DERBY-657</a>] - Release archives should have executable bits set for scripts and text files should have proper line endings.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-658">DERBY-658</a>] - test harness improvements required for running on non-ASCII systems</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-678">DERBY-678</a>] - derby documentation does not reflect changes to update lock behavior</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-679">DERBY-679</a>] - the lock compatibility table in developers guide needs to be updated</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-683">DERBY-683</a>] - Use correct encoding for ClobOutputStream on client</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-701">DERBY-701</a>] - Java 2 security policy file examples don't work -- are missing a needed line</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-704">DERBY-704</a>] - Large page cache kills initial performance</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-715">DERBY-715</a>] - lock deadlocks sometimes reported as lock timeouts</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-736">DERBY-736</a>] - "" does not work as a userid for Derby client (SqlException: userid length, 0, is not allowed.)</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-741">DERBY-741</a>] - row estimates from btree code can sometimes return more row than exist in table</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-746">DERBY-746</a>] - NullPointerException when 'encryptionKey' length is an odd number, or it contains invalid chars</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-757">DERBY-757</a>] - java.lang.NullPointerException can occur while scanning for global id in the transaction table under heavey load.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-758">DERBY-758</a>] - CachedPage.readPage() can loop forever on insane builds if the read from the container keep failing with IO Exceptions.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-777">DERBY-777</a>] - Hang in starting network server on Z/OS</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-788">DERBY-788</a>] - 'store/encryptionKey.sql' fails on Solaris 10</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-795">DERBY-795</a>] - After calling ResultSet.relative(0) the cursor loses its position</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-798">DERBY-798</a>] - NullPointerException booting if loaded by the bootstrap class loader and JVM returns null for bootstrap loader.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-800">DERBY-800</a>] - derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-805">DERBY-805</a>] -Push join predicates into union and other set operations. DERBY-649 implemented scalar (single table) predicate pushdown. Adding join predicate push down could improve performance significantly.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-808">DERBY-808</a>] - PreparedStatements can take longer to execute than equivalent Statements when there are multiple join conditions mixed with some search clauses.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-877">DERBY-877</a>] - zOS - with DerbyClient getDate(#) fails with IllegalArgumentException - unsupported date format - resultset.java</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-882">DERBY-882</a>] - Increasing size of varchar type using ALTER TABLE can implicitly change the column from NOT NULL to NULLable.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-898">DERBY-898</a>] - setAutoCommit(false) is not working properly for local transaction with ClientXADataSource</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-899">DERBY-899</a>] - Cannot rollback to savepoint when using ClientXADataSource</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-900">DERBY-900</a>] - Remove use of String(byte[]) and String(byte[], int, int) constructors in network client leading to non-portable behaviour</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-901">DERBY-901</a>] - Remove use of String(byte[]) constructors in network server leading to non-portable behaviour</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-902">DERBY-902</a>] - Remove use of String(byte[]) and String(byte[], int, int) constructors in engine leading to non-portable behaviour</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-903">DERBY-903</a>] - Remove use of String(byte[]) and String(byte[], int, int) constructors in testing leading to non-portable behaviour</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-960">DERBY-960</a>] - Client xa prepare returns XA_OK instead of XA_RDONLY for a read only transaction</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-966">DERBY-966</a>] - creating a preparedStatement outside of a Global tran using a ClientXADatasource will result in an "SqlException: Cannot set holdability" if the statement is used in a Global transaction</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-972">DERBY-972</a>] - tests derbynet/csPrepStmt and prepStmt use mechanisms that are not portable over encodings</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-994">DERBY-994</a>] - SQL examples for LEFT OUTER JOIN and RIGHT OUTER JOIN in the Derby Reference manual are incorrect</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-997">DERBY-997</a>] - ClassCastException when executing queries with aggregates in app servers</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1002">DERBY-1002</a>] - Check that DRDAStatement and DRDAResultSet states are reset when they are re-used</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1004">DERBY-1004</a>] - Client should not require user to rollback the active transaction before call to PooledConnection.getConnection()</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1005">DERBY-1005</a>] - getHoldability does not return CLOSE_CURSORS_AT_COMMIT in a global transaction</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1006">DERBY-1006</a>] - Client allows setHoldability to HOLD_CURSORS_OVER_COMMIT on both connection and statement in a global transaction</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1009">DERBY-1009</a>] - Embedded ResultSet.getStatement() does not return the Statement object that created it for a connection returned from EmbeddedXADataSource</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1010">DERBY-1010</a>] - setTransactionIsolation can cause ava.sql.SQLException: Invalid operation: statement closed in some contexts with xa</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1024">DERBY-1024</a>] - Client's XAResource.start throws XAException with XAER_RMFAIL when local transaction is active</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1025">DERBY-1025</a>] - <xa> client XAResource.start() does not commit an active local transaction when auto commit is true</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1035">DERBY-1035</a>] - With client, Connection.getTransactionIsolation() return value is wrong after changing the isolation level with an SQL statement such as "set current isolation = RS"</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1044">DERBY-1044</a>] - <xa> client XAConnection.getConnection() does not have the correct default isolation level if set by an earlier connection obtained from the same XAConnection</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1055">DERBY-1055</a>] - Security.AccessControlException in client under SecurityManager when trying to connect using EUSRIDPWD security mechanism</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1058">DERBY-1058</a>] - derby fails supporting holdable scrollable resultset: ERROR XSCB8: The btree conglomerate 1,141,037,436,752 is closed.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1069">DERBY-1069</a>] - Client should unwrap exceptions thrown in privilege blocks rather than throwing the java.security.PrivilegedActionException</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1073">DERBY-1073</a>] - Reset optimizer timeout for subqueries on a per-round basis to allow consideration of plans that use pushed predicates.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1085">DERBY-1085</a>] - java.lang.NullPointerException with char for bit data column and subquery</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1103">DERBY-1103</a>] - Change the client driver to allow statements to be garbage-collected once they are not referenced in an application</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1127">DERBY-1127</a>] - client gives SqlException for test callable.java and parameterMapping.java on zOS</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1136">DERBY-1136</a>] - JDBC driver on rs.getFloat() gives LossOfPrecisionConversionException for float fields containing Float.MAX_VALUE</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1144">DERBY-1144</a>] - With client PooledConnection.getConnection() does not reset holdability and isolation state properly</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1148">DERBY-1148</a>] - Client XA getTransactionIsolation() does not return the correct isolation level when rejoining a global transaction</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1159">DERBY-1159</a>] - PreparedStatement.executeUpdate throws a XJ05C exception in a global transaction if the statement is HOLD_CURSORS_OVER_COMMIT</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1174">DERBY-1174</a>] - NullPointerException in network server with LDAP authentication</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1187">DERBY-1187</a>] - defragment of inplace compress pass for described dataset is not freeing up empty pages.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1189">DERBY-1189</a>] - latch self deadlock when running inplace compress</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1207">DERBY-1207</a>] - Derby Server and Administration Guide - Network Server security</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1247">DERBY-1247</a>] - test DerbyNetAutoStart uses non-portable mechanism to check on derby.log</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1262">DERBY-1262</a>] - Like-predicates: % does not match tab character</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1293">DERBY-1293</a>] - Derby Server and Administration Guide - derby.drda.startNetworkServer</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1299">DERBY-1299</a>] - Derby Server and Administration Guide - derby.drda.timeslice</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1310">DERBY-1310</a>] - Add apache notice to test file phaseTester.java</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1324">DERBY-1324</a>] - Need to remove old copyright notice</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1325">DERBY-1325</a>] - Isolation level of local connection does not get reset after exiting a global transaction if the isolation level was changed using SQL</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1327">DERBY-1327</a>] - Identity column can be created with wrong and very large start with value with "J2RE 1.5.0 IBM Windows 32 build pwi32dev-20060412 (SR2)" with JIT on</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1329">DERBY-1329</a>] - ASSERT failure/IndexOutOfBoundsException with correlated subquery for UPDATE ... SET ... WHERE CURRENT OF ... statement.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1354">DERBY-1354</a>] - Writer.write(int c) to writer from Clob.setCharacterStream(long pos) appends integer value, not character</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1359">DERBY-1359</a>] - Developers guide: example showing shut down of Derby system should not contain a database name</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1365">DERBY-1365</a>] - Address potential problems with optimizer logic in some rarely-exercised code.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1386">DERBY-1386</a>] - Wrong results with query using LIKE and ESCAPE clause that includes "%", "\", and "_"</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1392">DERBY-1392</a>] - Corner case behaviour in RAFContainer#writePage() can cause invalid data to be written to data files</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1454">DERBY-1454</a>] - DRDA Protocol Exception when DSS is exactly 32767 in length</li>
+</ul>
+<a name="N10369"></a><a name="Improvements"></a>
+<h3 class="boxed">Improvements</h3>
+<ul>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-178">DERBY-178</a>] - Provide line number information in distribution's class files</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1039">DERBY-1039</a>] - Database creation should fail if specified log device path already exists</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1158">DERBY-1158</a>] - Allow use of Statements created in local transaction with default holdability to be used in global transactions.</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1230">DERBY-1230</a>] - Remove the huge log files (TesterN.out) left from running 'stress/stress.multi'</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1287">DERBY-1287</a>] - Derby Server and Administration Guide - Network client driver examples should show how to enable authentication</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1300">DERBY-1300</a>] - Derby Server and Administration Guide - Managing the Derby Network Server remotely by using the servlet interface should clarify that Network Server is shutdown when Application Server is shutdown</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1305">DERBY-1305</a>] - Derby Server and Administration Guide translated into Brazilian Portuguese</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1339">DERBY-1339</a>] - messages_pt_BR.properties file should not translate Network Server "start" and "shutdown" commands</li>
+<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-1376">DERBY-1376</a>] - File java/engine/org/apache/derby/loc/messages_en.properties - Message XSLAT.D</li>
+</ul>
+<a class="external" href="http://issues.apache.org/jira/browse/DERBY"></a><a name="N103A6"></a>
+<h3 class="boxed">DERBY-283</h3>
+<p>On IPv6/Ipv4 dual stack windows machines, the network server needs the following jvm properties to be prefixed while starting the server</p>
+<p>PROBLEM:<br>
+<br>UnknownHostException while trying to connect with NetworkClient on a Windows dual boot IPv4/IPv6 machine<br>
+<br>SYMPTOM:<br>
+<br>The following exception will occur<br>ij> CONNECT 'jdbc:derby://hostname:1527/sample;create=true ' USER 'mkutty' PASSWORD 'admin';<br>ERROR (no SQLState): java.net.UnknownHostException : Error opening socket to server hostname on port 1527 with message : <hostname><br>
+<br>CAUSE:<br>
+<br>There may be an underlying windows bug causing this issue<br>
+<br>SOLUTION:<br>
+<br>There is no Derby fix available for this issue<br>
+<br>WORKAROUND:<br>
+<br>Start the client and server running on the IPv6 machine with the following jvm properties.<br>
+</p>
+<a name="N103D0"></a><a name="-N103D0"></a>
+<h3 class="boxed">DERBY-526</h3>
+<p>Network Client URL cannot take the IP Address as host name for IPV6 addresses.</p>
+<p>PROBLEM:<br>
+<br>NumberFormatException while trying to get connection to a Ipv6 server using the ip address as the host name in the database URL<br>
+<br>SYMPTOM:<br>
+<br>The symptom is you will get a java error like this:<br>ij> CONNECT 'jdbc:derby://2002:92a:8f7a:13:9:42:73:115:1527/sample;create=true' USER 'mkutty' PASSWORD 'admin';<br>JAVA ERROR: java.lang.NumberFormatException: For input string: "92a:8f7a:13:9:42 :73:115:1527"<br>
+<br>CAUSE:<br>
+<br>Derby URL format cannot support an IP address with ":"<br>
+<br>SOLUTION:<br>
+<br>There is no Derby fix available for this issue<br>
+<br>WORKAROUND:<br>
+<br>Use host name in the URL instead of the IP address or connect with a datasource instead of URL<br>
+</p>
+<a name="N103FA"></a><a name="-N103FA"></a>
+<h3 class="boxed">DERBY-1327</h3>
+<p>Identity column can be created with wrong and very large start with value with "J2RE 1.5.0 IBM Windows 32 build pwi32dev-20060412 (SR2)" with JIT on</p>
+<p>PROBLEM:<br>
+<br>After creating a table, with JIT engaged, identity column start with values for any column in the database gets changed to an incorrect value.<br>
+<br>SYMPTOM:<br>
+<br>The symptom is typically that an insert to the table will fail with the Exception:<br>SQLSTATE 22001: "A truncation error was encountered trying to shrink ... to length 12."<br>
+<br>CAUSE:<br>
+<br>A JIT issue in IBM JDK 1.5 Service Release 2 can cause corruption of the start with value. The affected version is java version "1.5.0"<br>Java(TM) 2 Runtime Environment, Standard Edition (build pwi32dev-20060511 (SR2))<br>IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Windows XP x86-32 j9vmwi3223-20060504 (JIT enabled)<br>J9VM - 20060501_06428_lHdSMR<br>JIT - 20060428_1800_r8<br>GC - 20060501_AA)<br>JCL - 20060511a<br>
+<br>SOLUTION:<br>
+<br>This issue is fixed in Derby 10.1.3.1. A fix to resolve the issue is available in 10.1 builds after 10.1.2.5.413354.<br>
+<br>Once corruption has occurred there is no way in 10.1 to correct the START WITH value. The only way to recover the data is to recreate the database and use export/import to transfer the data.<br>
+<br>WORKAROUND:<br>
+<br>For users of previous releases, the following JIT options can be specified for the JVM to prevent corruption in identity columns. This does allow recovery after the problem has occured.<br>
+<br>-Xjit:exclude={org/apache/derby/impl/sql/execute/CreateTableConstantAction.executeConstantAction\(Lorg/apache/derby/iapi/sql/Activation\;\)V}<br>
+</p>
+<a name="N10434"></a><a name="-N10434"></a>
+<h3 class="boxed">DERBY-541</h3>
+<p>PROBLEM:<br>
+<br> A Derby 10.0 database in a jar cannot be booted against a 10.1(.3) engine.<br>
+<br> SYMPTOM:<br>
+<br> Attempting to connect to a database in a jar created with Derby 10.0 fails when trying to connect with Derby 10.1.3. The following error is thrown:<br>
+<br> ERROR XJ040: Failed to start database 'jar:(pathtojarfile)pathinjar', see the next exception for details.<br> ERROR 40XD1: Container was opened in read-only mode.<br>
+<br> CAUSE:<br>
+<br> The problem was discovered and fixed as a part of <a class="external" href="http://issues.apache.org/jira/browse/DERBY-541">DERBY-514</a>. The newer Derby engine would attempt to apply safe soft upgrade changes applicable to a read/write database when the database was opened in read-only mode. The inability to write to the database files leads to the error 40XD1 mentioned above when the engine attempts to apply safe soft upgrade changes to a read-only database.<br>
+<br> SOLUTION:<br>
+<br> This has been fixed in 10.2.0.0.376372. The Derby engine should not attempt to apply soft upgrade changes to a read-only database.<br>
+<br> WORKAROUND:<br>
+<br> Users with 10.0 Derby databases-in-jars can upgrade their 10.0 database in their jar file to a 10.1 database-in-a-jar by unjarring it, then connecting to it with a 10.1 version of the Derby engine and the upgrade=true attribute. The resulting database can then be jarred up again and future connections to this database using the 10.1 Derby engine will succeed.<br> Users of Derby versions after 10.2.0.0.376372 should be able to connect to their 10.0 database with no extra effort.<br>
+</p>
+</div>
+<a name="N10463"></a><a name="Testing"></a>
+<h2 class="boxed">Testing</h2>
+<div class="section">
+<p>Tests were run on the following platforms. Results are listed separately for each platform.</p>
+<table class="ForrestTable" cellspacing="1" cellpadding="4">
+<tr>
+<td>Type test</td><td>platform, jvm version</td><td>by.:</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Ubuntu 5.10 (Linux 2.6.12), Sun 1.4.2_09</td><td>Bernt Johnsen</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>HP-UX B.11.11 U, HP JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>RHEL 4 64-bit, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>RHEL 4 64-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>RHEL 3 64-bit, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>RHEL 3 64-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>RHEL 4 32-bit, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>RHEL 4 32-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 10 x86 64-bit, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 10 x86 64-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 9 x86 32-bit, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 9 x86 32-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 10 x86 32-bit, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 10 x86 32-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 10 SPARC 64-bit, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 10 SPARC 64-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris Nevada 64-bit, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris Nevada 64-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 9 SPARC 64-bit, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 9 SPARC 64-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 8 SPARC 64-bit, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 8 SPARC 64-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 10 SPARC 64-bit w/3 zones, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Solaris 10 SPARC 64-bit w/3 zones, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Windows 2003 x86, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Windows 2003 x86, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Windows 2000 x86, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Windows 2000 x86, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Windows XP x86 w/Cygwin, Sun JDK 1.4.2</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Windows XP x86 w/Cygwin, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>Large Data Volume tests</td><td>Solaris 10 x86 64-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>JDBC 3.0 CTS tests</td><td>Solaris 10 x86 64-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>JDBC 3.0 CTS tests</td><td>Linux 2.6 x86 64-bit, Sun JDK 1.5.0</td><td>Sun DBTG</td>
+</tr>
+<tr>
+<td>derbyall suite (10.1.3.0 RC)</td><td>FreeBSD 6.1 (i386), Diablo 1.5.0_06</td><td>Knut Anders Hatlen</td>
+</tr>
+<tr>
+<td>derbyall suite (10.1.3.0 RC)</td><td>OpenBSD 3.9 (i386), J2SE 1.4.2 (SCSL + BSD patchset 7)</td><td>Knut Anders Hatlen</td>
+</tr>
+<tr>
+<td>derbyall suite (10.1.3.0 RC)</td><td>OpenBSD 3.9 (i386), J2SE 5.0 (SCSL + BSD patchset 2)</td><td>Knut Anders Hatlen</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>FreeBSD 6.1 (i386), J2SE 5.0 (SCSL + BSD patchset 3)</td><td>Knut Anders Hatlen</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>NetBSD 3.0 (i386), J2SE 5.0 (SCSL + BSD patchset 3)</td><td>Knut Anders Hatlen</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>RHEL 4.0 (Linux 2.6.9), IBM JDK 1.5.0 (j9vmxi3223-20060504)</td><td>Rajesh Kartha</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>RHEL 4.0 (Linux 2.6.9), Sun JRE 1.5.0_07-b03 (with and without -server option)</td><td>Rajesh Kartha</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Windows Server 2003, IBM JDK 1.4.2 (cn142-20060421)</td><td>Ramandeep Kaur</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Windows Server 2003 64-bit, IBM JDK 1.5.0 (pwa64dev-2006511)</td><td>Ramandeep Kaur</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Suse 9.2, IBM JDK 1.4.2 (cxia32142-20050929)</td><td>Ramandeep Kaur</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Suse 9.2, IBM JDK 1.5.0 (pxi32dev-20060511)</td><td>Ramandeep Kaur</td>
+</tr>
+<tr>
+<td>J2EE CTS test suite, JDBC only, with JCC 2.6</td><td>Windows 2000, Sun JDK 1.4.2_07-b05</td><td>Myrna Van Lunteren</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>RHEL 4.0 (Linux 2.6.9 x86-64), Sun SDK 1.5.0_04-b05)</td><td>Myrna Van Lunteren</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>Windows 2000, IBM SDK 1.5.0</td><td>Myrna Van Lunteren</td>
+</tr>
+<tr>
+<td>derbyall suite</td><td>AIX 5.2, IBM JDK 1.4.2 and JDK 1.5.0 (with and w/o JIT)</td><td>Manjula Kutty</td>
+</tr>
+<tr>
+<td>system/stress tests (10.1.3.0)</td><td>Redhat Linux, IBM JDK 1.4.2 and IBM JDK 1.5.0 (w/o JIT)</td><td>Manjula Kutty</td>
+</tr>
+<tr>
+<td>IPV6 tests</td><td>Release notes included for DERBY-283 and DERBY-526</td><td>Manjula Kutty</td>
+</tr>
+<tr>
+<td>derbyall suite (10.1.3.0)</td><td>SLES 9 (SMP), Sun J2SE 5.0 and IBM 1.3.1 SP 10</td><td>Stan Bradbury</td>
+</tr>
+<tr>
+<td>derbyall suite (10.1.3.1)</td><td>SLES 9 (SMP), Sun J2SE 5.0</td><td>Stan Bradbury</td>
+</tr>
+<tr>
+<td><a class="external" href="http://people.apache.org/~fuzzylogic/codecoverage/417277/">Code coverage</a></td><td>JDK 1.3.1, JDK 1.4.2, JDK 1.5.0</td><td>Ramandeep Kaur</td>
+</tr>
+</table>
+<p>Several test issues were reported, such as DERBY-496, DERBY-937, DERBY-1221, DERBY-1351, but no specific code issues were noted.</p>
+<p>Tests for a specific platform can be run using the derbyTesting.jar file that can be found in the lib directory of the -lib or -bin distributions.</p>
+<p>Instructions on how to run the tests can be found in the <a class="external" href="http://svn.apache.org/repos/asf/db/derby/code/branches/10.1/java/testing/README.htm">testing README</a>.</p>
+</div>
+<a name="N105F0"></a><a name="Verifying+releases"></a>
+<h2 class="boxed">Verifying releases</h2>
+<div class="section">
+<p>It is essential that you verify the integrity of the downloaded files using the PGP and MD5 signatures. MD5 verification ensures the file was not corrupted during the download process. PGP verification ensures that the file came from a certain person.</p>
+<p>The PGP signatures can be verified using <a class="external" href="http://www.pgpi.org/">PGP</a> or <a class="external" href="http://www.gnupg.org/">GPG</a>. First download the Apache Derby <a class="external" href="http://www.apache.org/dist/db/derby/KEYS">KEYS</a> as well as the <span class="codefrag">asc</span> signature file for the particular distribution. It is important that you get these files from the ultimate trusted source - the main ASF distribution site, rather than from a mirror. Then verify the signatures using ...</p>
+<pre>% pgpk -a KEYS
+% pgpv db-derby-X.Y.tar.gz.asc
+
+<em>or</em>
+
+% pgp -ka KEYS
+% pgp db-derby-X.Y.tar.gz.asc
+
+<em>or</em>
+
+% gpg --import KEYS
+% gpg --verify db-derby-X.Y.tar.gz.asc
+
+</pre>
+<p>To verify the MD5 signature on the files, you need to use a program called <span class="codefrag">md5</span> or <span class="codefrag">md5sum</span>, which is included in many unix distributions. It is also available as part of <a class="external" href="http://www.gnu.org/software/textutils/textutils.html">GNU Textutils</a>. Windows users can get binary md5 programs from <a class="external" href="http://www.fourmilab.ch/md5/">here</a>, <a class="external" href="http://www.pc-tools.net/win32/freeware/console/">here</a>, or <a class="external" href="http://www.slavasoft.com/fsum/">here</a>.</p>
+<p>We strongly recommend you verify your downloads with both PGP and MD5.</p>
+</div>
+</div>
+<!--+
+ |end content
+ +-->
+<div class="clearboth"> </div>
+</div>
+<div id="footer">
+<!--+
+ |start bottomstrip
+ +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+// --></script>
+</div>
+<div class="copyright">
+ Copyright ©
+ 2004-2012 Apache Software Foundation</div>
+<div id="feedback">
+ Send feedback about the website to:
+ <a id="feedbackto" href="mailto:derby-user@db.apache.org?subject=Feedback%C2%A0releases/release-10.1.3.1.html">derby-user@db.apache.org</a>
+</div>
+<!--+
+ |end bottomstrip
+ +-->
+</div>
+</body>
+</html>