db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r564589 [2/5] - in /db/derby/site/trunk: build/site/ build/site/dev/ build/site/integrate/ build/site/releases/ src/documentation/conf/ src/documentation/content/xdocs/ src/documentation/content/xdocs/integrate/ src/documentation/content/xd...
Date Fri, 10 Aug 2007 13:46:29 GMT
Added: db/derby/site/trunk/build/site/releases/release-10.3.1.4.html
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/releases/release-10.3.1.4.html?view=auto&rev=564589
==============================================================================
--- db/derby/site/trunk/build/site/releases/release-10.3.1.4.html (added)
+++ db/derby/site/trunk/build/site/releases/release-10.3.1.4.html Fri Aug 10 06:46:26 2007
@@ -0,0 +1,2203 @@
+<!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.7">
+<meta name="Forrest-skin-name" content="pelt">
+<meta name="generator" content="">
+<title>Apache Derby 10.3.1.4 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">
+<div class="breadtrail">
+<a href="http://www.apache.org/">apache</a> &gt; <a href="http://db.apache.org/">db</a><script src="../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script>
+</div>
+<div class="header">
+<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>
+<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>
+<ul id="tabs">
+<li>
+<a class="base-not-selected" href="../index.html">Home</a>
+</li>
+<li>
+<a class="base-not-selected" href="../quick_start.html">Quick Start</a>
+</li>
+<li>
+<a class="base-not-selected" href="../derby_downloads.html">Download</a>
+</li>
+<li>
+<a class="base-not-selected" href="../derby_comm.html">Community</a>
+</li>
+<li>
+<a class="base-not-selected" href="../manuals/index.html">Documentation</a>
+</li>
+<li>
+<a class="base-not-selected" href="../integrate/index.html">Resources</a>
+</li>
+</ul>
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<div id="level2tabs"></div>
+<script type="text/javascript"><!--
+document.write("<text>Last Published:</text> " + document.lastModified);
+//  --></script>
+</div>
+<div class="breadtrail">
+             
+             &nbsp;
+           </div>
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../skin/')" id="menu_1.1Title" class="menutitle">Home</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../index.html">Apache Derby</a>
+</div>
+<div class="menuitem">
+<a href="../derby_charter.html">Charter</a>
+</div>
+<div class="menuitem">
+<a href="../license.html">License</a>
+</div>
+<div class="menuitem">
+<a href="../faq.html">FAQs</a>
+</div>
+<div class="menuitem">
+<a href="http://wiki.apache.org/db-derby/">Derby Wiki</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.2', '../skin/')" id="menu_1.2Title" class="menutitle">Quick Start</div>
+<div id="menu_1.2" class="menuitemgroup">
+<div class="menuitem">
+<a href="../quick_start.html">Quick Start</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3', '../skin/')" id="menu_1.3Title" class="menutitle">Download</div>
+<div id="menu_1.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../derby_downloads.html">Overview</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4', '../skin/')" id="menu_1.4Title" class="menutitle">Community</div>
+<div id="menu_1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../derby_comm.html">Get Involved!</a>
+</div>
+<div class="menuitem">
+<a href="../derby_mail.html">Mailing Lists</a>
+</div>
+<div class="menuitem">
+<a href="../dev/derby_source.html">Source Code</a>
+</div>
+<div class="menuitem">
+<a href="../DerbyBugGuidelines.html">BUGS</a>
+</div>
+<div class="menuitem">
+<a href="../derby_tests.html">Tests</a>
+</div>
+<div class="menuitem">
+<a href="../logo.html">Logo</a>
+</div>
+<div class="menuitem">
+<a href="../papers/derby_web.html">Updating the web site</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.5', '../skin/')" id="menu_1.5Title" class="menutitle">Documentation</div>
+<div id="menu_1.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../manuals/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/dita.html">DITA Source</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/guidelines.html">Writing Guidelines</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/messages.html">Documenting Messages</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/docsfaq.html">Writing FAQs</a>
+</div>
+<div class="menuitem">
+<a href="../manuals/docscheck.html">Release Checklist</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.6', '../skin/')" id="menu_1.6Title" class="menutitle">Other Products</div>
+<div id="menu_1.6" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/index.html#uses">What works with Derby?</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/index.html#products">Product Writeups</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.7', '../skin/')" id="menu_1.7Title" class="menutitle">Eclipse Plug-ins</div>
+<div id="menu_1.7" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/derby_plugin.html">10 Core</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/func_spec_plugins.html">1.0 UI Functional Spec</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_howto.html">10 Core and 1.1 UI</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/Readme.html">Building 1.1 UI</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_slides.html">Derby Plug-ins Slides and Lab</a>
+</div>
+<div onclick="SwitchMenu('menu_1.7.6', '../skin/')" id="menu_1.7.6Title" class="menutitle">10 Core and 1.1 UI Documentation</div>
+<div id="menu_1.7.6" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/start_toc.html">Getting Started</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/java_project.html">Creating an Eclipse Project</a>
+</div>
+<div onclick="SwitchMenu('menu_1.7.6.3', '../skin/')" id="menu_1.7.6.3Title" class="menutitle">Derby Nature</div>
+<div id="menu_1.7.6.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/nature_toc.html">Adding or Removing</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/nature.html">Adding the Derby Nature</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/remove_nature.html">Removing the Derby Nature</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.7.6.4', '../skin/')" id="menu_1.7.6.4Title" class="menutitle">Network Server</div>
+<div id="menu_1.7.6.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/server_toc.html">Starting and Stopping</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/start_server.html">Starting the Server</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/stop_server.html">Stopping the Server</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/properties.html">Derby Properties</a>
+</div>
+<div onclick="SwitchMenu('menu_1.7.6.6', '../skin/')" id="menu_1.7.6.6Title" class="menutitle">ij</div>
+<div id="menu_1.7.6.6" class="menuitemgroup">
+<div class="menuitem">
+<a href="../integrate/plugin_help/ij_toc.html">Using ij</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/ij.html">SQL commands</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/ij2.html">SQL scripts</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/derby_app.html">Building a Java App</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/sysinfo.html">Running sysinfo</a>
+</div>
+<div class="menuitem">
+<a href="../integrate/plugin_help/resources.html">Derby Manuals</a>
+</div>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.8', '../skin/')" id="menu_1.8Title" class="menutitle">Papers</div>
+<div id="menu_1.8" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/index.html">Overview</a>
+</div>
+<div onclick="SwitchMenu('menu_1.8.2', '../skin/')" id="menu_1.8.2Title" class="menutitle">Derby Engine</div>
+<div id="menu_1.8.2" class="menuitemgroup">
+<div onclick="SwitchMenu('menu_1.8.2.1', '../skin/')" id="menu_1.8.2.1Title" class="menutitle">Javadoc</div>
+<div id="menu_1.8.2.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/engine">Engine</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/language">Language</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/tools">Tools</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/publishedapi">API</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../papers/derby_arch.html">Architecture</a>
+</div>
+<div class="menuitem">
+<a href="../papers/btree_package.html">BTree</a>
+</div>
+<div class="menuitem">
+<a href="../papers/pageformats.html">Disk Page Format</a>
+</div>
+<div class="menuitem">
+<a href="../papers/derby_htw.html">How Things Work</a>
+</div>
+<div class="menuitem">
+<a href="../papers/Intersect-design.html">Intersect &amp; Except</a>
+</div>
+<div class="menuitem">
+<a href="../papers/JDBCImplementation.html">JDBC</a>
+</div>
+<div class="menuitem">
+<a href="../papers/logformats.html">Log Format</a>
+</div>
+<div class="menuitem">
+<a href="../papers/recovery.html">Logging &amp; Recovery</a>
+</div>
+<div class="menuitem">
+<a href="../papers/optimizer.html">Optimizer</a>
+</div>
+<div class="menuitem">
+<a href="http://db.apache.org/derby/javadoc/engine/org/apache/derby/iapi/types/package-summary.html#package_description">Type System</a>
+</div>
+<div class="menuitem">
+<a href="../papers/versionupgrade.html">Versioning</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.8.3', '../skin/')" id="menu_1.8.3Title" class="menutitle">Derby Network Client</div>
+<div id="menu_1.8.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/DerbyClientSpec.html">Functional Spec</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.8.4', '../skin/')" id="menu_1.8.4Title" class="menutitle">Derby Tutorial</div>
+<div id="menu_1.8.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/DerbyTut/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/install_software.html">Step 1: Install Software</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/ij_intro.html">Step 2: ij Basics</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/embedded_intro.html">Step 3: Embedded Derby</a>
+</div>
+<div class="menuitem">
+<a href="../papers/DerbyTut/ns_intro.html">Step 4: Derby Network Server</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.8.5', '../skin/')" id="menu_1.8.5Title" class="menutitle">Presentations</div>
+<div id="menu_1.8.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../papers/ApacheCon.html">ApacheCon</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#OSCON+2005">OSCON 2005</a>
+</div>
+<div class="menuitem">
+<a href="../papers/MiscPresentations.html#Colorado+Software+Summit+2004">Colorado 2004</a>
+</div>
+</div>
+</div>
+<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">&nbsp; 
+                  <input attr="value" name="Search" value="Search" type="submit">
+</form>
+</div>
+<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>
+<div id="credit2"></div>
+</div>
+<div id="content">
+<div class="trail">
+<text>Font size:</text> 
+	          &nbsp;<input value="Reset" class="resetfont" title="Reset text" onclick="ndeSetTextSize('reset'); return false;" type="button">      
+	          &nbsp;<input value="-a" class="smallerfont" title="Shrink text" onclick="ndeSetTextSize('decr'); return false;" type="button">
+	          &nbsp;<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
+</div>
+<h1>Apache Derby 10.3.1.4 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="#New Features">New Features</a>
+</li>
+<li>
+<a href="#CHANGES">CHANGES</a>
+</li>
+<li>
+<a href="#Issues">Issues</a>
+<ul class="minitoc">
+<li>
+<a href="#Note+for+DERBY-2925">Note for DERBY-2925</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2757">Note for DERBY-2757</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2729">Note for DERBY-2729</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2610">Note for DERBY-2610</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2526">Note for DERBY-2526</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2443">Note for DERBY-2443</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2430">Note for DERBY-2430</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2386">Note for DERBY-2386</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2370">Note for DERBY-2370</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2296">Note for DERBY-2296</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2264">Note for DERBY-2264</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2256">Note for DERBY-2256</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2196">Note for DERBY-2196</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2108">Note for DERBY-2108</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-2020">Note for DERBY-2020</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-1942">Note for DERBY-1942</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-1852">Note for DERBY-1852</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-1828">Note for DERBY-1828</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-1816">Note for DERBY-1816</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-1610">Note for DERBY-1610</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-1519">Note for DERBY-1519</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-1484">Note for DERBY-1484</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-1341">Note for DERBY-1341</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-729">Note for DERBY-729</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-415">Note for DERBY-415</a>
+</li>
+<li>
+<a href="#Note+for+DERBY-208">Note for DERBY-208</a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#Open Bugs">Open Bugs</a>
+</li>
+<li>
+<a href="#Build Environment">Build Environment</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 one of our mirrors. You should <strong>always</strong> <a href="#Verifying+releases">verify the integrity</a> of distribution files downloaded from a mirror.</p>
+<p>You are currently using <strong>[preferred]</strong>. If you encounter a problem with this mirror, then please select another. If all mirrors are failing, there are backup mirrors at the end of the list. See <a class="external" href="http://www.apache.org/mirrors/">status</a> of mirrors.</p>
+<form action="[location]">
+<a name="SelectMirror"></a>Other mirrors: <select name="Preferred"><option value="[http]">[http]</option><option value="[ftp]">[ftp]</option><option value="[backup]">[backup] (backup)</option></select> <input type="submit" value="Change">
+</form>
+<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 href="[preferred]/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-bin.zip">db-derby-10.3.1.4-bin.zip</a> [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-bin.zip.asc">PGP</a>] [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-bin.zip.md5">MD5</a>]<br> 
+<a href="[preferred]/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-bin.tar.gz">db-derby-10.3.1.4-bin.tar.gz</a> [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-bin.tar.gz.asc">PGP</a>] [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-bin.tar.gz.md5">MD5</a>]</p>
+<p>
+<a href="[preferred]/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib.zip">db-derby-10.3.1.4-lib.zip</a> [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib.zip.asc">PGP</a>] [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib.zip.md5">MD5</a>]<br> 
+<a href="[preferred]/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib.tar.gz">db-derby-10.3.1.4-lib.tar.gz</a> [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib.tar.gz.asc">PGP</a>] [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib.tar.gz.md5">MD5</a>]</p>
+<p>
+<a href="[preferred]/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib-debug.zip">db-derby-10.3.1.4-lib-debug.zip</a> [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib-debug.zip.asc">PGP</a>] [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib-debug.zip.md5">MD5</a>]<br> 
+<a href="[preferred]/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib-debug.tar.gz">db-derby-10.3.1.4-lib-debug.tar.gz</a> [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib-debug.tar.gz.asc">PGP</a>] [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-lib-debug.tar.gz.md5">MD5</a>]</p>
+<p>
+<a href="[preferred]/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-src.zip">db-derby-10.3.1.4-src.zip</a> [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-src.zip.asc">PGP</a>] [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-src.zip.md5">MD5</a>]<br> 
+<a href="[preferred]/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-src.tar.gz">db-derby-10.3.1.4-src.tar.gz</a> [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-src.tar.gz.asc">PGP</a>] [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/db-derby-10.3.1.4-src.tar.gz.md5">MD5</a>] (Note that, due to long filenames, you will need gnu tar to unravel this tarball.)</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 href="[preferred]/db/derby/db-derby-10.3.1.4/derby_core_plugin_10.3.1.zip">derby_core_plugin_10.3.1.zip</a> [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/derby_core_plugin_10.3.1.zip.asc">PGP</a>] [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/derby_core_plugin_10.3.1.zip.md5">MD5</a>]<br> 
+<a href="[preferred]/db/derby/db-derby-10.3.1.4/derby_ui_plugin_1.1.1.zip">derby_ui_plugin_1.1.1.zip</a> [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/derby_ui_plugin_1.1.1.zip.asc">PGP</a>] [<a class="external" href="http://www.apache.org/dist/db/derby/db-derby-10.3.1.4/derby_ui_plugin_1.1.1.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 Core and 1.1 UI Derby plug-ins</a> page.</p>
+</div>
+<a name="N100DF"></a><a name="Release Overview"></a>
+<h2 class="boxed">Release Overview</h2>
+<div class="section">
+<p>These notes describe the difference between Derby release 10.3.1.4 and the preceding release 10.2.2.0.</p>
+<p>Derby is a pure Java relational database engine using standard SQL and JDBC as its APIs.</p>
+<p>Derby functionality includes:</p>
+<ul>
+<li>Embedded engine with JDBC drivers</li>
+<li>Network Server</li>
+<li>Network client JDBC drivers</li>
+<li>Command line tools: ij (SQL scripting), dblook (schema dump) and sysinfo (system info)</li>
+</ul>
+<p>Derby 10.3.1.4 runs on the following platforms:</p>
+<ul>
+<li>
+<strong>JDK 1.4 and Java 5</strong> - Here Derby supports the JDBC 3.0 interface.</li>
+<li>
+<strong>Java 6</strong> - Here Derby supports the JDBC 4.0 interface.</li>
+<li>
+<strong>CDC/Foundation 1.1</strong> - Here Derby supports the JSR 169 interface.</li>
+</ul>
+</div>
+<a name="N10102"></a><a name="New Features"></a>
+<h2 class="boxed">New Features</h2>
+<div class="section">
+<p>This is a minor release. The following table lists new features that were added and notable improvements that were made:</p>
+<div style="margin-left: 2em">
+<table class="ForrestTable" cellspacing="1" cellpadding="4">
+<tr>
+<td><strong>Feature</strong></td><td><strong>Description</strong></td><td><strong>Issue Id(s)</strong></td>
+</tr>
+<tr>
+<td>DBA Powers</td><td>Control who can shutdown, encrypt and upgrade databases.</td><td>Master JIRA: <a class="external" href="http://issues.apache.org/jira/browse/DERBY-2264">DERBY-2264</a></td>
+</tr>
+<tr>
+<td>Secure Server</td><td>Make the Network Server secure by default.</td><td>Master JIRA: <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2196">DERBY-2196</a> </td>
+</tr>
+<tr>
+<td>Language Based Ordering</td><td>Add built in language based ordering and like processing to Derby.</td><td>Master JIRA: <a class="external" href="https://issues.apache.org/jira/browse/DERBY-1478">DERBY-1478</a> </td>
+</tr>
+<tr>
+<td>Alter Table</td><td>You can now DROP or RENAME a column. Together with a number of enhancements in 10.2, this means that most dynamic schema modifications are now possible</td><td><a class="external" href="https://issues.apache.org/jira/browse/DERBY-396">DERBY-396</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-1489">DERBY-1489</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-1490">DERBY-1490</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-1926">DERBY-1926</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-1909">DERBY-1909</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2042">DERBY-2042</a></td>
+</tr>
+<tr>
+<td>SSL/TLS</td><td>Implement SSL/TLS communication between client and server</td><td><a class="external" href="https://issues.apache.org/jira/browse/DERBY-2108">DERBY-2108</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2356">DERBY-2356</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2272">DERBY-2272</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2273">DERBY-2273</a> </td>
+</tr>
+<tr>
+<td>Blob/Clob API</td><td>Support all JDBC API methods for Blob/Clob, both for embedded driver and client driver</td><td><a class="external" href="https://issues.apache.org/jira/browse/DERBY-1341 ">DERBY-1341</a> , <a class="external" href="https://issues.apache.org/jira/browse/DERBY-1285">DERBY-1285</a> , <a class="external" href="https://issues.apache.org/jira/browse/DERBY-1286">DERBY-1286</a> , <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2443">DERBY-2443</a> , <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2444">DERBY-2444</a> , <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2730">DERBY-2730</a> </td>
+</tr>
+<tr>
+<td>Client Side Tracing</td><td>Provide a way to enable client tracing without changing the application</td><td><a class="external" href="https://issues.apache.org/jira/browse/DERBY-1275">DERBY-1275</a> </td>
+</tr>
+<tr>
+<td>Import/Export of Blob/Clob</td><td>Add support for import/export of tables with clob, blob and other binary type columns</td><td><a class="external" href="https://issues.apache.org/jira/browse/DERBY-378">DERBY-378</a> </td>
+</tr>
+<tr>
+<td>JDBC methods for autogenerated keys</td><td>Implement JDBC methods for autogenerated keys for Embedded</td><td><a class="external" href="https://issues.apache.org/jira/browse/DERBY-2631">DERBY-2631</a> </td>
+</tr>
+<tr>
+<td>CREATE TABLE AS  WITH NO DATA</td><td>Enable Create of a new empty table based upon a sub query</td><td><a class="external" href="https://issues.apache.org/jira/browse/DERBY-64">DERBY-64</a></td>
+</tr>
+<tr>
+<td>XATransaction timeout</td><td>Support for XAResource.setTransactionTimeout</td><td>Master JIRA: <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2432">DERBY-2432</a></td>
+</tr>
+<tr>
+<td>SYSCS_UTIL.SYSCS_SET_USER_ACCESS<br> SYSCS_UTIL.SYSCS_GET_USER_ACCESS<br> 
+</td><td>Add a system procedure to set a user's connection level authorization.</td><td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2735">DERBY-2735</a> </td>
+</tr>
+<tr>
+<td>SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE</td><td>Create a procedure to empty the statement cache exposing the existing functionality.</td><td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2772">DERBY-2772</a></td>
+</tr>
+<tr>
+<td>support for diagnostic vti tables that take parameters</td><td>Implement support for diagnostic vti tables that take parameterss.</td><td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2152">DERBY-2152</a></td>
+</tr>
+<tr>
+<td>FOR EACH/MODE DB2SQL in CREATE TRIGGER optional</td><td>Make FOR EACH clause and MODE DB2SQL phrase in CREATE TRIGGER statement optional.</td><td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1953">DERBY-1953</a></td>
+</tr>
+<tr>
+<td>ANSI TRIM</td><td>Add ANSI TRIM implementation</td><td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1623">DERBY-1623</a></td>
+</tr>
+<tr>
+<td>Performance</td><td>Reduce CPU usage in embedded Derby. Main areas being worked on are: Lock manager and latching, reduced use of synchronized data structures, optimize use of bit sets.</td><td><a class="external" href="https://issues.apache.org/jira/browse/DERBY-1704">DERBY-1704</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2107">DERBY-2107</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2149">DERBY-2149</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2150">DERBY-2150</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2191">DERBY-2191</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2226">DERBY-2226</a> </td>
+</tr>
+<tr>
+<td>Performance</td><td>Improve Derby's treatment of IN-lists to allow the optimizer to consider using indexes when appropriate.</td><td><a class="external" href="https://issues.apache.org/jira/browse/DERBY-47">DERBY-47</a></td>
+</tr>
+<tr>
+<td>Testing</td><td>Switch testing to be pure JUnit based.</td><td><a class="external" href="https://issues.apache.org/jira/browse/DERBY-1952">DERBY-1952</a> &amp; many others</td>
+</tr>
+<tr>
+<td>Memory Usage</td><td>Avoid having to materialize entire LOBs in network client. The client will use locators when requesting operations to be performed on LOBs stored on the server side.</td><td>Master JIRA: <a class="external" href="https://issues.apache.org/jira/browse/DERBY-208">DERBY-208</a> </td>
+</tr>
+<tr>
+<td>Platforms</td><td>Minimum JDK support will change to JDK 1.4.2 for J2SE &amp; CDC/Foundation 1.1 for J2ME. (Removes support for JDK 1.3 and J2ME/CDC/Foundation 1.0)</td><td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1983">DERBY-1983</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-1985">DERBY-1985</a> <a class="external" href="https://issues.apache.org/jira/browse/DERBY-2121">DERBY-2121</a> </td>
+</tr>
+</table>
+</div>
+</div>
+<a name="N10238"></a><a name="CHANGES"></a>
+<h2 class="boxed">CHANGES</h2>
+<div class="section">
+<p>The following issues are addressed by Derby release 10.3.1.4. These issues are not addressed in the preceding 10.2.2.0 release.<br> This list includes bugs and improvements, and sub-tasks if the super-task is not fixed in 10.3.1.4, but not issues with only test or web content changes.</p>
+<table class="ForrestTable" cellspacing="1" cellpadding="4">
+<tr>
+<td><strong>Issue Id</strong></td><td><strong>Description</strong></td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2973">DERBY-2973</a></td><td>With collation TERRITORY_BASED, insert into table after changing type of column causes assert failure and loss of connection</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2966">DERBY-2966</a></td><td>loss of connection with TERRITORY_BASED collation.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2963">DERBY-2963</a></td><td>AccessControlException connection from remote client.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2960">DERBY-2960</a></td><td>Group by substr() on collated database causes ERROR XJ001</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2955">DERBY-2955</a></td><td>ERROR 42ZA2 creating table with check constraint with literal comparison</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2941">DERBY-2941</a></td><td>With 10.2, Closing a resultset after retrieving a large &gt; 32665 bytes value with Network Server does not release locks</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2925">DERBY-2925</a></td><td>Prevent export from overwriting existing files</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2882">DERBY-2882</a></td><td>Remove references to JDK 1.2 and 1.3 in the documentation</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2868">DERBY-2868</a></td><td>BUILDING.txt doesn't mention junit.jar in list of jars installed in tools/java</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2858">DERBY-2858</a></td><td>Export exceptions swallow useful information</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2849">DERBY-2849</a></td><td>Add a documentation for derby.jdbc.xaTransactionTimeout system/database property</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2837">DERBY-2837</a></td><td>Update docs on STRONG_PASSWORD_SUBSTITUTE_SECURITY/ENCRYPTED_USER_AND_PASSWORD_SECURITY and JCE support</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2809">DERBY-2809</a></td><td>Expressions with a parameter can be assigned the incorrect type</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2806">DERBY-2806</a></td><td>calling getByteLength on org.apache.derby.impl.jdbc.StoreStreamClob makes BinaryStream, fetched before this call, unusable</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2794">DERBY-2794</a></td><td>Document ansi trim functionality</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2793">DERBY-2793</a></td><td>Ensure LIKE predicate follows correct rules for determing collation</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2789">DERBY-2789</a></td><td>DatabaseMetaData .locatorsUpdateCopy() should return true</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2784">DERBY-2784</a></td><td>With JDBC 4 autoloading DriverManager.getProtocol("jdbc:derby:") throws java.sql.SQLException No suitable driver</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2753">DERBY-2753</a></td><td>org.apache.derby.impl.drda.DDMWriter might swallow unexpected exceptions</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2748">DERBY-2748</a></td><td>TimeSlice and Socket-Timeout bounds checking wrong</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2737">DERBY-2737</a></td><td>Change documentation on permissions needed to include read/write for system property derby.storage.jvmInstanceId</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2694">DERBY-2694</a></td><td>org.apache.derby.impl.drda.DDMWriter uses wrong algorithm to avoid spliting varchar in the middle of a multibyte char.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2692">DERBY-2692</a></td><td>Client driver doesn't chain exceptions received from the server</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2689">DERBY-2689</a></td><td>Deadlock with GenericPreparedStatement</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2686">DERBY-2686</a></td><td>The skip method for some InputStreams and Readers return invalid values</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2673">DERBY-2673</a></td><td>If derby.system.home does not exist Derby should only attempt to create that specific folder, not any missing parents (ie. use File.mkdir(), not File.mkdirs())</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2671">DERBY-2671</a></td><td>Errors/messages early in starting the network server through NetworkServerControl.start() are not reported to the PrintWriter passed into start().</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2654">DERBY-2654</a></td><td>Document newly-supported (in embedded mode) JDBC methods for autogenerated keys.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2652">DERBY-2652</a></td><td>Clob.setCharacterStream differs between embedded and client driver</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2619">DERBY-2619</a></td><td>A Derby source release must include the documentation source files</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2613">DERBY-2613</a></td><td>upgrade test problem when attempting to test 10.0.2.1 -</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2610">DERBY-2610</a></td><td>Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2607">DERBY-2607</a></td><td>DatabaseMetaData is not consistent about throwing SqlException when tablename=null</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2606">DERBY-2606</a></td><td>Derby should print the parameters to failed statements to the derby.log when it logs the error</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2604">DERBY-2604</a></td><td>Implement Clob support for locators</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2603">DERBY-2603</a></td><td>Minor erratum in page of VARCHAR in Derby Reference manual</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2597">DERBY-2597</a></td><td>Language result sets should not reuse current isolation level across executions</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2594">DERBY-2594</a></td><td>Revoking a privilege from an SQL Object should invalidate statements dependent on that object</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2593">DERBY-2593</a></td><td>Add documentation for the CREATE TABLE as subquery clause</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2591">DERBY-2591</a></td><td>DataDictionaryImpl.getSystemSQLName() may generate duplicates</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2584">DERBY-2584</a></td><td>Creating a database with JPOX SchemaTool sometimes gives ArrayIndexOutOfBoundsException when getIndexInfo() is called</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2581">DERBY-2581</a></td><td>Callers of SanityManager.THROWASSERT should chain the exceptions when possible</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2580">DERBY-2580</a></td><td>SanityManager.THROWASSERT(String,Throwable) ignores message argument</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2579">DERBY-2579</a></td><td>AssertFailure class should use JDK's built-in chaining of exceptions</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2570">DERBY-2570</a></td><td>Create a utility which generates Release Notes</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2566">DERBY-2566</a></td><td>OutOfMemory/Sanity-assert failed when updating database</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2558">DERBY-2558</a></td><td>client trhows ArrayIndexOutOfBounds exception instead of parameter out of range</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2556">DERBY-2556</a></td><td>Code paths for db restore do not use doPrivileged-calls, causing SecurityException</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2551">DERBY-2551</a></td><td>Global Xid value garbled in syscs_diag.transaction_table.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2549">DERBY-2549</a></td><td>ArrayIndexOutOfBoundsException in SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2538">DERBY-2538</a></td><td>Update documentation to describe the expected behavior when a JDBC 4 app creates a JDBC 3 datasource.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2526">DERBY-2526</a></td><td>Wrong results with queries that use the JOIN ... ON syntax to join with views or other non-base table expressions.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2521">DERBY-2521</a></td><td>Building derby outputs (from ant) various information messages that are marked as warning severity.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2520">DERBY-2520</a></td><td>Document new restrictions of database shutdown, encryption and hard upgrade powers</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2511">DERBY-2511</a></td><td>reference manual's description of JDBC4 features has misleading sections</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2501">DERBY-2501</a></td><td>Batch scripts in bin\ report extraneous errors when DERBY_HOME is invalid</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2500">DERBY-2500</a></td><td>Assertion failure preparing query with AND and OR in where clause</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2493">DERBY-2493</a></td><td>Use unsynchronized collections in BackingStoreHashtable</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2489">DERBY-2489</a></td><td>Document the policy-reloading system procedure.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2488">DERBY-2488</a></td><td>When loaded by jvm1.6 - EmbeddedConnectionPoolDataSource is not returning a JDBC 4 compliant PooledConnection object</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2480">DERBY-2480</a></td><td>DriverManager.getConnection leaks memory when connecting to a non-existent database</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2472">DERBY-2472</a></td><td>Use Throwable.initCause() to improve error reporting</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2462">DERBY-2462</a></td><td>org.apache.derby.impl.store.access.BackingStoreHashTableFromScan does not honor ResultSet holdability</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2459">DERBY-2459</a></td><td>Ordering on a CASE-expression casues a NullPointerException when using a UNION</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2456">DERBY-2456</a></td><td>File stream is left open when an exception occurs while setting up a character stream for data export.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2450">DERBY-2450</a></td><td>Clob.Position returning wrong value when operating on Reader</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2444">DERBY-2444</a></td><td>Implement not implemented methods Blob.getBinaryStream(long pos, long length) and Clob. getCharacterStream(long pos, long length) in the Network Client</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2443">DERBY-2443</a></td><td>Implement ResultSet updateClob/updateBlob methods on the NetworkClient</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2431">DERBY-2431</a></td><td>Documentation for DatabaseMetaData should reflect that getColumnPrivileges and getTablePrivileges are implemented</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2425">DERBY-2425</a></td><td>ResultSetMetaData.getColumnDisplaySize() returns a negative value for BLOB columns for client</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2406">DERBY-2406</a></td><td>XAResource.end does not set the XA transaction state correctly when the XAException is thrown</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2400">DERBY-2400</a></td><td>Javadoc - clean up Cloudscape references in javadoc</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2391">DERBY-2391</a></td><td>"Derby and standards" section of Developer's Guide needs reorganization</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2390">DERBY-2390</a></td><td>DOCS - Merge Working with Derby and Getting Started Guide</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2387">DERBY-2387</a></td><td>DOCs - Reorder the topics in the Ref Manual into Alphabetical order - functions, procedures</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2386">DERBY-2386</a></td><td>timestampdiff function fails when using SQL_TSI_FRAC_SECOND for datepart parameter, except for very small intervals</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2383">DERBY-2383</a></td><td>ReuseFactory should use the constants in java.lang.Boolean</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2381">DERBY-2381</a></td><td>ParameterMappingTest fails due to ArrayIndexOutOfBoundsException executing a procedure</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2377">DERBY-2377</a></td><td>Document language based ordering which will be implemented by code related sub-tasks of DERBY-1478.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2376">DERBY-2376</a></td><td>Patch available to make .classpath entries portable - relative to ECLIPSE_HOME</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2372">DERBY-2372</a></td><td>Document the secure-by-default network server</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2371">DERBY-2371</a></td><td>Setting a default value for a VARCHAR column fails when column contains data</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2370">DERBY-2370</a></td><td>EXISTS may return the wrong value for sub-queries involving set operations</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2369">DERBY-2369</a></td><td>NetworkServerControl.shutdown() takes at least 1.5 seconds, could be faster.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2365">DERBY-2365</a></td><td>Brushing up pages for MAX and MIN in Derby Reference Manual</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2364">DERBY-2364</a></td><td>improve documentation to explain logged/unlogged operations</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2361">DERBY-2361</a></td><td>Documentation should give examples for using the different security mechanisms</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2355">DERBY-2355</a></td><td>Wrong URL in Eclipse-Plugin Lab Example Jays.java</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2350">DERBY-2350</a></td><td>Use of XML values in the action statement of a trigger throw exceptions.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2331">DERBY-2331</a></td><td>Disallow code in installed jars from resolving classes in the org.apache.derby.* namespace except for public apis.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2330">DERBY-2330</a></td><td>Disallow user-defined SQL routines to resolve to entry points (methods in classes) in the org.apache.derby.* namespace</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2323">DERBY-2323</a></td><td>Update Graphic in Dev Guide - Embedded deployment application overview</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2301">DERBY-2301</a></td><td>Documentation of different executeBatch error handling between embedded and DerbyNetClient needed</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2296">DERBY-2296</a></td><td>getProperties method deprecated on ClientDataSource</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2281">DERBY-2281</a></td><td>Update the Tuning Guide figure about using the statement cache</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2279">DERBY-2279</a></td><td>JDBC3 driver is loaded instead of JDBC4 when running with jdk1.7</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2275">DERBY-2275</a></td><td>XSLT changes for PDF output</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2272">DERBY-2272</a></td><td>SSL Documentation</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2263">DERBY-2263</a></td><td>Update the copyright dita files to mark Derby logo images as non-substantive images (for accessibility)</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2262">DERBY-2262</a></td><td>DatabaseMetaData.getTypeInfo returns incorrect MAXIMUM_SCALE value for DECIMAL and NUMERIC types</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2260">DERBY-2260</a></td><td>DatabaseMetaData.getTypeInfo() returns incorrect precision for VARCHAR FOR BIT DATA</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2259">DERBY-2259</a></td><td>DatabaseMetaData.getTypeInfo() SEARCHABLE column returns incorrect information for types that cannot be searched.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2258">DERBY-2258</a></td><td>DatabaseMetaData.getTypeInfo() does not list supported Derby SQL types correctly.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2256">DERBY-2256</a></td><td>Wrong Results: Use of decimal values in an IN-list with INTEGER left operand can lead to extra rows.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2244">DERBY-2244</a></td><td>DatabaseMetaData.supportsExpressionsInOrderBy() returns false</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2243">DERBY-2243</a></td><td>DatabaseMetaData.supportsANSI92EntryLevelSQL() returns false for embedded, true for client driver</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2237">DERBY-2237</a></td><td>Cleanup copyrights in the DITA source and generated docs</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2230">DERBY-2230</a></td><td>AssertFailure: ByteCode Conditional then/else stack mismatch</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2228">DERBY-2228</a></td><td>Support Derby on J2ME/CDC/Foundation 1.1</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2226">DERBY-2226</a></td><td>Move column bitset computation to IndexToBaseRowNode</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2223">DERBY-2223</a></td><td>Let BasePage.fetchFieldFromSlot use the special single-col FetchDescriptor ctor</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2222">DERBY-2222</a></td><td>'show indexes in SCHEMANAME' does not work with the client driver</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2220">DERBY-2220</a></td><td>Uncommitted transactions executed throught XAResource will held locks after the application terminates (or crashes during the transaction).</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2218">DERBY-2218</a></td><td>Null Pointer Exception when an untyped NULL subquery ("values null") appears outside of the FROM list in a SELECT query.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2216">DERBY-2216</a></td><td>Allow demo SimpleApp to work in J2ME environment</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2214">DERBY-2214</a></td><td>Fix Getting Started file to reflect classpath change</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2208">DERBY-2208</a></td><td>setNetworkServerCP scripts need not add derby.jar into the CLASSPATH</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2202">DERBY-2202</a></td><td>DROP PROCEDURE depends on SET SCHEMA</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2195">DERBY-2195</a></td><td>Nested triggers not working properly after maximum trigger count exception is thrown</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2193">DERBY-2193</a></td><td>[import] ERROR 38000: StringIndexOutOfBoundsException was thrown while evaluating an expression.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2191">DERBY-2191</a></td><td>Cleanup of FormatableBitSet</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2183">DERBY-2183</a></td><td>Trigger recompilation problem when trigger action has its table not qualified with a schema</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2166">DERBY-2166</a></td><td>Implement proper handling of SocketTimeoutException in DRDAConnThread</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2152">DERBY-2152</a></td><td>Support diagnostic vti tables that take parameters, such as SpaceTable</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2150">DERBY-2150</a></td><td>Reduce use of synchronized collections in GenericLanguageConnectionContext</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2149">DERBY-2149</a></td><td>Replace Vectors and Hashtables with ArrayLists and HashMaps in RAMTransaction</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2147">DERBY-2147</a></td><td>LIKE predicate does not accept a pure column reference as righthand operand (gives ERROR 42824)</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2141">DERBY-2141</a></td><td>BlobClob4BlobTest.testPositionBlob() fails with NullPointerException</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2138">DERBY-2138</a></td><td>Remove DataDictionaryContext and associated code</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2137">DERBY-2137</a></td><td>CALL (PROCEDURE) statement documentation in reference manual has incomplete syntax for arguments</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2124">DERBY-2124</a></td><td>Incorrect method name in error message for Connection.setTransactionIsolation method</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2123">DERBY-2123</a></td><td>Remove workaround for old JIT bug from StoredPage</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2122">DERBY-2122</a></td><td>Optimize ContainerLock.isCompatible()</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2121">DERBY-2121</a></td><td>Remove JDK 1.3 build dependency in network server</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2118">DERBY-2118</a></td><td>Change some boundary checks in ArrayInputStream to ASSERTs to improve performance</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2114">DERBY-2114</a></td><td>Let Clock embed a HashMap rather than inherit from Hashtable</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2112">DERBY-2112</a></td><td>Nullpointer on executeBatchRequestX when preparedStatement has no parameters</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2107">DERBY-2107</a></td><td>Move page latching out of the lock manager</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2103">DERBY-2103</a></td><td>After a Lexical Error due to syntax error , even a simple create table does not work on the same connection.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2099">DERBY-2099</a></td><td>Make BasePage.getPageId() final</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2096">DERBY-2096</a></td><td>Change the Parser.parserStatement() to return the more specific StatementNode instead of QueryTreeNode.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2093">DERBY-2093</a></td><td>Error in initSlotTable() can cause NPE or ASSERT rather than reporting page number in corrupt page message.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2088">DERBY-2088</a></td><td>Update the documentation templates. Add comment about changing the reference ID</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2083">DERBY-2083</a></td><td>Shutting down a database loaded from a jar leaves an open file reference to the jar file containing the database.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2067">DERBY-2067</a></td><td>Assert failure in EmbedConnection.restoreContextStack() when running lang/closed.java</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2060">DERBY-2060</a></td><td>SET CURRENT ISOLATION in ref.man refers java.sql.Connection.setTransactionLevel instead of java.sql.Connection.setTransactionIsolation</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2057">DERBY-2057</a></td><td>SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE documentation or implementation error on its arguments.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2053">DERBY-2053</a></td><td>Dev Guide: Syntax errors in SQL tips -&gt; Tricks of the VALUES clause -&gt; Multiple rows</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2050">DERBY-2050</a></td><td>Manipulating CachedItems could be more efficient</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2046">DERBY-2046</a></td><td>Make class org.apache.derby.iapi.store.raw.PageKey final</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2042">DERBY-2042</a></td><td>Provide documentation for new RENAME COLUMN statement</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2040">DERBY-2040</a></td><td>Setting derby.database.classpath to contain installed jars causes the database to be unbootable when a Securitymanager is installed.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2019">DERBY-2019</a></td><td>IJ's describe command does not handle quotes very well</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2018">DERBY-2018</a></td><td>NullPointerException in CREATE VIEW ... VALUES NULL;</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-2001">DERBY-2001</a></td><td>Add DITA templates for the 3 topic types into the trunk</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1995">DERBY-1995</a></td><td>Add base schema scripts for order entry</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1993">DERBY-1993</a></td><td>Check in the demo used by the Java in the Database session at Apachecon 2006</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1983">DERBY-1983</a></td><td>Change build system so that base level is JDK 1.4</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1965">DERBY-1965</a></td><td>NetworkServerControlImpl never closes the socket or streams it opens in setUpSocket.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1964">DERBY-1964</a></td><td>Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1959">DERBY-1959</a></td><td>10.2 'Derby Developer's Guide' error/ambiguity.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1956">DERBY-1956</a></td><td>Remove stale code from the statement classes in the client driver</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1955">DERBY-1955</a></td><td>Unquoted path in .bat files may cause errors (Win)</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1953">DERBY-1953</a></td><td>Make FOR EACH clause and MODE DB2SQL in CREATE TRIGGER statement optional</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1949">DERBY-1949</a></td><td>locate function documentation should clarify behavior when first parameter is empty string</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1947">DERBY-1947</a></td><td>OutOfMemoryError after repeated calls to boot and shutdown a database</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1942">DERBY-1942</a></td><td>There exists difference between behavior of setNull(Types.TIME) and setTiime(null).</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1935">DERBY-1935</a></td><td>Reference Manual - Derby Limitations</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1934">DERBY-1934</a></td><td>Reference Manual updates - J2EE Compliance: Java Transaction API and javax.sql Extensions</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1930">DERBY-1930</a></td><td>Move JDBC implementation notes into the published javadoc</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1929">DERBY-1929</a></td><td>SYSTABLEPERMS and SYSCOLPERMS documentation needs to be updated</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1928">DERBY-1928</a></td><td>Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1926">DERBY-1926</a></td><td>Provide documentation for ALTER TABLE DROP COLUMN</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1922">DERBY-1922</a></td><td>readme.html under frameworks does not mention about Derby client and some minor typos in example.html</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1920">DERBY-1920</a></td><td>DOCS - Improve topic titles for vague and duplicate topics</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1919">DERBY-1919</a></td><td>Top level index.html page should link to release notes and other items in top-level of a release.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1918">DERBY-1918</a></td><td>INCREMENT of IDENTITY column described as allowing a value of zero in reference manual</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1917">DERBY-1917</a></td><td>Clob.position fails with Embedded driver and large Clobs</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1890">DERBY-1890</a></td><td>improve XSDFI error message</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1879">DERBY-1879</a></td><td>Save meta data related information for an EmbedResultSet at the plan level instead of the ResultSet level improves performance.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1868">DERBY-1868</a></td><td>Merge argument descriptors into SQLState strings so that SQLState documentation can be generated by a program</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1861">DERBY-1861</a></td><td>Column ordering ASSERT when combining column references and expressions in same ORDER BY</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1852">DERBY-1852</a></td><td>Wrong results: duplicate rows returned for nested UNIONs when they should be eliminated.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1847">DERBY-1847</a></td><td>SELECT statement asserts with XJ001 when attempted to select a newly added column in SQL authorization mode</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1828">DERBY-1828</a></td><td>Access rule violations should use a SQL state starting with '42' according to the SQL standard.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1822">DERBY-1822</a></td><td>LOCK TABLE example and description in reference manual should get replaced by a 'real' example</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1816">DERBY-1816</a></td><td>Client's ResultSet.getTime() on a SQL TIMESTAMP column loses the sub-second resolution and always has a milli-second value of zero.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1815">DERBY-1815</a></td><td>In admin guide examples to start network server on windows with .bat scripts, $DERYBY_INSTALL Is used , I think it should be %DERBY_INSTALL%</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1805">DERBY-1805</a></td><td>Links to element ids inside a topic are broken in PDFs and HTML Books</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1797">DERBY-1797</a></td><td>Building toursdb would go a little faster if it used autocommit off mode.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1795">DERBY-1795</a></td><td>Graphics not copied over for PDF and HTML-single manuals</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1765">DERBY-1765</a></td><td>Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1753">DERBY-1753</a></td><td>Doc for SYSCS_INPLACE_COMPRESS_TABLE has incorrect procedure name in the java examples.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1752">DERBY-1752</a></td><td>Fix javadoc to account for changes required by new licence header policy.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1709">DERBY-1709</a></td><td>Deprecate scripts in frameworks directory</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1673">DERBY-1673</a></td><td>Compling with jikes not longer works due to recent changes that added -target -source command line flags to each compile</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1665">DERBY-1665</a></td><td>Incorrect JavaDoc for Qualifier interface</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1662">DERBY-1662</a></td><td>Document derbyrun.jar</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1644">DERBY-1644</a></td><td>NPE when inserting values to a table that has a column declared as generated by default as identity</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1624">DERBY-1624</a></td><td>use of direct column name rather than alias make aggregation fail (Hibernate depends on that)</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1623">DERBY-1623</a></td><td>Add ANSI TRIM implementation</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1620">DERBY-1620</a></td><td>SQL CASE statement returns ERROR 42X89 when including NULL as a return value</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1610">DERBY-1610</a></td><td>Resolve difference of type compatibility between Embedded and NetworkServer/NetworkDriver</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1590">DERBY-1590</a></td><td>Consolidate the *conrefs.dita files in the documentation source tree to a single file.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1589">DERBY-1589</a></td><td>CREATE TABLE throws NullPointerException in Derby SQL Standard Authorization after DROPs and REVOKES</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1588">DERBY-1588</a></td><td>Link "Getting Started...." and "Apache Derby Server ...." in demo.html needs to be linked to actual documents instead of manuals page</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1570">DERBY-1570</a></td><td>The derby configuration, logging and diagnostic properties such as derby.language.logStatementText are hard to find in the documentation</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1535">DERBY-1535</a></td><td>Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1526">DERBY-1526</a></td><td>build should be able to locate the Java runtime libraries from properties not sourced from ${user.home}, but inside the current subversion checkout.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1520">DERBY-1520</a></td><td>Document new SYSCS_DIAG tables</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1519">DERBY-1519</a></td><td>'setAsciiStream' uses different encodings for embedded and client</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1501">DERBY-1501</a></td><td>PreparedStatement#setNull(int parameterIndex, int sqlType) throws SQL Exception if given sqlType is LONGVARBINARY in embedded mode</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1494">DERBY-1494</a></td><td>PreparedStatement.setNull(int, int) checks type compatibility on embedded, but not on the client</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1490">DERBY-1490</a></td><td>Provide ALTER TABLE RENAME COLUMN functionality</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1489">DERBY-1489</a></td><td>Provide ALTER TABLE DROP COLUMN functionality</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1484">DERBY-1484</a></td><td>Client and embedded behave differently when the table name is null in DatabaseMetaData methods</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1440">DERBY-1440</a></td><td>jdk 1.6 client driver omits SQLStates and chained exceptions in error messages</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1434">DERBY-1434</a></td><td>Client can send incorrect database name to server after having made multiple connections to different databases.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1381">DERBY-1381</a></td><td>Document ij.exceptionTrace property</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1377">DERBY-1377</a></td><td>Update copyright headers to comply with new ASF policy</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1355">DERBY-1355</a></td><td>ClientDriver ResultSetMetaData.isAutoIncrement(column) always returns false</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1285">DERBY-1285</a></td><td>Finish JDBC3 Blob implementation</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1275">DERBY-1275</a></td><td>Provide a way to enable client tracing without changing the application</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1132">DERBY-1132</a></td><td>Truncation Error with Concat</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-1054">DERBY-1054</a></td><td>Starting Derby with the NetServlet inside of tomcat does not allow binding to non localhost interface.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-931">DERBY-931</a></td><td>Until DERBY-911 gets fixed, document the difference in behavior between Nework Client Driver and Embedded Driver for setReadOnly</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-908">DERBY-908</a></td><td>YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-815">DERBY-815</a></td><td>Prevent unneeded object creation and excessive decoding in parseSQLDTA_work()</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-806">DERBY-806</a></td><td>One each deleted or updated from a heap row a new RowPosition object is created.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-801">DERBY-801</a></td><td>Allow parallel access to data files.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-790">DERBY-790</a></td><td>SQLException used by the networked interface to Derby is not serializable</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-729">DERBY-729</a></td><td>Scalar time and date functions return 0 instead NULL when argument is NULL</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-681">DERBY-681</a></td><td>Eliminate the parser's rewriting of the abstract syntax tree for queries with GROUP BY and/or HAVING clauses</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-680">DERBY-680</a></td><td>In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-630">DERBY-630</a></td><td>create trigger fails with null pointer exception</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-606">DERBY-606</a></td><td>SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE fails on (very) large tables</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-595">DERBY-595</a></td><td>Using derby.language.logStatementText=true can mask certain exceptions and lead to incorrect behavior in some cases</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-552">DERBY-552</a></td><td>Fetching resources using getResourceAsStream from a jar stored in a database that is archived in a jar file fails</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-538">DERBY-538</a></td><td>Investigate using the standard java.net.URLClassLoader for database class loading.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-537">DERBY-537</a></td><td>SQLJ.INSTALL_JAR and SQLJ.UPDATE_JAR fail when running with a SecurityManager enabled.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-415">DERBY-415</a></td><td>sysinfo with -cp client option should not print error saying DB2 jar file and driver class are missing</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-396">DERBY-396</a></td><td>Support for ALTER STATEMENT to DROP , MODIFY, RENAME a COLUMN</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-391">DERBY-391</a></td><td>Tools and Utilities guide does not document ij.datasource, ij.user, nor ij.password</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-378">DERBY-378</a></td><td>support for import/export of tables with clob/blob and the other binary data types will be good addition to derby,</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-264">DERBY-264</a></td><td>This enhancement to allow expressions in ORDER BY clause will require documentation changes.</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-234">DERBY-234</a></td><td>Documentation of DateTime types is incomplete</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-208">DERBY-208</a></td><td>Add support to retrieve lobs for Network Server by locator rather than matierializing the LOB</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-183">DERBY-183</a></td><td>Parameter names required in CREATE FUNCTION</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-147">DERBY-147</a></td><td>ERROR 42X79 not consistant ? - same column name specified twice</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-64">DERBY-64</a></td><td>Create a table with a query</td>
+</tr>
+<tr>
+<td><a class="external" href="http://issues.apache.org/jira/browse/DERBY-47">DERBY-47</a></td><td>Some possible improvements to IN optimization</td>
+</tr>
+</table>
+</div>
+<a name="N10926"></a><a name="Issues"></a>
+<h2 class="boxed">Issues</h2>
+<div class="section">
+<p>Compared with the previous release (10.2.2.0), Derby release 10.3.1.4 introduces the following new features and incompatibilities. These merit your special attention.</p>
+<hr>
+<a name="N1092E"></a><a name="Note+for+DERBY-2925"></a>
+<h3 class="boxed">Note for DERBY-2925</h3>
+<p>
+<strong>Summary of Change</strong>
+</p>
+<p>Prevent export from overwriting existing files</p>
+<p>
+<strong>Symptoms Seen by Applications Affected by Change</strong>
+</p>
+<p>Due to security concerns, and to avoid accidental file damage, Export processing will not overwrite existing files. As a result, applications may observe some behavioral changes with respect to Export operations.</p>
+<p>
+<strong>Incompatibilities with Previous Release</strong>
+</p>
+<ol>
+<li>SYSCS_UTIL.SYSCS_EXPORT_TABLE: Exports of all the data from a table to an existing file is no longer possible and the user/application must remove the existing file, otherwise ERROR XIE0S will be returned.</li>
+<li>SYSCS_UTIL.SYSCS_EXPORT_QUERY: Exports of all the data returned from the SELECT statement to an existing file is no longer possible and the user/application must remove the existing file, otherwise ERROR XIE0S will be returned.</li>
+<li>SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE: Export of the result of a SELECT statement to a main data output file, and the LOB data into a large object auxiliary file to an existing file is no longer possible and the user/application must remove the existing data file and/or large object auxiliary file, otherwise ERROR XIE0S will be returned if the data file exists or ERROR XIE0T will be returned if the large object auxiliary file exists.</li>
+</ol>
+<br>
+<br>
+<p>
+<strong>Rationale for Change</strong>
+</p>
+<p>Due to security concerns and to avoid accidental file damage, Export processing will no longer overwrite an existing file.</p>
+<p>
+<strong>Application Changes Required</strong>
+</p>
+<p>The application needs to specify a different filename which does not exist or delete the existing file before performing the Export operation.</p>
+<hr>
+<a name="N10954"></a><a name="Note+for+DERBY-2757"></a>
+<h3 class="boxed">Note for DERBY-2757</h3>
+<p>
+<strong>Summary of Change</strong>
+</p>
+<p>Security enhancements to the Network Server may slow down Derby's runtime performance, and they may trigger SecurityExceptions when Derby executes user-written functions and procedures.</p>
+<p>
+<strong>Symptoms Seen by Applications Affected by Change</strong>
+</p>
+<p>Startup performance for networked applications may degrade after upgrading to 10.3. In addition, after upgrade, user-written functions and procedures may raise SecurityExceptions.</p>
+<p>
+<strong>Incompatibilities with Previous Release</strong>
+</p>
+<p>In previous releases, the Network Server booted without installing a default security manager. Now, the Network Server installs a security manager if the user forgets to. Application startup may slow down as the security manager performs initial access checks on Derby tables. Once all user tables have been touched, the application should reach steady state and the drag induced by the security manager should be negligible.</p>
+<p>In addition, SecurityExceptions may occur if user-written functions and procedures perform sensitive operations such as reading/writing files and getting/setting system properties.</p>
+<p>
+<strong>Rationale for Change</strong>
+</p>
+<p>In a client/server configuration, it is particularly important to protect against other users' mistakes and hacking. Derby is enhancing security for this configuration. Now if you neglect to configure a Java security manager, the Network Server attempts to install its own security manager with a default policy.</p>
+<p>
+<strong>Application Changes Required</strong>
+</p>
+<p>SecurityExceptions can be avoided by installing your own security manager with your own policy file, which grants the appropriate privileges to your user-written code. Instructions on how to do this can be found in the Derby Developer's Guide in the section titled "Running Derby under a security manager" and in the Derby Server and Administration Guide in the section titled "Running the Network Server under the security manager".</p>
+<p>If for some reason this is not practical, or if the startup performance drag is intolerable, then you can instruct the server to not install a security manager. You do this by booting the server with the "-noSecurityManager" command line option as explained in above-mentioned section of the Derby Server and Administration Guide.</p>
+<hr>
+<a name="N10977"></a><a name="Note+for+DERBY-2729"></a>
+<h3 class="boxed">Note for DERBY-2729</h3>
+<p>
+<strong>Summary of Change</strong>
+</p>
+<p>Blob and Clob objects are released when the transaction ends and when the connection is closed.</p>
+<p>
+<strong>Symptoms Seen by Applications Affected by Change</strong>
+</p>
+<p>Applications now get a SQLException with SQL STATE XJ215 when accessing Blobs and Clobs after the transaction ends or the connection is closed.</p>
+<p>
+<strong>Incompatibilities with Previous Release</strong>
+</p>
+<p>In the previous release, Blobs and Clobs were sometimes usable even after the transaction ended or the connection was closed. Now Blobs and Clobs are not usable after these events.</p>
+<p>
+<strong>Rationale for Change</strong>
+</p>
+<p>Now Blobs and Clobs store their data in temporary files. These temporary files are deleted when the transaction ends. The Blob.free() and Clob.free() methods also delete these temporary files. This erases the transient state of these large objects and makes them unusable.</p>
+<p>
+<strong>Application Changes Required</strong>
+</p>
+<p>Applications should be revised to not use Blobs and Clobs after the transaction ends or the connection is closed.</p>
+<hr>
+<a name="N10996"></a><a name="Note+for+DERBY-2610"></a>
+<h3 class="boxed">Note for DERBY-2610</h3>
+<p>
+<strong>Summary of Change</strong>
+</p>
+<p>The table name can no longer be a pattern in calls to DatabaseMetaData methods getBestRowIdentifier, getColumnPrivileges, getIndexInfo, getVersionColumns, getPrimaryKeys, getImportedKeys, getExportedKeys and getCrossReference.</p>
+<p>
+<strong>Symptoms Seen by Applications Affected by Change</strong>
+</p>
+<p>In the previous release, the methods returned information on all tables that matched the pattern in the schema. A table name value of null was treated as a wildcard. Table names now have to match what is stored in the database.</p>
+<p>
+<strong>Incompatibilities with Previous Release</strong>
+</p>
+<p>Calls to the specified methods now fail if the table name parameter is a pattern (no information is returned).</p>
+<p>
+<strong>Rationale for Change</strong>
+</p>
+<p>The previous behavior violated the JDBC standard. The new behavior is correct.</p>
+<p>
+<strong>Application Changes Required</strong>
+</p>
+<p>Users must recode applications to specify the table names. When information on multiple tables is required, the application first has to get the table names, e.g. by using the DatabaseMetaData method getTables(), and then use the returned table names as input to the method in question.</p>
+<hr>
+<a name="N109B5"></a><a name="Note+for+DERBY-2526"></a>
+<h3 class="boxed">Note for DERBY-2526</h3>
+<p>
+<strong>Summary of Change</strong>
+</p>
+<p>Queries which use the JOIN ... ON syntax to join with views or other non-base table expressions may now return different results.<br>
+</p>
+<p>
+<strong>Symptoms Seen by Applications Affected by Change</strong>
+</p>
+<p>Applications which use the explicit JOIN ... ON syntax to perform joins between three or more FROM expressions, at least one of which is a view, subquery, or other non-base table expression, may have been seeing incorrect results prior to this release.<br>
+</p>
+<p>As an example, take the following:<br>
+</p>
+<p>create table t1 (c0 int);<br> create table x (c1 int, c2 int);<br> create table t2 (c3 int, c4 int);<br>
+<br> insert into t1 values 1;<br> insert into x values (0, 1);<br> insert into t2 values (0, 2);<br>
+<br>
+<br>
+<br>
+<br>
+<br>
+</p>
+<p>With these tables, the following query should return one row, but was returning zero rows in previous releases:<br>
+</p>
+<p>select t1.* from t1 JOIN (select * from x) vw(c1,c2) ON (t1.c0 = vw.c2) JOIN t2 ON (vw.c1 = t2.c3)<br>
+<br>
+</p>
+<p>This problem has been fixed in Derby 10.3.</p>
+<p>
+<strong>Incompatibilities with Previous Release</strong>
+</p>
+<p>The fix for the bug shown above does not introduce any functional incompatibilities. However, applications may now see different results if they happen to use queries that rely on the JOIN ... ON syntax to join with views, subqueries, or other non-base table expressions.</p>
+<p>
+<strong>Rationale for Change</strong>
+</p>
+<p>Due to an error in column reference mappings, it was possible for earlier versions of Derby to confuse ON predicate column references with each other, thereby leading to incorrect computation of transitive closure. This in turn could lead to the addition of invalid predicates to the query, which caused wrong results in certain cases.<br>
+</p>
+<p>By fixing this bug we ensure that the affected queries will always return the correct results.<br>
+</p>
+<p>
+<strong>Application Changes Required</strong>
+</p>
+<p>No application changes should be needed.<br>
+</p>
+<hr>
+<a name="N109FA"></a><a name="Note+for+DERBY-2443"></a>
+<h3 class="boxed">Note for DERBY-2443</h3>
+<p>
+<strong>Summary of Change</strong>
+</p>
+<p>Added unimplemented methods introduced in the java.sql.ResultSet interface.</p>
+<p>
+<strong>Symptoms Seen by Applications Affected by Change</strong>
+</p>

[... 704 lines stripped ...]


Mime
View raw message