You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@db.apache.org by bp...@apache.org on 2016/09/28 01:33:44 UTC
svn commit: r998438 [3/6] - in /websites/production/db/content/derby: ./
blogs/ dev/ integrate/ manuals/ papers/ papers/DerbyTut/ releases/ skin/
Modified: websites/production/db/content/derby/papers/JDBCImplementation.html
==============================================================================
--- websites/production/db/content/derby/papers/JDBCImplementation.html (original)
+++ websites/production/db/content/derby/papers/JDBCImplementation.html Wed Sep 28 01:33:43 2016
@@ -3,9 +3,8 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
-<meta name="generator" content="">
<meta name="" content="">
<meta name="GENERATOR" content="">
<meta name="CREATED" content="">
@@ -323,6 +322,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Derby JDBC Implementation Notes</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -453,7 +453,8 @@ document.write("Last Published: " + docu
</li>
</ul>
</div>
-<a name="N10049"></a><a name="Overview"></a>
+</div>
+<a name="Overview"></a>
<h2 class="boxed">Overview</h2>
<div class="section">
<p>The JDBC specification is sometimes unclear or contradictory. This document covers how Derby implements some JDBC features where the specification might be unclear.</p>
@@ -465,38 +466,38 @@ document.write("Last Published: " + docu
<p>[TUTORIAL3] – JDBC API Tutorial and Reference, Third Edition. ISBN 0321173848 <a class="external" href="http://java.sun.com/developer/Books/jdbc/Fisher/index.html">http://java.sun.com/developer/Books/jdbc/Fisher/index.html</a>
</p>
</div>
-<a name="N10060"></a><a name="Java.sql.Connection"></a>
+<a name="Java.sql.Connection"></a>
<h2 class="boxed">Java.sql.Connection</h2>
<div class="section">
-<a name="N10064"></a><a name="CreateStatement%2C+prepareStatement+and+prepareCall"></a>
+<a name="CreateStatement%2C+prepareStatement+and+prepareCall"></a>
<h3 class="boxed">CreateStatement, prepareStatement and prepareCall</h3>
<p>Behavior Clarification</p>
<p>CONCUR_UPDATABLE concurrency is supported for FORWARD ONLY ResultSet types only.</p>
</div>
-<a name="N1006C"></a><a name="Java.sql.PreparedStatement"></a>
+<a name="Java.sql.PreparedStatement"></a>
<h2 class="boxed">Java.sql.PreparedStatement</h2>
<div class="section">
-<a name="N10070"></a><a name="setAsciiStream%2CsetBinaryStream%2CsetCharacterStream"></a>
+<a name="setAsciiStream%2CsetBinaryStream%2CsetCharacterStream"></a>
<h3 class="boxed">setAsciiStream,setBinaryStream,setCharacterStream</h3>
<p>Behavior Clarification</p>
<p>In Derby, the stream must have the exact amount of data as the length argument, otherwise an exception with the following message 'Input Stream did not have exact amount of data as the requested length' is thrown.</p>
<p>Stream parameter values are not re-used. The JDBC 3.0 specification says in the last paragraph of 13.2.2 that parameters are re-used but nothing special about streams. However javadoc for java.sql.PreparedStatement.clearParamters() says 'In general, parameter values remain in force for repeated use of a statement'. Maybe 'in general' can be interpreted to mean 'except for streams'. Stream parameter values are not re-used and if a stream is re-used, the statement execution will fail with 'Stream has already been read and end-of-file reached and cannot be re-used.'.</p>
</div>
-<a name="N1007A"></a><a name="Java.sql.ResultSet"></a>
+<a name="Java.sql.ResultSet"></a>
<h2 class="boxed">Java.sql.ResultSet</h2>
<div class="section">
<p>Support for data conversion using the getXXX() methods matches Table B-6 in the [JDBC3], with some extensions described below.</p>
<p>Extension</p>
<p>If the value column is null, then generally any getXXX method can be used to fetch the null value and a null or a representation of zero will be returned and a subsequent call to wasNull() will return true. It is not recommended that applications take advantage of this liberal conversion of SQL NULL values, use of a getXXX() method that works against NULL and non-NULL values is strongly recommended.</p>
-<a name="N10084"></a><a name="deleteRow%28%29"></a>
+<a name="deleteRow%28%29"></a>
<h3 class="boxed">deleteRow()</h3>
<p>Behavior Clarification</p>
<p>After deleteRow, ResultSet will be positioned right before the next row for FORWARD ONLY updatable ResultSets.</p>
-<a name="N1008C"></a><a name="updateRow%28%29"></a>
+<a name="updateRow%28%29"></a>
<h3 class="boxed">updateRow()</h3>
<p>Behavior Clarification</p>
<p>After updateRow, ResultSet will be positioned right before the next row for FORWARD ONLY updatable ResultSets.</p>
-<a name="N10094"></a><a name="GetAsciiStream%28%29"></a>
+<a name="GetAsciiStream%28%29"></a>
<h3 class="boxed">GetAsciiStream()</h3>
<p>Behavior Clarification</p>
<p>An ASCII character is defined as an eight bit character (range 0x00 to 0xff), see CHAR() function definition by [JDBC3] in appendix C.2.</p>
@@ -514,11 +515,11 @@ document.write("Last Published: " + docu
</li>
</ul>
<p>This method is not recommended to use in Derby.<br>Because Derby handles characters as unicode internally , there is no advantage in using this method .</p>
-<a name="N100AE"></a><a name="GetBinaryStream%28%29"></a>
+<a name="GetBinaryStream%28%29"></a>
<h3 class="boxed">GetBinaryStream()</h3>
<p>Extensions</p>
<p>On Types.BLOB columns returns a stream with identical contents to that returned by getBlob().getBinaryStream() on the same column if the BLOB value is not NULL. If the BLOB value is NULL then null is returned.</p>
-<a name="N100B6"></a><a name="GetCharacterStream%28%29"></a>
+<a name="GetCharacterStream%28%29"></a>
<h3 class="boxed">GetCharacterStream()</h3>
<p>Behavior Clarification</p>
<p>For binary types (Types.BINARY, Types.VARBINARY, and Types.LONGVARBINARY, Types.BLOB) getString() the value is converted to a stream of characters as though it is encoded using UTF-16BE.</p>
@@ -533,7 +534,7 @@ document.write("Last Published: " + docu
<p>On Types.BLOB columns supported with conversion as a binary type.</p>
</li>
</ul>
-<a name="N100C8"></a><a name="GetString%28%29"></a>
+<a name="GetString%28%29"></a>
<h3 class="boxed">GetString()</h3>
<p>Behavior Clarification</p>
<p>For binary types (Types.BINARY, Types.VARBINARY, and Types.LONGVARBINARY, Types.BLOB) getString() returns String containing a two character hexadecimal representation for every byte in a non-null value. The two characters are in the range ‘0’ – ‘9’ and ‘a’ – ‘f’. For NULL values, null is returned. Note, that this String does not match the contents of the stream returned by getAsciiStream or getCharacterStream on the same column.</p>
@@ -548,10 +549,10 @@ document.write("Last Published: " + docu
<p>On Types.BLOB columns supported with conversion as a binary type.</p>
</li>
</ul>
-<a name="N100DA"></a><a name="GetUnicodeStream%28%29"></a>
+<a name="GetUnicodeStream%28%29"></a>
<h3 class="boxed">GetUnicodeStream()</h3>
<p>Not implemented, deprecated by [JDBC3].</p>
-<a name="N100E0"></a><a name="Examples"></a>
+<a name="Examples"></a>
<h3 class="boxed">Examples</h3>
<p>Binary Column</p>
<p>If a binary column has been set with the Java byte array containing fours bytes, byte[] data = {0x34, 0x87, 0xc2, 0x1f} then:</p>
@@ -580,43 +581,43 @@ document.write("Last Published: " + docu
</ul>
</div>
</div>
-<a name="N100FD"></a><a name="java.sql.Blob"></a>
+<a name="java.sql.Blob"></a>
<h2 class="boxed">java.sql.Blob</h2>
<div class="section">
-<a name="N10101"></a><a name="getBytes%28int+pos%2C+int+length%29"></a>
+<a name="getBytes%28int+pos%2C+int+length%29"></a>
<h3 class="boxed">getBytes(int pos, int length)</h3>
<p>Behavior Clarification</p>
<p>If the pos (position) argument is greater than the length of the BLOB then an exception is thrown. This matches the semantics of the SQL SUBSTR function.</p>
-<a name="N10109"></a><a name="position%28byte+pattern%2C+int+start%29+and+position%28Blob+pattern%2C+int+start%29"></a>
+<a name="position%28byte+pattern%2C+int+start%29+and+position%28Blob+pattern%2C+int+start%29"></a>
<h3 class="boxed">position(byte pattern, int start) and position(Blob pattern, int start)</h3>
<p>Behavior Clarification</p>
<p>If the pattern argument has length zero, then the value of start argument will be returned. This matches the semantics of the SQL LOCATE function.</p>
</div>
-<a name="N10111"></a><a name="java.sql.Clob"></a>
+<a name="java.sql.Clob"></a>
<h2 class="boxed">java.sql.Clob</h2>
<div class="section">
-<a name="N10115"></a><a name="getSubString%28int+pos%2C+int+length%29"></a>
+<a name="getSubString%28int+pos%2C+int+length%29"></a>
<h3 class="boxed">getSubString(int pos, int length)</h3>
<p>Behavior Clarification</p>
<p>If the pos (position) argument is greater than the length of the CLOB then an exception is thrown. This matches the semantics of the SQL SUBSTR function.</p>
-<a name="N1011D"></a><a name="position%28String+searchstr%2C+int+start%29+and"></a>
+<a name="position%28String+searchstr%2C+int+start%29+and"></a>
<h3 class="boxed">position(String searchstr, int start) andposition(Clob searchstr, int start)</h3>
<p>Behavior Clarification</p>
<p>If the searchstr argument has length zero (the empty string), then the value of start argument will be returned. This matches the semantics of the SQL LOCATE function.</p>
</div>
-<a name="N10127"></a><a name="Date+Handling"></a>
+<a name="Date+Handling"></a>
<h2 class="boxed">Date Handling</h2>
<div class="section">
-<a name="N1012B"></a><a name="Derby+SQL+DATE"></a>
+<a name="Derby+SQL+DATE"></a>
<h3 class="boxed">Derby SQL DATE</h3>
<p>Derby’s SQL DATE type represents a date in the form yyyy-mm-dd with no associated time zone information.</p>
-<a name="N10131"></a><a name="java.sql.Date"></a>
+<a name="java.sql.Date"></a>
<h4>java.sql.Date</h4>
<p>A JDBC Date (java.sql.Date) by definition represents a point in time on a given date in a given time zone.</p>
<p>[JDBC3] intends that the point in time for a java.sql.Date object is 00:00 (midnight), but this is not enforced by the class.</p>
<p>JDBC drivers are required to return java.sql.Date objects that are normalized to 00:00 according to the required time zone.</p>
<p>Applications are expected to pass in java.sql.Date instances that are normalized to 00:00 (see section 18.1.1 of [TUTORIAL3]).</p>
-<a name="N1013D"></a><a name="Conversion+of+a+JDBC+java.sql.Date+to+a+Derby+DATE+value"></a>
+<a name="Conversion+of+a+JDBC+java.sql.Date+to+a+Derby+DATE+value"></a>
<h4>Conversion of a JDBC java.sql.Date to a Derby DATE value</h4>
<ol>
<li>
@@ -647,7 +648,7 @@ document.write("Last Published: " + docu
</ol>
<p>Derby does not require that the application’s java.sql.Date value is normalized to 00:00 according to the required time zone.</p>
<p>In both cases no time zone information is stored with the SQL DATE value.</p>
-<a name="N10165"></a><a name="Conversion+of+a+Derby+DATE+value+to+a+JDBC+java.sql.Date"></a>
+<a name="Conversion+of+a+Derby+DATE+value+to+a+JDBC+java.sql.Date"></a>
<h4>Conversion of a Derby DATE value to a JDBC java.sql.Date</h4>
<ol>
<li>
@@ -673,7 +674,7 @@ document.write("Last Published: " + docu
</ul>
</li>
</ol>
-<a name="N1017E"></a><a name="Conversion+of+a+string+type+to+a+JDBC+java.sql.Date"></a>
+<a name="Conversion+of+a+string+type+to+a+JDBC+java.sql.Date"></a>
<h4>Conversion of a string type to a JDBC java.sql.Date</h4>
<p>Three different date formats are built into Derby.</p>
<div style="margin-left: 2em">
@@ -691,16 +692,16 @@ document.write("Last Published: " + docu
</div>
<p>If the format of the string matches one of the built in formats then a conversion to a java.sql.Date matches that of a SQL DATE value with value yyyy-mm-dd.</p>
<p>If the string does not match any of the built in formats Derby attempts to use the Java locale specific parser to interpret the string as a date.</p>
-<a name="N10194"></a><a name="Derby+SQL+TIME"></a>
+<a name="Derby+SQL+TIME"></a>
<h3 class="boxed">Derby SQL TIME</h3>
<p>Derby’s SQL TIME type represents a time of day in the form hh:mm:ss with no associated time zone information.</p>
-<a name="N1019A"></a><a name="java.sql.Time"></a>
+<a name="java.sql.Time"></a>
<h4>java.sql.Time</h4>
<p>A JDBC Time (java.sql.Time) by definition represents a point in time on an unspecified day in a given time zone.</p>
<p>Java.sql.Time extends java.util.date, so it includes a date. [JDBC3] intends that the date stored in a java.sql.Time be Jan 1 1970, but this is not enforced by the class.</p>
<p>JDBC drivers are required to return java.sql.Time objects that are normalized to Jan. 1 1970 according to the required time zone.</p>
<p>Applications are expected to pass in java.sql.Time instances that are normalized to Jan. 1 1970.</p>
-<a name="N101A6"></a><a name="Conversion+of+a+JDBC+java.sql.Time+to+a+Derby+TIME+value"></a>
+<a name="Conversion+of+a+JDBC+java.sql.Time+to+a+Derby+TIME+value"></a>
<h4>Conversion of a JDBC java.sql.Time to a Derby TIME value</h4>
<ol>
<li>
@@ -731,7 +732,7 @@ document.write("Last Published: " + docu
</ol>
<p>Derby does not require that the application’s java.sql.Time value be normalized to Jan 1 1970 according to the required time zone.</p>
<p>In both cases no time zone information is stored with the SQL TIME value.</p>
-<a name="N101CE"></a><a name="Conversion+of+a+Derby+TIME+value+to+a+JDBC+java.sql.Time"></a>
+<a name="Conversion+of+a+Derby+TIME+value+to+a+JDBC+java.sql.Time"></a>
<h4>Conversion of a Derby TIME value to a JDBC java.sql.Time</h4>
<ol>
<li>
@@ -757,7 +758,7 @@ document.write("Last Published: " + docu
</ul>
</li>
</ol>
-<a name="N101E7"></a><a name="Conversion+of+a+string+type+to+a+JDBC+java.sql.Time"></a>
+<a name="Conversion+of+a+string+type+to+a+JDBC+java.sql.Time"></a>
<h4>Conversion of a string type to a JDBC java.sql.Time</h4>
<p>Three different time formats are built into Derby:</p>
<div style="margin-left: 2em">
@@ -775,13 +776,13 @@ document.write("Last Published: " + docu
</div>
<p>If the format of the string matches one of the built in formats then a conversion to a java.sql.Time matches that of a SQL TIME value with value hh:mm:ss.</p>
<p>If the string does not match any of the built in formats Derby attempts to use the Java locale specific parser to interpret the string as a date.</p>
-<a name="N101FD"></a><a name="Derby+SQL+TIMESTAMP"></a>
+<a name="Derby+SQL+TIMESTAMP"></a>
<h3 class="boxed">Derby SQL TIMESTAMP</h3>
<p>Derby’s SQL TIMESTAMP type represents a time of day in the form yyyy-mm-dd hh:mm:ss.fffffffff (nanosecond granularity) with no associated time zone information.</p>
-<a name="N10203"></a><a name="java.sql.Timestamp"></a>
+<a name="java.sql.Timestamp"></a>
<h4>java.sql.Timestamp</h4>
<p>A JDBC Timestamp (java.sql.Timestamp) by definition represents a point in time, with nanosecond resolution, in a given time zone.</p>
-<a name="N10209"></a><a name="Conversion+of+a+JDBC+java.sql.Timestamp+to+a+Derby+TIMESTAMP+value"></a>
+<a name="Conversion+of+a+JDBC+java.sql.Timestamp+to+a+Derby+TIMESTAMP+value"></a>
<h4>Conversion of a JDBC java.sql.Timestamp to a Derby TIMESTAMP value</h4>
<ol>
<li>
@@ -810,7 +811,7 @@ document.write("Last Published: " + docu
</ul>
</li>
</ol>
-<a name="N10235"></a><a name="Conversion+of+a+Derby+TIMESTAMP+value+to+a+JDBC+java.sql.Timestamp"></a>
+<a name="Conversion+of+a+Derby+TIMESTAMP+value+to+a+JDBC+java.sql.Timestamp"></a>
<h4>Conversion of a Derby TIMESTAMP value to a JDBC java.sql.Timestamp</h4>
<ol>
<li>
@@ -836,7 +837,7 @@ document.write("Last Published: " + docu
</ul>
</li>
</ol>
-<a name="N1024E"></a><a name="Conversion+of+a+string+type+to+a+JDBC+java.sql.Timestamp"></a>
+<a name="Conversion+of+a+string+type+to+a+JDBC+java.sql.Timestamp"></a>
<h4>Conversion of a string type to a JDBC java.sql.Timestamp</h4>
<p>Two different timestamp formats are built into Derby:</p>
<div style="margin-left: 2em">
Modified: websites/production/db/content/derby/papers/MiscPresentations.html
==============================================================================
--- websites/production/db/content/derby/papers/MiscPresentations.html (original)
+++ websites/production/db/content/derby/papers/MiscPresentations.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Miscellaneous Derby Presentations</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -316,6 +316,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Miscellaneous Derby Presentations</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -329,9 +330,10 @@ document.write("Last Published: " + docu
</li>
</ul>
</div>
+</div>
-<a name="N1000D"></a><a name="Colorado+Software+Summit+2004"></a>
+<a name="Colorado+Software+Summit+2004"></a>
<h2 class="boxed">Colorado Software Summit 2004</h2>
<div class="section">
<p>
@@ -346,7 +348,7 @@ is available for download
</div>
-<a name="N10026"></a><a name="OSCON+2005"></a>
+<a name="OSCON+2005"></a>
<h2 class="boxed">OSCON 2005</h2>
<div class="section">
<p>
@@ -365,7 +367,7 @@ Dive with Apache Derby: Perl, PHP, and P
</div>
-<a name="N1003F"></a><a name="Victorian+Java+User+Group+2008"></a>
+<a name="Victorian+Java+User+Group+2008"></a>
<h2 class="boxed">Victorian Java User Group 2008</h2>
<div class="section">
<p>
@@ -405,7 +407,7 @@ document.write("Last Published: " + docu
</div>
<div class="copyright">
Copyright ©
- 2004-2014 Apache, Apache DB, Apache Derby, Apache Torque, Apache JDO, Apache DDLUtils, the Derby hat logo, the Apache JDO logo, and the Apache feather logo are trademarks of The Apache Software Foundation. All other marks mentioned may be trademarks or registered trademarks of their respective owners.</div>
+ 2004-2015 Apache, Apache DB, Apache Derby, Apache Torque, Apache JDO, Apache DDLUtils, the Derby hat logo, the Apache JDO logo, and the Apache feather logo are trademarks of The Apache Software Foundation. All other marks mentioned may be trademarks or registered trademarks of their respective owners.</div>
<div id="feedback">
Send feedback about the website to:
<a id="feedbackto" href="mailto:derby-user@db.apache.org?subject=Feedback%C2%A0papers/MiscPresentations.html">derby-user@db.apache.org</a>
Modified: websites/production/db/content/derby/papers/alloc-page.png
==============================================================================
Binary files - no diff available.
Modified: websites/production/db/content/derby/papers/btree_package.html
==============================================================================
--- websites/production/db/content/derby/papers/btree_package.html (original)
+++ websites/production/db/content/derby/papers/btree_package.html Wed Sep 28 01:33:43 2016
@@ -3,9 +3,8 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
-<meta name="generator" content="">
<meta name="" content="">
<title>org.apache.derby.impl.store.access.btree</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -318,6 +317,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>org.apache.derby.impl.store.access.btree</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -354,8 +354,9 @@ document.write("Last Published: " + docu
</li>
</ul>
</div>
+</div>
<p>Implements BTree access method, which is the basis for SQL indexes.</p>
-<a name="N1001B"></a><a name="Overview"></a>
+<a name="Overview"></a>
<h2 class="boxed">Overview</h2>
<div class="section">
<p>Derby implements secondary SQL indexes as BTrees. The high level features of the BTree implementation are:</p>
@@ -367,7 +368,7 @@ document.write("Last Published: " + docu
<li>Derby uses logical key deletes. This enables it to perform undos during rollbacks and restart recovery as single page operations.</li>
</ol>
</div>
-<a name="N10031"></a><a name="High+level+structure+of+the+B%2BTree"></a>
+<a name="High+level+structure+of+the+B%2BTree"></a>
<h2 class="boxed">High level structure of the B+Tree</h2>
<div class="section">
<ul>
@@ -378,12 +379,12 @@ document.write("Last Published: " + docu
<li>IndexRows are generated by the <a href="http://db.apache.org/derby/javadoc/engine/org/apache/derby/iapi/sql/dictionary/IndexRowGenerator.html">IndexRowGenerator</a>.</li>
</ul>
</div>
-<a name="N10058"></a><a name="Latching+implementation"></a>
+<a name="Latching+implementation"></a>
<h2 class="boxed">Latching implementation</h2>
<div class="section">
<p>Derby uses latches on pages to get exclusive access to the page while reading or writing the page (Derby only uses exclusive latches, no shared latches are used). In order to prevent deadlocks latches requested while holding other latches are always requested top/down and left to right. Btree splits are always left to right. If for any reason the code needs to break this protocol then it will first request the latch NOWAIT and if it can't get the latch it will release all current latches and wait for the latch it is trying to get, and then after obtaining it go about getting the other latches it needs for the particular operation. While traversing down the tree Derby may hold 2 latches: one on parent and one on child. It then continues doing "ladder" latching down the tree releasing the highest node when it has successfully got a new lower node latch. Latches are short term, only held while reading/modifying the page, never held while an I/O is happening. Structure modifications
are all isolated from other operations through the use of latches.</p>
</div>
-<a name="N1005E"></a><a name="Locking+and+Isolation+Levels"></a>
+<a name="Locking+and+Isolation+Levels"></a>
<h2 class="boxed">Locking and Isolation Levels</h2>
<div class="section">
<p>Derby uses data only locking for its logical row level locking. All isolation level implementation is done using logical locks (Derby does not support non-locking isolation such as multi-versioning).</p>
@@ -399,7 +400,7 @@ document.write("Last Published: " + docu
<dd>No row locks are acquired. The code still gets table level intent locks to prevent concurrent DDL during the query.</dd>
</dl>
</div>
-<a name="N1007F"></a><a name="BTree+Structure+Modifications"></a>
+<a name="BTree+Structure+Modifications"></a>
<h2 class="boxed">BTree Structure Modifications</h2>
<div class="section">
<p>In Derby, SMOs (structure modification operations - ie. page splits), only happen top down. This is not as concurrent as bottom up in <a class="external" href="http://www.almaden.ibm.com/u/mohan/RJ6846.pdf">ARIES/IM</a>, but is simpler. As in ARIES/IM <q>Not more than 2 index pages are held latched simultaneously at anytime. In order to improve concurrency and to avoid deadlocks involving latches, even those latches are not held while waiting for a lock wich is not immediately grantable. No data page latch is held or acquired during an index access. Latch coupling is used while traversing the tree - ie. the latch on a parent page is held while requesting a latch on a child page.</q>
@@ -408,24 +409,24 @@ document.write("Last Published: " + docu
<p>The hard case is when P does not have room for descriminator key. In this case all latches are released, and Derby does a split pass from top to bottom, and will split the internal nodes that do not have room for the decrimator key. Note this may result in more splits than necessary for this particular insert, but the assumption is that the splits will have to happen eventually anyway. After this split pass is done, the search for the insert starts again from top down, but it must once again check for space because it has given up all its latches and some other transaction may have acquired the space in the meantime.</p>
<p>Optimization is possible to remember C and see if it is right location, and/or use sideway pointers to search right rather than do research of tree.</p>
</div>
-<a name="N10091"></a><a name="Logical+Key+Deletes"></a>
+<a name="Logical+Key+Deletes"></a>
<h2 class="boxed">Logical Key Deletes</h2>
<div class="section">
<p>In both the BTree and the Heap, deletes are first executed by marking a "deleted" bit. This is to insure space on the page for abort, since row level locking will allow other rows on the page to be modified conncurrently with the transaction executing the delete. The system uses a background daemon to schedule work after commit to reclaim the space of the deleted rows. A row marked deleted can be "purged" if one can obtain a lock on it (if it was an uncommitted delete then the transaction doing the commit would still have an exclusive lock on the row).</p>
</div>
-<a name="N10097"></a><a name="Garbage+Collection+of+deleted+keys"></a>
+<a name="Garbage+Collection+of+deleted+keys"></a>
<h2 class="boxed">Garbage Collection of deleted keys</h2>
<div class="section">
<p>Since rows are only marked as "deleted", and not physically removed, it is necessary to perform space reclamation on deleted rows.</p>
-<a name="N1009D"></a><a name="Online+during+BTREE+split"></a>
+<a name="Online+during+BTREE+split"></a>
<h3 class="boxed">Online during BTREE split</h3>
<p>Whenever there is not enough room on a leaf to do an insert the code attempts to find space on the leaf, by checking if it can reclaim any committed deletes on that leaf. That work only requires the latch on the leaf and NOWAIT row write locks. It is expected that most of the space reclaim done in the BTree goes through this path. Most of this work is done in {@link org.apache.derby.impl.store.access.btree.BTreeController.reclaim_deleted_rows}.</p>
-<a name="N100A3"></a><a name="BTREE+post+commit+work"></a>
+<a name="BTREE+post+commit+work"></a>
<h3 class="boxed">BTREE post commit work</h3>
<p>Whenever a delete operation deletes the last row from a leaf page then a BtreePostCommit job is queued to be executed after the transaction which did the delete commits. This work currently requires a table level lock as page merges have not been implemented to be allowed concurrent with other operations. Many DBMSes don't even try to do page merges except when called from some sort of reorg utility. If all rows on page are purged, then the page will move to the free list and perform a merge to the tree.</p>
<p>It is expected that the normal space reclamation happens with row locks during btree split, which is why not much work has been done to optimize btree post commit path</p>
</div>
-<a name="N100AB"></a><a name="Logging+and+Recovery"></a>
+<a name="Logging+and+Recovery"></a>
<h2 class="boxed">Logging and Recovery</h2>
<div class="section">
<p>Derby uses physical redo and logical undo for BTree inserts and deletes. Logical undo is simplified as a result of using logical key deletes. If keys were physically removed during deletes, then the undo of a key delete would have required an insert operation which can potentially lead to page splits at various levels within the tree. Since the key is not physically removed, but only marked as "deleted", undoing a key delete is accomplished easily. However, since the page where the insert or delete should take place may have moved, it may be necessary to search for the page.</p>
Modified: websites/production/db/content/derby/papers/container-format.png
==============================================================================
Binary files - no diff available.
Modified: websites/production/db/content/derby/papers/derby_arch.html
==============================================================================
--- websites/production/db/content/derby/papers/derby_arch.html (original)
+++ websites/production/db/content/derby/papers/derby_arch.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Derby Engine Architecture Overview</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -316,6 +316,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Derby Engine Architecture Overview</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -347,6 +348,7 @@ document.write("Last Published: " + docu
</ul>
</li>
</ul>
+</div>
</div>
@@ -365,13 +367,13 @@ Please post any corrections or additiona
</p>
-<a name="N1001F"></a><a name="Module+View"></a>
+<a name="Module+View"></a>
<h2 class="boxed">Module View</h2>
<div class="section">
<p>
A running system is comprised of a monitor and a collection of modules.
</p>
-<a name="N10028"></a><a name="Monitor"></a>
+<a name="Monitor"></a>
<h3 class="boxed">Monitor</h3>
<p>
The monitor is code that maps module requests,
@@ -383,7 +385,7 @@ implementation, while in JDK 1.4 the dri
implementation. This allows Derby to present a single JDBC driver to the
application regardless of JDK and internally the correct driver is loaded.
</p>
-<a name="N10032"></a><a name="Modules"></a>
+<a name="Modules"></a>
<h3 class="boxed">Modules</h3>
<p>
A module is a set of discrete functionality, such as a lock manager,
@@ -408,13 +410,13 @@ configurations out of the same code base
</div>
-<a name="N10043"></a><a name="Layer%2FBox+View"></a>
+<a name="Layer%2FBox+View"></a>
<h2 class="boxed">Layer/Box View</h2>
<div class="section">
<p>
There are four main code areas: JDBC, SQL, Store and Services.
</p>
-<a name="N1004C"></a><a name="JDBC"></a>
+<a name="JDBC"></a>
<h3 class="boxed">JDBC</h3>
<p>
JDBC presents the only api to Derby to applications and consists of
@@ -429,7 +431,7 @@ additional methods.
<p>
The JDBC layer sits on top of the SQL layer.
</p>
-<a name="N10059"></a><a name="SQL"></a>
+<a name="SQL"></a>
<h3 class="boxed">SQL</h3>
<p>
The SQL layer is split into two main logical areas, compilation and
@@ -489,7 +491,7 @@ count.
These result set objects interface with the Store layer to fetch rows
from tables, indexes or perform sorts.
</p>
-<a name="N10084"></a><a name="Store"></a>
+<a name="Store"></a>
<h3 class="boxed">Store</h3>
<p>
The Store layer is split into two main areas, access and raw.
@@ -506,7 +508,7 @@ store works with a pluggable file system
to be stored in the Java filesystem, jar files, jar files in the
classpath, or any other mechanism.
</p>
-<a name="N10091"></a><a name="Services"></a>
+<a name="Services"></a>
<h3 class="boxed">Services</h3>
<p>
Services are utility modules such as lock management, cache management
Modified: websites/production/db/content/derby/papers/derby_htw.html
==============================================================================
--- websites/production/db/content/derby/papers/derby_htw.html (original)
+++ websites/production/db/content/derby/papers/derby_htw.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>How Things Work</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -315,7 +315,8 @@ document.write("Last Published: " + docu
<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>How Things Work</h1>
+<h1>How Things Work</h1>
+<div id="front-matter"></div>
<div class="warning">
Modified: websites/production/db/content/derby/papers/derby_web.html
==============================================================================
--- websites/production/db/content/derby/papers/derby_web.html (original)
+++ websites/production/db/content/derby/papers/derby_web.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Apache Derby Web Site</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -175,6 +175,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Apache Derby Web Site</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -253,6 +254,7 @@ document.write("Last Published: " + docu
</ul>
</li>
</ul>
+</div>
</div>
@@ -271,21 +273,21 @@ Derby web site itself.
</p>
-<a name="N10018"></a><a name="Web+Site+Change+Notes"></a>
+<a name="Web+Site+Change+Notes"></a>
<h2 class="boxed">Web Site Change Notes</h2>
<div class="section">
-<a name="N1001E"></a><a name="21-Dec-2007%3A+Web+site+upgraded+to+Forrest+0.8"></a>
+<a name="21-Dec-2007%3A+Web+site+upgraded+to+Forrest+0.8"></a>
<h3 class="boxed">21-Dec-2007: Web site upgraded to Forrest 0.8</h3>
<p>The web site was upgraded to build with the latest
release of Forrest, Forrest 0.8.</p>
-<a name="N10028"></a><a name="12-Aug-2005%3A+Web+site+upgraded+to+Forrest+0.7"></a>
+<a name="12-Aug-2005%3A+Web+site+upgraded+to+Forrest+0.7"></a>
<h3 class="boxed">12-Aug-2005: Web site upgraded to Forrest 0.7</h3>
<p>The web site was recently upgraded to build with the latest
release of Forrest, Forrest 0.7.</p>
<p>If you receive OutOfMemoryErrors while trying to build the
site, try increasing the amount of memory available to forrest
by setting the ANT_OPTS environment variable to -mx512M.</p>
-<a name="N10035"></a><a name="31-Jul-2005%3A+Web+site+moved+from+Incubator+to+Apache+DB"></a>
+<a name="31-Jul-2005%3A+Web+site+moved+from+Incubator+to+Apache+DB"></a>
<h3 class="boxed">31-Jul-2005: Web site moved from Incubator to Apache DB</h3>
<p>
Derby graduated from the Incubator to the Apache DB project,
@@ -308,7 +310,7 @@ Specific changes, beginning with SVN rev
</li>
</ul>
-<a name="N1004E"></a><a name="15-May-2005%3A+Version+10.0+manuals+moved"></a>
+<a name="15-May-2005%3A+Version+10.0+manuals+moved"></a>
<h3 class="boxed">15-May-2005: Version 10.0 manuals moved</h3>
<p>
The files that comprise the 10.0 manuals are numerous (about 750), static,
@@ -316,7 +318,7 @@ and take a while to build (20-40 minutes
In May they were moved to a separate "mini" forrest site, which is now at
<a href="http://db.apache.org/derby/docs/10.0/index.html">http://db.apache.org/derby/docs/10.0/index.html</a>.
</p>
-<a name="N1005C"></a><a name="27-Jan-2005%3A+Web+site+upgraded+to+Forrest+0.6"></a>
+<a name="27-Jan-2005%3A+Web+site+upgraded+to+Forrest+0.6"></a>
<h3 class="boxed">27-Jan-2005: Web site upgraded to Forrest 0.6</h3>
<p>
The Derby web site was initialized in August 2004 with Forrest 0.5.1.
@@ -355,7 +357,7 @@ blocks listed below:
</div>
-<a name="N1008B"></a><a name="Forrest+in+a+Nutshell"></a>
+<a name="Forrest+in+a+Nutshell"></a>
<h2 class="boxed">Forrest in a Nutshell</h2>
<div class="section">
<p>
@@ -391,7 +393,7 @@ The Derby web site uses Forrest 0.8 and
-<a name="N100B6"></a><a name="Testing+New+Pages+for+the+Derby+Site"></a>
+<a name="Testing+New+Pages+for+the+Derby+Site"></a>
<h2 class="boxed">Testing New Pages for the Derby Site</h2>
<div class="section">
<p>
@@ -401,7 +403,7 @@ who wants to develop content for the Der
It is much easier to integrate new pages by first
testing them outside the Derby web site source tree.
</p>
-<a name="N100BF"></a><a name="Create+a+Forrest+seed+site"></a>
+<a name="Create+a+Forrest+seed+site"></a>
<h3 class="boxed">Create a Forrest seed site</h3>
<p>
The
@@ -433,7 +435,7 @@ Below are some simple steps to get start
<li> Look at the sample pages that are included in the seed site.</li>
</ul>
-<a name="N100F7"></a><a name="Add+your+new+page+to+the+seed+site"></a>
+<a name="Add+your+new+page+to+the+seed+site"></a>
<h3 class="boxed">Add your new page to the seed site</h3>
<p>
If you don't need to add a new page, skip this step.
@@ -523,7 +525,7 @@ Otherwise, incorporate the new page(s) i
source file. </li>
</ul>
-<a name="N1015A"></a><a name="What+editor+can+you+use+for+Forrest+XML%3F"></a>
+<a name="What+editor+can+you+use+for+Forrest+XML%3F"></a>
<h3 class="boxed">What editor can you use for Forrest XML?</h3>
<p>
The Forrest web site mentions jEdit, oXygen, xmlspy,
@@ -554,7 +556,7 @@ If you find other tools that also work w
by posting to
<a href="../derby_mail.html">derby-dev@db.apache.org</a>.
</p>
-<a name="N10184"></a><a name="Resolve+Forrest+DTDs+locally"></a>
+<a name="Resolve+Forrest+DTDs+locally"></a>
<h3 class="boxed">Resolve Forrest DTDs locally</h3>
<p>
Many source files in the Derby web site repository are in Forrest XML format.
@@ -587,7 +589,7 @@ The mechanics of doing that is described
-<a name="N101A3"></a><a name="Updating+the+Apache+Derby+web+site"></a>
+<a name="Updating+the+Apache+Derby+web+site"></a>
<h2 class="boxed">Updating the Apache Derby web site </h2>
<div class="section">
<p>
@@ -597,14 +599,14 @@ Steps 1-6 are for both contributors and
Step 7 tells contributors how to create a patch.
Steps 8-10 tell committers how to commit and publish changes.
</p>
-<a name="N101AC"></a><a name="1.+Install+Forrest+on+your+machine"></a>
+<a name="1.+Install+Forrest+on+your+machine"></a>
<h3 class="boxed">1. Install Forrest on your machine</h3>
<p>
If you haven't installed Forrest yet,
<a class="external" href="http://forrest.apache.org/mirrors.cgi">install Forrest 0.8</a>
on your local system.
</p>
-<a name="N101BA"></a><a name="2.+Check+out+the+Derby+web+site+pages"></a>
+<a name="2.+Check+out+the+Derby+web+site+pages"></a>
<h3 class="boxed">2. Check out the Derby web site pages </h3>
<p>
Check the Derby web site files out of the subversion repository:
@@ -612,7 +614,7 @@ Check the Derby web site files out of th
<pre class="code">
svn co https://svn.apache.org/repos/asf/db/derby/site/trunk
</pre>
-<a name="N101C8"></a><a name="3.+Modify+files+in+the+src+tree"></a>
+<a name="3.+Modify+files+in+the+src+tree"></a>
<h3 class="boxed">3. Modify files in the src tree </h3>
<p>
After checking the site out of subversion,
@@ -769,7 +771,7 @@ they control the information and links i
</li>
</ul>
-<a name="N102DD"></a><a name="4.+Build+the+site"></a>
+<a name="4.+Build+the+site"></a>
<h3 class="boxed">4. Build the site </h3>
<p>
After modifying files, rebuild the site with the
@@ -791,7 +793,7 @@ If you run out of memory building the we
try setting the <span class="codefrag">ANT_OPTS</span> environment variable to
<span class="codefrag">-mx512M</span>.
</p>
-<a name="N10306"></a><a name="5.+Test+the+changes"></a>
+<a name="5.+Test+the+changes"></a>
<h3 class="boxed">5. Test the changes </h3>
<p>
There are a couple ways (at least) to review changes.
@@ -828,7 +830,7 @@ then Javascript adds extra breadcrumbs f
won't be added when the site is viewed locally.</a>
</p>
-<a name="N1033B"></a><a name="odd_diffs"></a>
+<a name="odd_diffs"></a>
<h3 class="boxed">6. Adjust the site build - odd diffs</h3>
<p>Derby developers build the site on a variety of platforms,
including Windows, Mac, and Linux. The
@@ -854,7 +856,7 @@ should revert the changes made to the <s
<pre class="code">svn revert build\site\skin\*</pre>
<p>If you are using TortoiseSVN, you can use Windows Explorer to revert the
changes.</p>
-<a name="N10381"></a><a name="7.+Create+a+patch"></a>
+<a name="7.+Create+a+patch"></a>
<h3 class="boxed">7. Create a patch</h3>
<p>
Create a patch at the <span class="codefrag">trunk</span> level and only include the
@@ -864,7 +866,7 @@ Create a patch at the <span class="codef
<p>
Upload the patch to a Jira issue to make it available to a Derby committer.
</p>
-<a name="N10398"></a><a name="8.+Commit+changes+to+the+src+and+build%2Fsite+directories"></a>
+<a name="8.+Commit+changes+to+the+src+and+build%2Fsite+directories"></a>
<h3 class="boxed">8. Commit changes to the src and build/site directories</h3>
<p>
Apply any patch, if one was provided, then build and test the web site
@@ -910,7 +912,7 @@ svn commit --message "here is my commit
cd ../build/site
svn commit --message "here is my commit message"
</pre>
-<a name="N103E0"></a><a name="9.+Make+web+site+changes+visible"></a>
+<a name="9.+Make+web+site+changes+visible"></a>
<h3 class="boxed">9. Make web site changes visible</h3>
<p>
A Derby committer can force the source tree to be updated to the latest change as follows:
@@ -926,7 +928,7 @@ However, www.apache.org automatically sy
and the <span class="codefrag">build/site</span> tree will get synced right away,
so there is no need for this.
</p>
-<a name="N103F7"></a><a name="10.+Considering+a+quick+fix+to+the+build+tree%3F"></a>
+<a name="10.+Considering+a+quick+fix+to+the+build+tree%3F"></a>
<h3 class="boxed">10. Considering a quick fix to the build tree?</h3>
<p>
If you modify a file in the <span class="codefrag">build/site</span> tree,
Modified: websites/production/db/content/derby/papers/field-header-non-overflow.png
==============================================================================
Binary files - no diff available.
Modified: websites/production/db/content/derby/papers/field-header-overflow.png
==============================================================================
Binary files - no diff available.
Modified: websites/production/db/content/derby/papers/fortune_tut.html
==============================================================================
--- websites/production/db/content/derby/papers/fortune_tut.html (original)
+++ websites/production/db/content/derby/papers/fortune_tut.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Apache Derby Fortune Server Tutorial</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -316,6 +316,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Apache Derby Fortune Server Tutorial</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -337,10 +338,11 @@ document.write("Last Published: " + docu
<a href="#Revision+History">Revision History</a>
</li>
</ul>
+</div>
</div>
-<a name="N1000D"></a><a name="Overview"></a>
+<a name="Overview"></a>
<h2 class="boxed">Overview</h2>
<div class="section">
<p>
@@ -365,7 +367,7 @@ all within Derby's easy-to-use embedded
</div>
-<a name="N10025"></a><a name="Intended+Audience"></a>
+<a name="Intended+Audience"></a>
<h2 class="boxed">Intended Audience</h2>
<div class="section">
<p>
@@ -377,7 +379,7 @@ so lack of experience in any of these ar
</div>
-<a name="N1002F"></a><a name="Tutorial+Topics"></a>
+<a name="Tutorial+Topics"></a>
<h2 class="boxed">Tutorial Topics</h2>
<div class="section">
<p>
@@ -439,7 +441,7 @@ The tutorial is organized into the secti
-<a name="N10072"></a><a name="Download+Software"></a>
+<a name="Download+Software"></a>
<h2 class="boxed">Download Software</h2>
<div class="section">
<ul>
@@ -469,7 +471,7 @@ The tutorial is organized into the secti
</div>
-<a name="N1009B"></a><a name="Credits+and+Acknowledgments"></a>
+<a name="Credits+and+Acknowledgments"></a>
<h2 class="boxed">Credits and Acknowledgments</h2>
<div class="section">
<p>
@@ -499,7 +501,7 @@ was used for generating the web-based ma
</div>
-<a name="N100BD"></a><a name="Revision+History"></a>
+<a name="Revision+History"></a>
<h2 class="boxed">Revision History</h2>
<div class="section">
<p>
Modified: websites/production/db/content/derby/papers/index.html
==============================================================================
--- websites/production/db/content/derby/papers/index.html (original)
+++ websites/production/db/content/derby/papers/index.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Apache Derby Papers</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -319,6 +319,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Apache Derby Papers</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -334,6 +335,7 @@ document.write("Last Published: " + docu
<a href="#How+to+Contribute+Papers">How to Contribute Papers</a>
</li>
</ul>
+</div>
</div>
@@ -343,7 +345,7 @@ This <em>ad hoc</em> spot in the Derby s
</p>
-<a name="N10017"></a><a name="Derby+Engine"></a>
+<a name="Derby+Engine"></a>
<h2 class="boxed">Derby Engine</h2>
<div class="section">
<p>
@@ -457,7 +459,7 @@ then open the file you saved.)
</div>
-<a name="N100FF"></a><a name="Derby+Network+Client"></a>
+<a name="Derby+Network+Client"></a>
<h2 class="boxed">Derby Network Client</h2>
<div class="section">
<p>
@@ -479,7 +481,7 @@ The table below summarizes white papers
</div>
-<a name="N10125"></a><a name="Instruction"></a>
+<a name="Instruction"></a>
<h2 class="boxed">Instruction</h2>
<div class="section">
<p>
@@ -492,7 +494,7 @@ even more tutorials and other instructio
</div>
-<a name="N10137"></a><a name="How+to+Contribute+Papers"></a>
+<a name="How+to+Contribute+Papers"></a>
<h2 class="boxed">How to Contribute Papers</h2>
<div class="section">
<p>
Modified: websites/production/db/content/derby/papers/logformats.html
==============================================================================
--- websites/production/db/content/derby/papers/logformats.html (original)
+++ websites/production/db/content/derby/papers/logformats.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Derby Write Ahead Log Format</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -316,6 +316,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Derby Write Ahead Log Format</h1>
+<div id="front-matter">
<div class="abstract">This document describes the storage format of Derby Write Ahead
Log. This is a work-in-progress derived from Javadoc comments and from
explanations Mike Matrigali and others posted to the Derby lists. Please
@@ -358,9 +359,10 @@ document.write("Last Published: " + docu
<a href="#Pointers+to+relevant+classes">Pointers to relevant classes</a>
</li>
</ul>
+</div>
</div>
-<a name="N10010"></a><a name="introduction"></a>
+<a name="introduction"></a>
<h2 class="boxed"> Introduction </h2>
<div class="section">
<p> Derby uses a Write Ahead Log to record all changes to the database.
@@ -389,7 +391,7 @@ document.write("Last Published: " + docu
paper.</p>
</div>
-<a name="N1002C"></a><a name="References"></a>
+<a name="References"></a>
<h2 class="boxed"> References </h2>
<div class="section">
<p> A good description of Write Ahead Logging, and how a log is typically
@@ -401,7 +403,7 @@ document.write("Last Published: " + docu
.</p>
</div>
-<a name="N1003D"></a><a name="Derby+implementation+of+the+Write+Ahead+Log"></a>
+<a name="Derby+implementation+of+the+Write+Ahead+Log"></a>
<h2 class="boxed">Derby implementation of the Write Ahead Log</h2>
<div class="section">
<p> Derby implements the Write Ahead Log using a non-circular file system
@@ -468,7 +470,7 @@ document.write("Last Published: " + docu
while"</li>
</ol>
-<a name="N1007C"></a><a name="LogCounter"></a>
+<a name="LogCounter"></a>
<h3 class="boxed">LogCounter</h3>
<p>Log records are identified using LogCounter, which is an implementation
of LogInstant, a Derby term for LSN. The LogCounter is made up of
@@ -480,7 +482,7 @@ document.write("Last Published: " + docu
tells if one log instant is lessThan, equals or greater than another.</p>
</div>
-<a name="N1008A"></a><a name="Format+of+Write+Ahead+Log"></a>
+<a name="Format+of+Write+Ahead+Log"></a>
<h2 class="boxed"> Format of Write Ahead Log </h2>
<div class="section">
<p> An implementation of file based log is in
@@ -488,7 +490,7 @@ document.write("Last Published: " + docu
This LogFactory is responsible for the formats of 2 kinds of file:
the log file and the log control file. And it is responsible for the
format of the log record wrapper. </p>
-<a name="N10096"></a><a name="Format+of+Log+Control+File"></a>
+<a name="Format+of+Log+Control+File"></a>
<h3 class="boxed">Format of Log Control File</h3>
<p>The log control file contains information about which log files are
present and where the last checkpoint log record is located.</p>
@@ -586,7 +588,7 @@ document.write("Last Published: " + docu
</tr>
</table>
-<a name="N1014C"></a><a name="Format+of+the+log+file"></a>
+<a name="Format+of+the+log+file"></a>
<h3 class="boxed">Format of the log file</h3>
<p>The log file contains log records which record all the changes to
the database. The complete transaction log is composed of a series
@@ -654,7 +656,7 @@ document.write("Last Published: " + docu
</tr>
</table>
-<a name="N101C1"></a><a name="Format+of+the+log+record+wrapper"></a>
+<a name="Format+of+the+log+record+wrapper"></a>
<h3 class="boxed">Format of the log record wrapper</h3>
<p>The log record wrapper provides information for the log scan.</p>
<table class="ForrestTable" cellspacing="1" cellpadding="4">
@@ -695,7 +697,7 @@ document.write("Last Published: " + docu
</tr>
</table>
-<a name="N1020F"></a><a name="The+format+of+a+log+record"></a>
+<a name="The+format+of+a+log+record"></a>
<h3 class="boxed">The format of a log record</h3>
<p>The log record described every change to the persistent store</p>
<table class="ForrestTable" cellspacing="1" cellpadding="4">
@@ -851,7 +853,7 @@ document.write("Last Published: " + docu
</table>
</div>
-<a name="N1033C"></a><a name="Pointers+to+relevant+classes"></a>
+<a name="Pointers+to+relevant+classes"></a>
<h2 class="boxed">Pointers to relevant classes</h2>
<div class="section">
<div class="fixme">
Modified: websites/production/db/content/derby/papers/optimizer.html
==============================================================================
--- websites/production/db/content/derby/papers/optimizer.html (original)
+++ websites/production/db/content/derby/papers/optimizer.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Derby Optimizer Design</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -316,6 +316,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Derby Optimizer Design</h1>
+<div id="front-matter">
<div class="abstract">This document describes the Derby Optimizer. This is a work-in-progress
derived from Javadoc comments and from explanations Jeffrey Lichtman and
others posted to the Derby lists. Please post questions, comments, and
@@ -332,9 +333,10 @@ document.write("Last Published: " + docu
<a href="#Potential+Improvements+to+the+Optimizer">Potential Improvements to the Optimizer</a>
</li>
</ul>
+</div>
</div>
-<a name="N10010"></a><a name="overview"></a>
+<a name="overview"></a>
<h2 class="boxed">Overview</h2>
<div class="section">
<div class="note">
@@ -404,7 +406,7 @@ document.write("Last Published: " + docu
the join order musn't be inverted under the current implementation). </p>
</div>
-<a name="N10032"></a><a name="Example+of+a+5-way+Join"></a>
+<a name="Example+of+a+5-way+Join"></a>
<h2 class="boxed">Example of a 5-way Join</h2>
<div class="section">
<p> The optimizer looks at so many
@@ -522,7 +524,7 @@ t1 t2 t3 JOIN
- t5 - t2. </p>
</div>
-<a name="N10078"></a><a name="Potential+Improvements+to+the+Optimizer"></a>
+<a name="Potential+Improvements+to+the+Optimizer"></a>
<h2 class="boxed">Potential Improvements to the Optimizer</h2>
<div class="section">
<p> It's hard to consider the optimizer by itself. Many optimizer enhancements
Modified: websites/production/db/content/derby/papers/page-format.png
==============================================================================
Binary files - no diff available.
Modified: websites/production/db/content/derby/papers/pageformats.html
==============================================================================
--- websites/production/db/content/derby/papers/pageformats.html (original)
+++ websites/production/db/content/derby/papers/pageformats.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Derby On Disk Page Format</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -316,6 +316,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Derby On Disk Page Format</h1>
+<div id="front-matter">
<div class="abstract">This document describes the storage format of Derby disk pages.
This is a work-in-progress derived from Javadoc comments and
@@ -367,8 +368,9 @@ document.write("Last Published: " + docu
</li>
</ul>
</div>
+</div>
-<a name="N10010"></a><a name="introduction"></a>
+<a name="introduction"></a>
<h2 class="boxed"> Introduction </h2>
<div class="section">
<p>Derby stores table and index data in Containers, which currently map
@@ -437,18 +439,18 @@ have allocation bit maps.
</p>
</div>
-<a name="N10049"></a><a name="storedpage"></a>
+<a name="storedpage"></a>
<h2 class="boxed">Data Page Format</h2>
<div class="section">
<p>A data page is broken into five sections.
<img alt="" src="page-format.png"></p>
-<a name="N10055"></a><a name="formatid"></a>
+<a name="formatid"></a>
<h3 class="boxed">Format Id </h3>
<p> The formatId is a 4 bytes array, it contains the format Id of this
page. The possible values are RAW_STORE_STORED_PAGE or RAW_STORE_ALLOC_PAGE.</p>
-<a name="N1005F"></a><a name="pageheader"></a>
+<a name="pageheader"></a>
<h3 class="boxed"> Page Header </h3>
<p> The page header is a fixed size, 56 bytes. </p>
<table class="ForrestTable" cellspacing="1" cellpadding="4">
@@ -608,7 +610,7 @@ have allocation bit maps.
that 0 means field was never assigned. </div>
</div>
-<a name="N1017A"></a><a name="records"></a>
+<a name="records"></a>
<h3 class="boxed"> Records </h3>
<p>The records section contains zero or more records. Each record starts
@@ -896,7 +898,7 @@ have allocation bit maps.
</div>
</div>
-<a name="N102C3"></a><a name="slottable"></a>
+<a name="slottable"></a>
<h3 class="boxed">Slot Offset Table</h3>
<p>The slot offset table is a table of 6 or 12 bytes per record, depending
@@ -941,14 +943,14 @@ have allocation bit maps.
First slot is slot 0. The slot table grows backwards. Slots are never
left empty. </p>
-<a name="N1030A"></a><a name="checksum"></a>
+<a name="checksum"></a>
<h3 class="boxed">Checksum</h3>
<p>8 bytes of a java.util.zip.CRC32 checksum of the entire's page contents
without the 8 bytes representing the checksum.</p>
</div>
-<a name="N10315"></a><a name="allocpage"></a>
+<a name="allocpage"></a>
<h2 class="boxed">Allocation Page</h2>
<div class="section">
<p> An allocation page of the file container extends a normal Stored page,
@@ -1162,7 +1164,7 @@ have allocation bit maps.
extent row to the alloc page.
</p>
-<a name="N103EA"></a><a name="Alloc+Page+detailed+implementation+notes"></a>
+<a name="Alloc+Page+detailed+implementation+notes"></a>
<h3 class="boxed">
Alloc Page detailed implementation notes</h3>
@@ -1232,7 +1234,7 @@ have allocation bit maps.
<p>For the fields in an allocation extent row.</p>
</div>
-<a name="N10404"></a><a name="Allocation+Extent"></a>
+<a name="Allocation+Extent"></a>
<h2 class="boxed">Allocation Extent</h2>
<div class="section">
<p>
Modified: websites/production/db/content/derby/papers/recovery.html
==============================================================================
--- websites/production/db/content/derby/papers/recovery.html (original)
+++ websites/production/db/content/derby/papers/recovery.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Derby Logging and Recovery</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -316,6 +316,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Derby Logging and Recovery</h1>
+<div id="front-matter">
<div class="abstract">This document describes how Derby implements logging and recovery.
This is a work-in-progress derived from Javadoc comments and from explanations
Mike Matrigali and others posted to the Derby lists. Please post questions,
@@ -366,14 +367,15 @@ document.write("Last Published: " + docu
</li>
</ul>
</div>
+</div>
-<a name="N10010"></a><a name="introduction"></a>
+<a name="introduction"></a>
<h2 class="boxed"> Introduction </h2>
<div class="section">
<p>Derby transaction logging and recovery is based upon the ARIES algorithm.</p>
</div>
-<a name="N1001A"></a><a name="ARIES+-+An+Overview"></a>
+<a name="ARIES+-+An+Overview"></a>
<h2 class="boxed">ARIES - An Overview</h2>
<div class="section">
<p>Following is a brief description of the main principles behind ARIES.</p>
@@ -418,7 +420,7 @@ transaction decides to rollback.
system need to know about high level data structures. </p>
</div>
-<a name="N10033"></a><a name="Features+of+ARIES"></a>
+<a name="Features+of+ARIES"></a>
<h2 class="boxed">Features of ARIES</h2>
<div class="section">
<p>ARIES includes a number of optimisations to reduce the amount of work
@@ -458,7 +460,7 @@ transaction decides to rollback.
UndoLsn pointer as described previously.</p>
</div>
-<a name="N10049"></a><a name="References"></a>
+<a name="References"></a>
<h2 class="boxed">References</h2>
<div class="section">
<ol>
@@ -489,7 +491,7 @@ transaction decides to rollback.
</ol>
</div>
-<a name="N1006B"></a><a name="Derby+implementation+of+ARIES"></a>
+<a name="Derby+implementation+of+ARIES"></a>
<h2 class="boxed">Derby implementation of ARIES</h2>
<div class="section">
<p>I shall only describe how Derby differs from standard ARIES implementation.
@@ -551,7 +553,7 @@ transaction decides to rollback.
done.</p>
</div>
-<a name="N1008F"></a><a name="Derby+recovery+process"></a>
+<a name="Derby+recovery+process"></a>
<h2 class="boxed">Derby recovery process</h2>
<div class="section">
<p>Implemented in <span class="codefrag">org.apache.derby.impl.store.raw.log.LogToFile.recover()</span>
@@ -574,7 +576,7 @@ transaction decides to rollback.
</dl>
</div>
-<a name="N100B0"></a><a name="Recovery+Redo+pass"></a>
+<a name="Recovery+Redo+pass"></a>
<h2 class="boxed">Recovery Redo pass</h2>
<div class="section">
<p>Implemented in <span class="codefrag">org.apache.derby.impl.store.raw.log.FileLogger.redo()</span>
@@ -598,7 +600,7 @@ transaction decides to rollback.
</ol>
</div>
-<a name="N100CB"></a><a name="Recovery+Undo+pass"></a>
+<a name="Recovery+Undo+pass"></a>
<h2 class="boxed">Recovery Undo pass</h2>
<div class="section">
<p>Implemented in <span class="codefrag">org.apache.derby.impl.store.raw.xact.XactFactory.rollbackAllTransactions()</span>
@@ -614,7 +616,7 @@ transaction decides to rollback.
</ol>
</div>
-<a name="N100E3"></a><a name="Checkpoints"></a>
+<a name="Checkpoints"></a>
<h2 class="boxed">Checkpoints</h2>
<div class="section">
<p>Implemented in <span class="codefrag">org.apache.derby.impl.store.raw.log.LogToFile.checkpoint()</span>
@@ -739,7 +741,7 @@ transaction decides to rollback.
</p>
</div>
-<a name="N1015E"></a><a name="Derby+Logging+Overview"></a>
+<a name="Derby+Logging+Overview"></a>
<h2 class="boxed">Derby Logging Overview</h2>
<div class="section">
<p>A loggable action in Derby is redoable. If the action implements Undoable interface, then it is also
@@ -775,7 +777,7 @@ transaction decides to rollback.
</ol>
</div>
-<a name="N10180"></a><a name="Loggable+Interface+Hierarchy"></a>
+<a name="Loggable+Interface+Hierarchy"></a>
<h2 class="boxed">Loggable Interface Hierarchy</h2>
<div class="section">
<ul>
@@ -805,7 +807,7 @@ transaction decides to rollback.
</ul>
</div>
-<a name="N101B2"></a><a name="Container+Log+Operations+Hierarchy"></a>
+<a name="Container+Log+Operations+Hierarchy"></a>
<h2 class="boxed">Container Log Operations Hierarchy</h2>
<div class="section">
<ul>
@@ -826,7 +828,7 @@ transaction decides to rollback.
</ul>
</div>
-<a name="N101F7"></a><a name="Transaction+Management+Log+Operations+Hierarchy"></a>
+<a name="Transaction+Management+Log+Operations+Hierarchy"></a>
<h2 class="boxed">Transaction Management Log Operations Hierarchy</h2>
<div class="section">
<ul>
@@ -840,7 +842,7 @@ transaction decides to rollback.
</ul>
</div>
-<a name="N1022B"></a><a name="Page+Level+Log+Operations+Hierarchy"></a>
+<a name="Page+Level+Log+Operations+Hierarchy"></a>
<h2 class="boxed">Page Level Log Operations Hierarchy</h2>
<div class="section">
<ul>
Modified: websites/production/db/content/derby/papers/versionupgrade.html
==============================================================================
--- websites/production/db/content/derby/papers/versionupgrade.html (original)
+++ websites/production/db/content/derby/papers/versionupgrade.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Derby Versioning Scheme</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -316,6 +316,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Derby Versioning Scheme</h1>
+<div id="front-matter">
<div class="abstract">This document describes the Derby Versioning Scheme. This is a
work-in-progress derived from Javadoc comments and from explanations Dan
Debrunner and others posted to the Derby lists. Please post questions,
@@ -335,9 +336,10 @@ document.write("Last Published: " + docu
<a href="#Upgrading+System+Catalogs">Upgrading System Catalogs</a>
</li>
</ul>
+</div>
</div>
-<a name="N10010"></a><a name="Basic+Numbering+Scheme"></a>
+<a name="Basic+Numbering+Scheme"></a>
<h2 class="boxed">Basic Numbering Scheme</h2>
<div class="section">
<div class="note">
@@ -393,7 +395,7 @@ document.write("Last Published: " + docu
had undergone 3 additional QA testing cycles. </p>
</div>
-<a name="N10038"></a><a name="Sysinfo+and+how+it+reports+versions"></a>
+<a name="Sysinfo+and+how+it+reports+versions"></a>
<h2 class="boxed">Sysinfo and how it reports versions</h2>
<div class="section">
<p> This version value is reported by the sysinfo utility, in some messages
@@ -442,7 +444,7 @@ document.write("Last Published: " + docu
</table>
</div>
-<a name="N1008E"></a><a name="Version+Upgrade+Mechanism"></a>
+<a name="Version+Upgrade+Mechanism"></a>
<h2 class="boxed">Version Upgrade Mechanism</h2>
<div class="section">
<div class="note">
@@ -511,7 +513,7 @@ document.write("Last Published: " + docu
SALESDB with 10.0.x.y or 10.1.x.y would fail. </p>
</div>
-<a name="N100D7"></a><a name="Upgrading+System+Catalogs"></a>
+<a name="Upgrading+System+Catalogs"></a>
<h2 class="boxed">Upgrading System Catalogs</h2>
<div class="section">
<div class="note">
Modified: websites/production/db/content/derby/quick_start.html
==============================================================================
--- websites/production/db/content/derby/quick_start.html (original)
+++ websites/production/db/content/derby/quick_start.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Apache Derby: Quick Start</title>
<link type="text/css" href="skin/basic.css" rel="stylesheet">
@@ -157,6 +157,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Apache Derby: Quick Start</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -169,10 +170,11 @@ document.write("Last Published: " + docu
<a href="#Next+Steps+for+Developers">Next Steps for Developers</a>
</li>
</ul>
+</div>
</div>
-<a name="N1000D"></a><a name="The+Basics"></a>
+<a name="The+Basics"></a>
<h2 class="boxed">The Basics</h2>
<div class="section">
<p>
@@ -208,7 +210,7 @@ The resources listed below are intended
</div>
-<a name="N10040"></a><a name="Next+Steps+for+Users"></a>
+<a name="Next+Steps+for+Users"></a>
<h2 class="boxed">Next Steps for Users</h2>
<div class="section">
<p>
@@ -329,7 +331,7 @@ As you learn more about Derby, feel free
</div>
-<a name="N100CB"></a><a name="Next+Steps+for+Developers"></a>
+<a name="Next+Steps+for+Developers"></a>
<h2 class="boxed">Next Steps for Developers</h2>
<div class="section">
<p>
Modified: websites/production/db/content/derby/releases/release-10.0.2.1.html
==============================================================================
--- websites/production/db/content/derby/releases/release-10.0.2.1.html (original)
+++ websites/production/db/content/derby/releases/release-10.0.2.1.html Wed Sep 28 01:33:43 2016
@@ -3,7 +3,7 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
<title>Apache Derby 10.0.2.1 Incubator Release</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
@@ -157,6 +157,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Apache Derby 10.0.2.1 Incubator Release</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -173,8 +174,9 @@ document.write("Last Published: " + docu
</li>
</ul>
</div>
+</div>
-<a name="N1000D"></a><a name="Distributions"></a>
+<a name="Distributions"></a>
<h2 class="boxed">Distributions</h2>
<div class="section">
<p>There are three different distributions:</p>
@@ -204,7 +206,7 @@ document.write("Last Published: " + docu
</div>
-<a name="N1007C"></a><a name="Release+Overview"></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
@@ -266,7 +268,7 @@ document.write("Last Published: " + docu
</div>
-<a name="N100D7"></a><a name="Release+Notes"></a>
+<a name="Release+Notes"></a>
<h2 class="boxed">Release Notes</h2>
<div class="section">
<p>Derby version 10.0.2.1</p>
@@ -588,7 +590,7 @@ document.write("Last Published: " + docu
</div>
-<a name="N10464"></a><a name="Testing"></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>
Modified: websites/production/db/content/derby/releases/release-10.1.1.0.html
==============================================================================
--- websites/production/db/content/derby/releases/release-10.1.1.0.html (original)
+++ websites/production/db/content/derby/releases/release-10.1.1.0.html Wed Sep 28 01:33:43 2016
@@ -3,9 +3,8 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
-<meta name="generator" content="">
<title>Apache Derby 10.1.1.0 Release</title>
<link type="text/css" href="../skin/basic.css" rel="stylesheet">
<link media="screen" type="text/css" href="../skin/screen.css" rel="stylesheet">
@@ -158,6 +157,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Apache Derby 10.1.1.0 Release</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -177,7 +177,8 @@ document.write("Last Published: " + docu
</li>
</ul>
</div>
-<a name="N10010"></a><a name="Distributions"></a>
+</div>
+<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. It is good practice to <a href="#Verifying+releases">verify the integrity</a> of the distribution files.</p>
@@ -206,7 +207,7 @@ document.write("Last Published: " + docu
<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.1.0/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.1.0/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.1.0/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="N1009C"></a><a name="Release+Overview"></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.</p>
@@ -258,7 +259,7 @@ document.write("Last Published: " + docu
<li>JSR-169, JDBC 2.1, and JDBC 3.0 support</li>
</ul>
</div>
-<a name="N100F1"></a><a name="Release+Notes"></a>
+<a name="Release+Notes"></a>
<h2 class="boxed">Release Notes</h2>
<div class="section">
<p>Derby version 10.1.1.0</p>
@@ -776,7 +777,7 @@ document.write("Last Published: " + docu
</tr>
</table>
</div>
-<a name="N1059F"></a><a name="Testing"></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>
@@ -852,7 +853,7 @@ document.write("Last Published: " + docu
<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="N1064A"></a><a name="Verifying+releases"></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>
Modified: websites/production/db/content/derby/releases/release-10.1.2.1.html
==============================================================================
--- websites/production/db/content/derby/releases/release-10.1.2.1.html (original)
+++ websites/production/db/content/derby/releases/release-10.1.2.1.html Wed Sep 28 01:33:43 2016
@@ -3,9 +3,8 @@
<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-version" content="0.9">
<meta name="Forrest-skin-name" content="pelt">
-<meta name="generator" content="">
<title>Apache Derby 10.1.2.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">
@@ -158,6 +157,7 @@ document.write("Last Published: " + docu
<input value="+a" class="biggerfont" title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;" type="button">
</div>
<h1>Apache Derby 10.1.2.1 Release</h1>
+<div id="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -185,7 +185,8 @@ document.write("Last Published: " + docu
</li>
</ul>
</div>
-<a name="N10010"></a><a name="Distributions"></a>
+</div>
+<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. It is good practice to <a href="#Verifying+releases">verify the integrity</a> of the distribution files.</p>
@@ -214,7 +215,7 @@ document.write("Last Published: " + docu
<a class="external" href="http://archive.apache.org/dist/db/derby/db-derby-10.1.2.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.2.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.2.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="N1009C"></a><a name="Release+Overview"></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.2.1 is a bug fix release providing quality improvements for Derby 10.1</p>
@@ -263,12 +264,12 @@ document.write("Last Published: " + docu
<li>JSR-169, JDBC 2.1, and JDBC 3.0 support</li>
</ul>
</div>
-<a name="N100EB"></a><a name="Release+Notes"></a>
+<a name="Release+Notes"></a>
<h2 class="boxed">Release Notes</h2>
<div class="section">
<p>Derby version 10.1.2.1 is a bug fix release based on Apache Derby <a href="http://db.apache.org/derby/releases/release-10.1.1.0.html">10.1.1.0.</a> In addition to many other bug fixes, this release contains the fix for DERBY-662 which is a rare but potentially serious data loss issue on case insensitive file systems such as Windows.</p>
<p>The following reported JIRA issues were fixed in the 10.1.2.1 release:</p>
-<a name="N100F7"></a><a name="Bugs"></a>
+<a name="Bugs"></a>
<h3 class="boxed">Bugs</h3>
<ul>
<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-626">DERBY-626</a>] - Booting embedded engine requires read permission to derby.jar be granted for all code in the stack</li>
@@ -318,7 +319,7 @@ document.write("Last Published: " + docu
<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-620">DERBY-620</a>] - BUILDING.txt section 3.2(1): Instructions for finding user home directory are not reliable</li>
<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-624">DERBY-624</a>] - Running derbynetclientmats and derbynetmats requires accessDeclaredMembers permission to be granted with sane=true</li>
</ul>
-<a name="N10210"></a><a name="Improvements"></a>
+<a name="Improvements"></a>
<h3 class="boxed">Improvements</h3>
<ul>
<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-419">DERBY-419</a>] - Support direct execution of derbynet.jar using the -jar option of the VM.</li>
@@ -326,7 +327,7 @@ document.write("Last Published: " + docu
<li>[<a class="external" href="http://issues.apache.org/jira/browse/DERBY-636">DERBY-636</a>] - Updated localized messages for Derby 10.1</li>
</ul>
</div>
-<a name="N10227"></a><a name="Testing"></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>
@@ -387,7 +388,7 @@ document.write("Last Published: " + docu
<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="N102AF"></a><a name="Verifying+releases"></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>
Modified: websites/production/db/content/derby/releases/release-10.1.3.1.html
==============================================================================
--- websites/production/db/content/derby/releases/release-10.1.3.1.html (original)
+++ websites/production/db/content/derby/releases/release-10.1.3.1.html Wed Sep 28 01:33:43 2016
@@ -3,9 +3,8 @@
<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-version" content="0.9">
<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">
@@ -158,6 +157,7 @@ document.write("Last Published: " + docu
<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="front-matter">
<div id="minitoc-area">
<ul class="minitoc">
<li>
@@ -179,13 +179,13 @@ document.write("Last Published: " + docu
<a href="#">DERBY-283</a>
</li>
<li>
-<a href="#-N103D0">DERBY-526</a>
+<a href="#-N103C7">DERBY-526</a>
</li>
<li>
-<a href="#-N103FA">DERBY-1327</a>
+<a href="#-N103F1">DERBY-1327</a>
</li>
<li>
-<a href="#-N10434">DERBY-541</a>
+<a href="#-N1042B">DERBY-541</a>
</li>
</ul>
</li>
@@ -197,7 +197,8 @@ document.write("Last Published: " + docu
</li>
</ul>
</div>
-<a name="N10010"></a><a name="Distributions"></a>
+</div>
+<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>
@@ -230,7 +231,7 @@ document.write("Last Published: " + docu
<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>
+<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>
@@ -281,13 +282,13 @@ document.write("Last Published: " + docu
<li>JSR-169, JDBC 2.1, and JDBC 3.0 support</li>
</ul>
</div>
-<a name="N10113"></a><a name="Release+Notes"></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>
+<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>
@@ -388,7 +389,7 @@ document.write("Last Published: " + docu
<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>
+<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>
@@ -401,7 +402,7 @@ document.write("Last Published: " + docu
<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>
+<a class="external" href="http://issues.apache.org/jira/browse/DERBY"></a><a name="N1039E"></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>
@@ -415,7 +416,7 @@ document.write("Last Published: " + docu
<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>
+<a name="-N103C7"></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>
@@ -429,7 +430,7 @@ document.write("Last Published: " + docu
<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>
+<a name="-N103F1"></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>
@@ -445,7 +446,7 @@ document.write("Last Published: " + docu
<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>
+<a name="-N1042B"></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>
@@ -460,7 +461,7 @@ document.write("Last Published: " + docu
<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>
+<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>
@@ -632,7 +633,7 @@ document.write("Last Published: " + docu
<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>
+<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>
Re: svn commit: r998438 [3/6] - in /websites/production/db/content/derby:
./ blogs/ dev/ integrate/ manuals/ papers/ papers/DerbyTut/ releases/ skin/
Posted by Jim Kroger <jk...@gmail.com>.
Please stop sending all this apache junk, it's filling my mailbox.
On Tue, Sep 27, 2016 at 7:33 PM, <bp...@apache.org> wrote:
> Modified: websites/production/db/content/derby/papers/
> JDBCImplementation.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/JDBCImplementation.html
> (original)
> +++ websites/production/db/content/derby/papers/JDBCImplementation.html
> Wed Sep 28 01:33:43 2016
> @@ -3,9 +3,8 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> -<meta name="generator" content="">
> <meta name="" content="">
> <meta name="GENERATOR" content="">
> <meta name="CREATED" content="">
> @@ -323,6 +322,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Derby JDBC Implementation Notes</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -453,7 +453,8 @@ document.write("Last Published: " + docu
> </li>
> </ul>
> </div>
> -<a name="N10049"></a><a name="Overview"></a>
> +</div>
> +<a name="Overview"></a>
> <h2 class="boxed">Overview</h2>
> <div class="section">
> <p>The JDBC specification is sometimes unclear or contradictory. This
> document covers how Derby implements some JDBC features where the
> specification might be unclear.</p>
> @@ -465,38 +466,38 @@ document.write("Last Published: " + docu
> <p>[TUTORIAL3] – JDBC API Tutorial and Reference, Third Edition.
> ISBN 0321173848 <a class="external" href="http://java.sun.com/
> developer/Books/jdbc/Fisher/index.html">http://java.sun.
> com/developer/Books/jdbc/Fisher/index.html</a>
> </p>
> </div>
> -<a name="N10060"></a><a name="Java.sql.Connection"></a>
> +<a name="Java.sql.Connection"></a>
> <h2 class="boxed">Java.sql.Connection</h2>
> <div class="section">
> -<a name="N10064"></a><a name="CreateStatement%2C+prepareStatement+and+
> prepareCall"></a>
> +<a name="CreateStatement%2C+prepareStatement+and+prepareCall"></a>
> <h3 class="boxed">CreateStatement, prepareStatement and prepareCall</h3>
> <p>Behavior Clarification</p>
> <p>CONCUR_UPDATABLE concurrency is supported for FORWARD ONLY ResultSet
> types only.</p>
> </div>
> -<a name="N1006C"></a><a name="Java.sql.PreparedStatement"></a>
> +<a name="Java.sql.PreparedStatement"></a>
> <h2 class="boxed">Java.sql.PreparedStatement</h2>
> <div class="section">
> -<a name="N10070"></a><a name="setAsciiStream%2CsetBinaryStream%
> 2CsetCharacterStream"></a>
> +<a name="setAsciiStream%2CsetBinaryStream%2CsetCharacterStream"></a>
> <h3 class="boxed">setAsciiStream,setBinaryStream,setCharacterStream</h3>
> <p>Behavior Clarification</p>
> <p>In Derby, the stream must have the exact amount of data as the length
> argument, otherwise an exception with the following message 'Input Stream
> did not have exact amount of data as the requested length' is thrown.</p>
> <p>Stream parameter values are not re-used. The JDBC 3.0 specification
> says in the last paragraph of 13.2.2 that parameters are re-used but
> nothing special about streams. However javadoc for
> java.sql.PreparedStatement.clearParamters() says 'In general, parameter
> values remain in force for repeated use of a statement'. Maybe 'in general'
> can be interpreted to mean 'except for streams'. Stream parameter values
> are not re-used and if a stream is re-used, the statement execution will
> fail with 'Stream has already been read and end-of-file reached and cannot
> be re-used.'.</p>
> </div>
> -<a name="N1007A"></a><a name="Java.sql.ResultSet"></a>
> +<a name="Java.sql.ResultSet"></a>
> <h2 class="boxed">Java.sql.ResultSet</h2>
> <div class="section">
> <p>Support for data conversion using the getXXX() methods matches Table
> B-6 in the [JDBC3], with some extensions described below.</p>
> <p>Extension</p>
> <p>If the value column is null, then generally any getXXX method can be
> used to fetch the null value and a null or a representation of zero will be
> returned and a subsequent call to wasNull() will return true. It is not
> recommended that applications take advantage of this liberal conversion of
> SQL NULL values, use of a getXXX() method that works against NULL and
> non-NULL values is strongly recommended.</p>
> -<a name="N10084"></a><a name="deleteRow%28%29"></a>
> +<a name="deleteRow%28%29"></a>
> <h3 class="boxed">deleteRow()</h3>
> <p>Behavior Clarification</p>
> <p>After deleteRow, ResultSet will be positioned right before the next
> row for FORWARD ONLY updatable ResultSets.</p>
> -<a name="N1008C"></a><a name="updateRow%28%29"></a>
> +<a name="updateRow%28%29"></a>
> <h3 class="boxed">updateRow()</h3>
> <p>Behavior Clarification</p>
> <p>After updateRow, ResultSet will be positioned right before the next
> row for FORWARD ONLY updatable ResultSets.</p>
> -<a name="N10094"></a><a name="GetAsciiStream%28%29"></a>
> +<a name="GetAsciiStream%28%29"></a>
> <h3 class="boxed">GetAsciiStream()</h3>
> <p>Behavior Clarification</p>
> <p>An ASCII character is defined as an eight bit character (range 0x00 to
> 0xff), see CHAR() function definition by [JDBC3] in appendix C.2.</p>
> @@ -514,11 +515,11 @@ document.write("Last Published: " + docu
> </li>
> </ul>
> <p>This method is not recommended to use in Derby.<br>Because Derby
> handles characters as unicode internally , there is no advantage in using
> this method .</p>
> -<a name="N100AE"></a><a name="GetBinaryStream%28%29"></a>
> +<a name="GetBinaryStream%28%29"></a>
> <h3 class="boxed">GetBinaryStream()</h3>
> <p>Extensions</p>
> <p>On Types.BLOB columns returns a stream with identical contents to that
> returned by getBlob().getBinaryStream() on the same column if the BLOB
> value is not NULL. If the BLOB value is NULL then null is returned.</p>
> -<a name="N100B6"></a><a name="GetCharacterStream%28%29"></a>
> +<a name="GetCharacterStream%28%29"></a>
> <h3 class="boxed">GetCharacterStream()</h3>
> <p>Behavior Clarification</p>
> <p>For binary types (Types.BINARY, Types.VARBINARY, and
> Types.LONGVARBINARY, Types.BLOB) getString() the value is converted to a
> stream of characters as though it is encoded using UTF-16BE.</p>
> @@ -533,7 +534,7 @@ document.write("Last Published: " + docu
> <p>On Types.BLOB columns supported with conversion as a binary type.</p>
> </li>
> </ul>
> -<a name="N100C8"></a><a name="GetString%28%29"></a>
> +<a name="GetString%28%29"></a>
> <h3 class="boxed">GetString()</h3>
> <p>Behavior Clarification</p>
> <p>For binary types (Types.BINARY, Types.VARBINARY, and
> Types.LONGVARBINARY, Types.BLOB) getString() returns String containing a
> two character hexadecimal representation for every byte in a non-null
> value. The two characters are in the range ‘0’ –
> ‘9’ and ‘a’ – ‘f’. For NULL
> values, null is returned. Note, that this String does not match the
> contents of the stream returned by getAsciiStream or getCharacterStream on
> the same column.</p>
> @@ -548,10 +549,10 @@ document.write("Last Published: " + docu
> <p>On Types.BLOB columns supported with conversion as a binary type.</p>
> </li>
> </ul>
> -<a name="N100DA"></a><a name="GetUnicodeStream%28%29"></a>
> +<a name="GetUnicodeStream%28%29"></a>
> <h3 class="boxed">GetUnicodeStream()</h3>
> <p>Not implemented, deprecated by [JDBC3].</p>
> -<a name="N100E0"></a><a name="Examples"></a>
> +<a name="Examples"></a>
> <h3 class="boxed">Examples</h3>
> <p>Binary Column</p>
> <p>If a binary column has been set with the Java byte array containing
> fours bytes, byte[] data = {0x34, 0x87, 0xc2, 0x1f} then:</p>
> @@ -580,43 +581,43 @@ document.write("Last Published: " + docu
> </ul>
> </div>
> </div>
> -<a name="N100FD"></a><a name="java.sql.Blob"></a>
> +<a name="java.sql.Blob"></a>
> <h2 class="boxed">java.sql.Blob</h2>
> <div class="section">
> -<a name="N10101"></a><a name="getBytes%28int+pos%2C+int+length%29"></a>
> +<a name="getBytes%28int+pos%2C+int+length%29"></a>
> <h3 class="boxed">getBytes(int pos, int length)</h3>
> <p>Behavior Clarification</p>
> <p>If the pos (position) argument is greater than the length of the BLOB
> then an exception is thrown. This matches the semantics of the SQL SUBSTR
> function.</p>
> -<a name="N10109"></a><a name="position%28byte+pattern%
> 2C+int+start%29+and+position%28Blob+pattern%2C+int+start%29"></a>
> +<a name="position%28byte+pattern%2C+int+start%29+and+position%
> 28Blob+pattern%2C+int+start%29"></a>
> <h3 class="boxed">position(byte pattern, int start) and position(Blob
> pattern, int start)</h3>
> <p>Behavior Clarification</p>
> <p>If the pattern argument has length zero, then the value of start
> argument will be returned. This matches the semantics of the SQL LOCATE
> function.</p>
> </div>
> -<a name="N10111"></a><a name="java.sql.Clob"></a>
> +<a name="java.sql.Clob"></a>
> <h2 class="boxed">java.sql.Clob</h2>
> <div class="section">
> -<a name="N10115"></a><a name="getSubString%28int+pos%
> 2C+int+length%29"></a>
> +<a name="getSubString%28int+pos%2C+int+length%29"></a>
> <h3 class="boxed">getSubString(int pos, int length)</h3>
> <p>Behavior Clarification</p>
> <p>If the pos (position) argument is greater than the length of the CLOB
> then an exception is thrown. This matches the semantics of the SQL SUBSTR
> function.</p>
> -<a name="N1011D"></a><a name="position%28String+
> searchstr%2C+int+start%29+and"></a>
> +<a name="position%28String+searchstr%2C+int+start%29+and"></a>
> <h3 class="boxed">position(String searchstr, int start) andposition(Clob
> searchstr, int start)</h3>
> <p>Behavior Clarification</p>
> <p>If the searchstr argument has length zero (the empty string), then the
> value of start argument will be returned. This matches the semantics of the
> SQL LOCATE function.</p>
> </div>
> -<a name="N10127"></a><a name="Date+Handling"></a>
> +<a name="Date+Handling"></a>
> <h2 class="boxed">Date Handling</h2>
> <div class="section">
> -<a name="N1012B"></a><a name="Derby+SQL+DATE"></a>
> +<a name="Derby+SQL+DATE"></a>
> <h3 class="boxed">Derby SQL DATE</h3>
> <p>Derby’s SQL DATE type represents a date in the form yyyy-mm-dd
> with no associated time zone information.</p>
> -<a name="N10131"></a><a name="java.sql.Date"></a>
> +<a name="java.sql.Date"></a>
> <h4>java.sql.Date</h4>
> <p>A JDBC Date (java.sql.Date) by definition represents a point in time
> on a given date in a given time zone.</p>
> <p>[JDBC3] intends that the point in time for a java.sql.Date object is
> 00:00 (midnight), but this is not enforced by the class.</p>
> <p>JDBC drivers are required to return java.sql.Date objects that are
> normalized to 00:00 according to the required time zone.</p>
> <p>Applications are expected to pass in java.sql.Date instances that are
> normalized to 00:00 (see section 18.1.1 of [TUTORIAL3]).</p>
> -<a name="N1013D"></a><a name="Conversion+of+a+JDBC+
> java.sql.Date+to+a+Derby+DATE+value"></a>
> +<a name="Conversion+of+a+JDBC+java.sql.Date+to+a+Derby+DATE+value"></a>
> <h4>Conversion of a JDBC java.sql.Date to a Derby DATE value</h4>
> <ol>
> <li>
> @@ -647,7 +648,7 @@ document.write("Last Published: " + docu
> </ol>
> <p>Derby does not require that the application’s java.sql.Date
> value is normalized to 00:00 according to the required time zone.</p>
> <p>In both cases no time zone information is stored with the SQL DATE
> value.</p>
> -<a name="N10165"></a><a name="Conversion+of+a+Derby+
> DATE+value+to+a+JDBC+java.sql.Date"></a>
> +<a name="Conversion+of+a+Derby+DATE+value+to+a+JDBC+java.sql.Date"></a>
> <h4>Conversion of a Derby DATE value to a JDBC java.sql.Date</h4>
> <ol>
> <li>
> @@ -673,7 +674,7 @@ document.write("Last Published: " + docu
> </ul>
> </li>
> </ol>
> -<a name="N1017E"></a><a name="Conversion+of+a+string+
> type+to+a+JDBC+java.sql.Date"></a>
> +<a name="Conversion+of+a+string+type+to+a+JDBC+java.sql.Date"></a>
> <h4>Conversion of a string type to a JDBC java.sql.Date</h4>
> <p>Three different date formats are built into Derby.</p>
> <div style="margin-left: 2em">
> @@ -691,16 +692,16 @@ document.write("Last Published: " + docu
> </div>
> <p>If the format of the string matches one of the built in formats then a
> conversion to a java.sql.Date matches that of a SQL DATE value with value
> yyyy-mm-dd.</p>
> <p>If the string does not match any of the built in formats Derby
> attempts to use the Java locale specific parser to interpret the string as
> a date.</p>
> -<a name="N10194"></a><a name="Derby+SQL+TIME"></a>
> +<a name="Derby+SQL+TIME"></a>
> <h3 class="boxed">Derby SQL TIME</h3>
> <p>Derby’s SQL TIME type represents a time of day in the form
> hh:mm:ss with no associated time zone information.</p>
> -<a name="N1019A"></a><a name="java.sql.Time"></a>
> +<a name="java.sql.Time"></a>
> <h4>java.sql.Time</h4>
> <p>A JDBC Time (java.sql.Time) by definition represents a point in time
> on an unspecified day in a given time zone.</p>
> <p>Java.sql.Time extends java.util.date, so it includes a date. [JDBC3]
> intends that the date stored in a java.sql.Time be Jan 1 1970, but this is
> not enforced by the class.</p>
> <p>JDBC drivers are required to return java.sql.Time objects that are
> normalized to Jan. 1 1970 according to the required time zone.</p>
> <p>Applications are expected to pass in java.sql.Time instances that are
> normalized to Jan. 1 1970.</p>
> -<a name="N101A6"></a><a name="Conversion+of+a+JDBC+
> java.sql.Time+to+a+Derby+TIME+value"></a>
> +<a name="Conversion+of+a+JDBC+java.sql.Time+to+a+Derby+TIME+value"></a>
> <h4>Conversion of a JDBC java.sql.Time to a Derby TIME value</h4>
> <ol>
> <li>
> @@ -731,7 +732,7 @@ document.write("Last Published: " + docu
> </ol>
> <p>Derby does not require that the application’s java.sql.Time
> value be normalized to Jan 1 1970 according to the required time zone.</p>
> <p>In both cases no time zone information is stored with the SQL TIME
> value.</p>
> -<a name="N101CE"></a><a name="Conversion+of+a+Derby+
> TIME+value+to+a+JDBC+java.sql.Time"></a>
> +<a name="Conversion+of+a+Derby+TIME+value+to+a+JDBC+java.sql.Time"></a>
> <h4>Conversion of a Derby TIME value to a JDBC java.sql.Time</h4>
> <ol>
> <li>
> @@ -757,7 +758,7 @@ document.write("Last Published: " + docu
> </ul>
> </li>
> </ol>
> -<a name="N101E7"></a><a name="Conversion+of+a+string+
> type+to+a+JDBC+java.sql.Time"></a>
> +<a name="Conversion+of+a+string+type+to+a+JDBC+java.sql.Time"></a>
> <h4>Conversion of a string type to a JDBC java.sql.Time</h4>
> <p>Three different time formats are built into Derby:</p>
> <div style="margin-left: 2em">
> @@ -775,13 +776,13 @@ document.write("Last Published: " + docu
> </div>
> <p>If the format of the string matches one of the built in formats then a
> conversion to a java.sql.Time matches that of a SQL TIME value with value
> hh:mm:ss.</p>
> <p>If the string does not match any of the built in formats Derby
> attempts to use the Java locale specific parser to interpret the string as
> a date.</p>
> -<a name="N101FD"></a><a name="Derby+SQL+TIMESTAMP"></a>
> +<a name="Derby+SQL+TIMESTAMP"></a>
> <h3 class="boxed">Derby SQL TIMESTAMP</h3>
> <p>Derby’s SQL TIMESTAMP type represents a time of day in the form
> yyyy-mm-dd hh:mm:ss.fffffffff (nanosecond granularity) with no associated
> time zone information.</p>
> -<a name="N10203"></a><a name="java.sql.Timestamp"></a>
> +<a name="java.sql.Timestamp"></a>
> <h4>java.sql.Timestamp</h4>
> <p>A JDBC Timestamp (java.sql.Timestamp) by definition represents a point
> in time, with nanosecond resolution, in a given time zone.</p>
> -<a name="N10209"></a><a name="Conversion+of+a+JDBC+
> java.sql.Timestamp+to+a+Derby+TIMESTAMP+value"></a>
> +<a name="Conversion+of+a+JDBC+java.sql.Timestamp+to+a+Derby+
> TIMESTAMP+value"></a>
> <h4>Conversion of a JDBC java.sql.Timestamp to a Derby TIMESTAMP
> value</h4>
> <ol>
> <li>
> @@ -810,7 +811,7 @@ document.write("Last Published: " + docu
> </ul>
> </li>
> </ol>
> -<a name="N10235"></a><a name="Conversion+of+a+Derby+
> TIMESTAMP+value+to+a+JDBC+java.sql.Timestamp"></a>
> +<a name="Conversion+of+a+Derby+TIMESTAMP+value+to+a+JDBC+
> java.sql.Timestamp"></a>
> <h4>Conversion of a Derby TIMESTAMP value to a JDBC
> java.sql.Timestamp</h4>
> <ol>
> <li>
> @@ -836,7 +837,7 @@ document.write("Last Published: " + docu
> </ul>
> </li>
> </ol>
> -<a name="N1024E"></a><a name="Conversion+of+a+string+
> type+to+a+JDBC+java.sql.Timestamp"></a>
> +<a name="Conversion+of+a+string+type+to+a+JDBC+java.sql.Timestamp"></a>
> <h4>Conversion of a string type to a JDBC java.sql.Timestamp</h4>
> <p>Two different timestamp formats are built into Derby:</p>
> <div style="margin-left: 2em">
>
> Modified: websites/production/db/content/derby/papers/
> MiscPresentations.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/MiscPresentations.html
> (original)
> +++ websites/production/db/content/derby/papers/MiscPresentations.html
> Wed Sep 28 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Miscellaneous Derby Presentations</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -316,6 +316,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Miscellaneous Derby Presentations</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -329,9 +330,10 @@ document.write("Last Published: " + docu
> </li>
> </ul>
> </div>
> +</div>
>
>
> -<a name="N1000D"></a><a name="Colorado+Software+Summit+2004"></a>
> +<a name="Colorado+Software+Summit+2004"></a>
> <h2 class="boxed">Colorado Software Summit 2004</h2>
> <div class="section">
> <p>
> @@ -346,7 +348,7 @@ is available for download
> </div>
>
>
> -<a name="N10026"></a><a name="OSCON+2005"></a>
> +<a name="OSCON+2005"></a>
> <h2 class="boxed">OSCON 2005</h2>
> <div class="section">
> <p>
> @@ -365,7 +367,7 @@ Dive with Apache Derby: Perl, PHP, and P
> </div>
>
>
> -<a name="N1003F"></a><a name="Victorian+Java+User+Group+2008"></a>
> +<a name="Victorian+Java+User+Group+2008"></a>
> <h2 class="boxed">Victorian Java User Group 2008</h2>
> <div class="section">
> <p>
> @@ -405,7 +407,7 @@ document.write("Last Published: " + docu
> </div>
> <div class="copyright">
> Copyright ©
> - 2004-2014 Apache, Apache DB, Apache Derby, Apache Torque, Apache
> JDO, Apache DDLUtils, the Derby hat logo, the Apache JDO logo, and the
> Apache feather logo are trademarks of The Apache Software Foundation. All
> other marks mentioned may be trademarks or registered trademarks of their
> respective owners.</div>
> + 2004-2015 Apache, Apache DB, Apache Derby, Apache Torque, Apache
> JDO, Apache DDLUtils, the Derby hat logo, the Apache JDO logo, and the
> Apache feather logo are trademarks of The Apache Software Foundation. All
> other marks mentioned may be trademarks or registered trademarks of their
> respective owners.</div>
> <div id="feedback">
> Send feedback about the website to:
> <a id="feedbackto" href="mailto:derby-user@db.apache.org
> ?subject=Feedback%C2%A0papers/MiscPresentations.html">
> derby-user@db.apache.org</a>
>
> Modified: websites/production/db/content/derby/papers/alloc-page.png
> ============================================================
> ==================
> Binary files - no diff available.
>
> Modified: websites/production/db/content/derby/papers/btree_package.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/btree_package.html
> (original)
> +++ websites/production/db/content/derby/papers/btree_package.html Wed
> Sep 28 01:33:43 2016
> @@ -3,9 +3,8 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> -<meta name="generator" content="">
> <meta name="" content="">
> <title>org.apache.derby.impl.store.access.btree</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -318,6 +317,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>org.apache.derby.impl.store.access.btree</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -354,8 +354,9 @@ document.write("Last Published: " + docu
> </li>
> </ul>
> </div>
> +</div>
> <p>Implements BTree access method, which is the basis for SQL indexes.</p>
> -<a name="N1001B"></a><a name="Overview"></a>
> +<a name="Overview"></a>
> <h2 class="boxed">Overview</h2>
> <div class="section">
> <p>Derby implements secondary SQL indexes as BTrees. The high level
> features of the BTree implementation are:</p>
> @@ -367,7 +368,7 @@ document.write("Last Published: " + docu
> <li>Derby uses logical key deletes. This enables it to perform undos
> during rollbacks and restart recovery as single page operations.</li>
> </ol>
> </div>
> -<a name="N10031"></a><a name="High+level+structure+of+the+B%2BTree"></a>
> +<a name="High+level+structure+of+the+B%2BTree"></a>
> <h2 class="boxed">High level structure of the B+Tree</h2>
> <div class="section">
> <ul>
> @@ -378,12 +379,12 @@ document.write("Last Published: " + docu
> <li>IndexRows are generated by the <a href="http://db.apache.org/
> derby/javadoc/engine/org/apache/derby/iapi/sql/
> dictionary/IndexRowGenerator.html">IndexRowGenerator</a>.</li>
> </ul>
> </div>
> -<a name="N10058"></a><a name="Latching+implementation"></a>
> +<a name="Latching+implementation"></a>
> <h2 class="boxed">Latching implementation</h2>
> <div class="section">
> <p>Derby uses latches on pages to get exclusive access to the page while
> reading or writing the page (Derby only uses exclusive latches, no shared
> latches are used). In order to prevent deadlocks latches requested while
> holding other latches are always requested top/down and left to right.
> Btree splits are always left to right. If for any reason the code needs to
> break this protocol then it will first request the latch NOWAIT and if it
> can't get the latch it will release all current latches and wait for the
> latch it is trying to get, and then after obtaining it go about getting the
> other latches it needs for the particular operation. While traversing down
> the tree Derby may hold 2 latches: one on parent and one on child. It then
> continues doing "ladder" latching down the tree releasing the highest node
> when it has successfully got a new lower node latch. Latches are short
> term, only held while reading/modifying the page, never held while an I/O
> is happening. Structure modifications
> are all isolated from other operations through the use of latches.</p>
> </div>
> -<a name="N1005E"></a><a name="Locking+and+Isolation+Levels"></a>
> +<a name="Locking+and+Isolation+Levels"></a>
> <h2 class="boxed">Locking and Isolation Levels</h2>
> <div class="section">
> <p>Derby uses data only locking for its logical row level locking. All
> isolation level implementation is done using logical locks (Derby does not
> support non-locking isolation such as multi-versioning).</p>
> @@ -399,7 +400,7 @@ document.write("Last Published: " + docu
> <dd>No row locks are acquired. The code still gets table level intent
> locks to prevent concurrent DDL during the query.</dd>
> </dl>
> </div>
> -<a name="N1007F"></a><a name="BTree+Structure+Modifications"></a>
> +<a name="BTree+Structure+Modifications"></a>
> <h2 class="boxed">BTree Structure Modifications</h2>
> <div class="section">
> <p>In Derby, SMOs (structure modification operations - ie. page splits),
> only happen top down. This is not as concurrent as bottom up in <a
> class="external" href="http://www.almaden.ibm.com/u/mohan/RJ6846.pdf
> ">ARIES/IM</a>, but is simpler. As in ARIES/IM <q>Not more than 2 index
> pages are held latched simultaneously at anytime. In order to improve
> concurrency and to avoid deadlocks involving latches, even those latches
> are not held while waiting for a lock wich is not immediately grantable. No
> data page latch is held or acquired during an index access. Latch coupling
> is used while traversing the tree - ie. the latch on a parent page is held
> while requesting a latch on a child page.</q>
> @@ -408,24 +409,24 @@ document.write("Last Published: " + docu
> <p>The hard case is when P does not have room for descriminator key. In
> this case all latches are released, and Derby does a split pass from top to
> bottom, and will split the internal nodes that do not have room for the
> decrimator key. Note this may result in more splits than necessary for this
> particular insert, but the assumption is that the splits will have to
> happen eventually anyway. After this split pass is done, the search for the
> insert starts again from top down, but it must once again check for space
> because it has given up all its latches and some other transaction may have
> acquired the space in the meantime.</p>
> <p>Optimization is possible to remember C and see if it is right
> location, and/or use sideway pointers to search right rather than do
> research of tree.</p>
> </div>
> -<a name="N10091"></a><a name="Logical+Key+Deletes"></a>
> +<a name="Logical+Key+Deletes"></a>
> <h2 class="boxed">Logical Key Deletes</h2>
> <div class="section">
> <p>In both the BTree and the Heap, deletes are first executed by marking
> a "deleted" bit. This is to insure space on the page for abort, since row
> level locking will allow other rows on the page to be modified
> conncurrently with the transaction executing the delete. The system uses a
> background daemon to schedule work after commit to reclaim the space of the
> deleted rows. A row marked deleted can be "purged" if one can obtain a lock
> on it (if it was an uncommitted delete then the transaction doing the
> commit would still have an exclusive lock on the row).</p>
> </div>
> -<a name="N10097"></a><a name="Garbage+Collection+of+deleted+keys"></a>
> +<a name="Garbage+Collection+of+deleted+keys"></a>
> <h2 class="boxed">Garbage Collection of deleted keys</h2>
> <div class="section">
> <p>Since rows are only marked as "deleted", and not physically removed,
> it is necessary to perform space reclamation on deleted rows.</p>
> -<a name="N1009D"></a><a name="Online+during+BTREE+split"></a>
> +<a name="Online+during+BTREE+split"></a>
> <h3 class="boxed">Online during BTREE split</h3>
> <p>Whenever there is not enough room on a leaf to do an insert the code
> attempts to find space on the leaf, by checking if it can reclaim any
> committed deletes on that leaf. That work only requires the latch on the
> leaf and NOWAIT row write locks. It is expected that most of the space
> reclaim done in the BTree goes through this path. Most of this work is done
> in {@link org.apache.derby.impl.store.access.btree.BTreeController.
> reclaim_deleted_rows}.</p>
> -<a name="N100A3"></a><a name="BTREE+post+commit+work"></a>
> +<a name="BTREE+post+commit+work"></a>
> <h3 class="boxed">BTREE post commit work</h3>
> <p>Whenever a delete operation deletes the last row from a leaf page then
> a BtreePostCommit job is queued to be executed after the transaction which
> did the delete commits. This work currently requires a table level lock as
> page merges have not been implemented to be allowed concurrent with other
> operations. Many DBMSes don't even try to do page merges except when called
> from some sort of reorg utility. If all rows on page are purged, then the
> page will move to the free list and perform a merge to the tree.</p>
> <p>It is expected that the normal space reclamation happens with row
> locks during btree split, which is why not much work has been done to
> optimize btree post commit path</p>
> </div>
> -<a name="N100AB"></a><a name="Logging+and+Recovery"></a>
> +<a name="Logging+and+Recovery"></a>
> <h2 class="boxed">Logging and Recovery</h2>
> <div class="section">
> <p>Derby uses physical redo and logical undo for BTree inserts and
> deletes. Logical undo is simplified as a result of using logical key
> deletes. If keys were physically removed during deletes, then the undo of a
> key delete would have required an insert operation which can potentially
> lead to page splits at various levels within the tree. Since the key is not
> physically removed, but only marked as "deleted", undoing a key delete is
> accomplished easily. However, since the page where the insert or delete
> should take place may have moved, it may be necessary to search for the
> page.</p>
>
> Modified: websites/production/db/content/derby/papers/container-format.png
> ============================================================
> ==================
> Binary files - no diff available.
>
> Modified: websites/production/db/content/derby/papers/derby_arch.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/derby_arch.html (original)
> +++ websites/production/db/content/derby/papers/derby_arch.html Wed Sep
> 28 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Derby Engine Architecture Overview</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -316,6 +316,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Derby Engine Architecture Overview</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -347,6 +348,7 @@ document.write("Last Published: " + docu
> </ul>
> </li>
> </ul>
> +</div>
> </div>
>
>
> @@ -365,13 +367,13 @@ Please post any corrections or additiona
> </p>
>
>
> -<a name="N1001F"></a><a name="Module+View"></a>
> +<a name="Module+View"></a>
> <h2 class="boxed">Module View</h2>
> <div class="section">
> <p>
> A running system is comprised of a monitor and a collection of modules.
> </p>
> -<a name="N10028"></a><a name="Monitor"></a>
> +<a name="Monitor"></a>
> <h3 class="boxed">Monitor</h3>
> <p>
> The monitor is code that maps module requests,
> @@ -383,7 +385,7 @@ implementation, while in JDK 1.4 the dri
> implementation. This allows Derby to present a single JDBC driver to the
> application regardless of JDK and internally the correct driver is loaded.
> </p>
> -<a name="N10032"></a><a name="Modules"></a>
> +<a name="Modules"></a>
> <h3 class="boxed">Modules</h3>
> <p>
> A module is a set of discrete functionality, such as a lock manager,
> @@ -408,13 +410,13 @@ configurations out of the same code base
> </div>
>
>
> -<a name="N10043"></a><a name="Layer%2FBox+View"></a>
> +<a name="Layer%2FBox+View"></a>
> <h2 class="boxed">Layer/Box View</h2>
> <div class="section">
> <p>
> There are four main code areas: JDBC, SQL, Store and Services.
> </p>
> -<a name="N1004C"></a><a name="JDBC"></a>
> +<a name="JDBC"></a>
> <h3 class="boxed">JDBC</h3>
> <p>
> JDBC presents the only api to Derby to applications and consists of
> @@ -429,7 +431,7 @@ additional methods.
> <p>
> The JDBC layer sits on top of the SQL layer.
> </p>
> -<a name="N10059"></a><a name="SQL"></a>
> +<a name="SQL"></a>
> <h3 class="boxed">SQL</h3>
> <p>
> The SQL layer is split into two main logical areas, compilation and
> @@ -489,7 +491,7 @@ count.
> These result set objects interface with the Store layer to fetch rows
> from tables, indexes or perform sorts.
> </p>
> -<a name="N10084"></a><a name="Store"></a>
> +<a name="Store"></a>
> <h3 class="boxed">Store</h3>
> <p>
> The Store layer is split into two main areas, access and raw.
> @@ -506,7 +508,7 @@ store works with a pluggable file system
> to be stored in the Java filesystem, jar files, jar files in the
> classpath, or any other mechanism.
> </p>
> -<a name="N10091"></a><a name="Services"></a>
> +<a name="Services"></a>
> <h3 class="boxed">Services</h3>
> <p>
> Services are utility modules such as lock management, cache management
>
> Modified: websites/production/db/content/derby/papers/derby_htw.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/derby_htw.html (original)
> +++ websites/production/db/content/derby/papers/derby_htw.html Wed Sep 28
> 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>How Things Work</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -315,7 +315,8 @@ document.write("Last Published: " + docu
> <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>How Things Work</h1>
> +<h1>How Things Work</h1>
> +<div id="front-matter"></div>
>
>
> <div class="warning">
>
> Modified: websites/production/db/content/derby/papers/derby_web.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/derby_web.html (original)
> +++ websites/production/db/content/derby/papers/derby_web.html Wed Sep 28
> 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Apache Derby Web Site</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -175,6 +175,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Apache Derby Web Site</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -253,6 +254,7 @@ document.write("Last Published: " + docu
> </ul>
> </li>
> </ul>
> +</div>
> </div>
>
>
> @@ -271,21 +273,21 @@ Derby web site itself.
> </p>
>
>
> -<a name="N10018"></a><a name="Web+Site+Change+Notes"></a>
> +<a name="Web+Site+Change+Notes"></a>
> <h2 class="boxed">Web Site Change Notes</h2>
> <div class="section">
> -<a name="N1001E"></a><a name="21-Dec-2007%3A+Web+site+
> upgraded+to+Forrest+0.8"></a>
> +<a name="21-Dec-2007%3A+Web+site+upgraded+to+Forrest+0.8"></a>
> <h3 class="boxed">21-Dec-2007: Web site upgraded to Forrest 0.8</h3>
> <p>The web site was upgraded to build with the latest
> release of Forrest, Forrest 0.8.</p>
> -<a name="N10028"></a><a name="12-Aug-2005%3A+Web+site+
> upgraded+to+Forrest+0.7"></a>
> +<a name="12-Aug-2005%3A+Web+site+upgraded+to+Forrest+0.7"></a>
> <h3 class="boxed">12-Aug-2005: Web site upgraded to Forrest 0.7</h3>
> <p>The web site was recently upgraded to build with the latest
> release of Forrest, Forrest 0.7.</p>
> <p>If you receive OutOfMemoryErrors while trying to build the
> site, try increasing the amount of memory available to forrest
> by setting the ANT_OPTS environment variable to -mx512M.</p>
> -<a name="N10035"></a><a name="31-Jul-2005%3A+Web+site+
> moved+from+Incubator+to+Apache+DB"></a>
> +<a name="31-Jul-2005%3A+Web+site+moved+from+Incubator+to+Apache+DB"></a>
> <h3 class="boxed">31-Jul-2005: Web site moved from Incubator to Apache
> DB</h3>
> <p>
> Derby graduated from the Incubator to the Apache DB project,
> @@ -308,7 +310,7 @@ Specific changes, beginning with SVN rev
> </li>
>
> </ul>
> -<a name="N1004E"></a><a name="15-May-2005%3A+Version+
> 10.0+manuals+moved"></a>
> +<a name="15-May-2005%3A+Version+10.0+manuals+moved"></a>
> <h3 class="boxed">15-May-2005: Version 10.0 manuals moved</h3>
> <p>
> The files that comprise the 10.0 manuals are numerous (about 750), static,
> @@ -316,7 +318,7 @@ and take a while to build (20-40 minutes
> In May they were moved to a separate "mini" forrest site, which is now at
> <a href="http://db.apache.org/derby/docs/10.0/index.html">ht
> tp://db.apache.org/derby/docs/10.0/index.html</a>.
> </p>
> -<a name="N1005C"></a><a name="27-Jan-2005%3A+Web+site+
> upgraded+to+Forrest+0.6"></a>
> +<a name="27-Jan-2005%3A+Web+site+upgraded+to+Forrest+0.6"></a>
> <h3 class="boxed">27-Jan-2005: Web site upgraded to Forrest 0.6</h3>
> <p>
> The Derby web site was initialized in August 2004 with Forrest 0.5.1.
> @@ -355,7 +357,7 @@ blocks listed below:
> </div>
>
>
> -<a name="N1008B"></a><a name="Forrest+in+a+Nutshell"></a>
> +<a name="Forrest+in+a+Nutshell"></a>
> <h2 class="boxed">Forrest in a Nutshell</h2>
> <div class="section">
> <p>
> @@ -391,7 +393,7 @@ The Derby web site uses Forrest 0.8 and
>
>
>
> -<a name="N100B6"></a><a name="Testing+New+Pages+for+the+Derby+Site"></a>
> +<a name="Testing+New+Pages+for+the+Derby+Site"></a>
> <h2 class="boxed">Testing New Pages for the Derby Site</h2>
> <div class="section">
> <p>
> @@ -401,7 +403,7 @@ who wants to develop content for the Der
> It is much easier to integrate new pages by first
> testing them outside the Derby web site source tree.
> </p>
> -<a name="N100BF"></a><a name="Create+a+Forrest+seed+site"></a>
> +<a name="Create+a+Forrest+seed+site"></a>
> <h3 class="boxed">Create a Forrest seed site</h3>
> <p>
> The
> @@ -433,7 +435,7 @@ Below are some simple steps to get start
> <li> Look at the sample pages that are included in the seed site.</li>
>
> </ul>
> -<a name="N100F7"></a><a name="Add+your+new+page+to+the+seed+site"></a>
> +<a name="Add+your+new+page+to+the+seed+site"></a>
> <h3 class="boxed">Add your new page to the seed site</h3>
> <p>
> If you don't need to add a new page, skip this step.
> @@ -523,7 +525,7 @@ Otherwise, incorporate the new page(s) i
> source file. </li>
>
> </ul>
> -<a name="N1015A"></a><a name="What+editor+can+you+use+
> for+Forrest+XML%3F"></a>
> +<a name="What+editor+can+you+use+for+Forrest+XML%3F"></a>
> <h3 class="boxed">What editor can you use for Forrest XML?</h3>
> <p>
> The Forrest web site mentions jEdit, oXygen, xmlspy,
> @@ -554,7 +556,7 @@ If you find other tools that also work w
> by posting to
> <a href="../derby_mail.html">derby-dev@db.apache.org</a>.
> </p>
> -<a name="N10184"></a><a name="Resolve+Forrest+DTDs+locally"></a>
> +<a name="Resolve+Forrest+DTDs+locally"></a>
> <h3 class="boxed">Resolve Forrest DTDs locally</h3>
> <p>
> Many source files in the Derby web site repository are in Forrest XML
> format.
> @@ -587,7 +589,7 @@ The mechanics of doing that is described
>
>
>
> -<a name="N101A3"></a><a name="Updating+the+Apache+Derby+web+site"></a>
> +<a name="Updating+the+Apache+Derby+web+site"></a>
> <h2 class="boxed">Updating the Apache Derby web site </h2>
> <div class="section">
> <p>
> @@ -597,14 +599,14 @@ Steps 1-6 are for both contributors and
> Step 7 tells contributors how to create a patch.
> Steps 8-10 tell committers how to commit and publish changes.
> </p>
> -<a name="N101AC"></a><a name="1.+Install+Forrest+on+your+machine"></a>
> +<a name="1.+Install+Forrest+on+your+machine"></a>
> <h3 class="boxed">1. Install Forrest on your machine</h3>
> <p>
> If you haven't installed Forrest yet,
> <a class="external" href="http://forrest.apache.org/mirrors.cgi">install
> Forrest 0.8</a>
> on your local system.
> </p>
> -<a name="N101BA"></a><a name="2.+Check+out+the+Derby+web+site+pages"></a>
> +<a name="2.+Check+out+the+Derby+web+site+pages"></a>
> <h3 class="boxed">2. Check out the Derby web site pages </h3>
> <p>
> Check the Derby web site files out of the subversion repository:
> @@ -612,7 +614,7 @@ Check the Derby web site files out of th
> <pre class="code">
> svn co https://svn.apache.org/repos/asf/db/derby/site/trunk
> </pre>
> -<a name="N101C8"></a><a name="3.+Modify+files+in+the+src+tree"></a>
> +<a name="3.+Modify+files+in+the+src+tree"></a>
> <h3 class="boxed">3. Modify files in the src tree </h3>
> <p>
> After checking the site out of subversion,
> @@ -769,7 +771,7 @@ they control the information and links i
> </li>
>
> </ul>
> -<a name="N102DD"></a><a name="4.+Build+the+site"></a>
> +<a name="4.+Build+the+site"></a>
> <h3 class="boxed">4. Build the site </h3>
> <p>
> After modifying files, rebuild the site with the
> @@ -791,7 +793,7 @@ If you run out of memory building the we
> try setting the <span class="codefrag">ANT_OPTS</span> environment
> variable to
> <span class="codefrag">-mx512M</span>.
> </p>
> -<a name="N10306"></a><a name="5.+Test+the+changes"></a>
> +<a name="5.+Test+the+changes"></a>
> <h3 class="boxed">5. Test the changes </h3>
> <p>
> There are a couple ways (at least) to review changes.
> @@ -828,7 +830,7 @@ then Javascript adds extra breadcrumbs f
> won't be added when the site is viewed locally.</a>
>
> </p>
> -<a name="N1033B"></a><a name="odd_diffs"></a>
> +<a name="odd_diffs"></a>
> <h3 class="boxed">6. Adjust the site build - odd diffs</h3>
> <p>Derby developers build the site on a variety of platforms,
> including Windows, Mac, and Linux. The
> @@ -854,7 +856,7 @@ should revert the changes made to the <s
> <pre class="code">svn revert build\site\skin\*</pre>
> <p>If you are using TortoiseSVN, you can use Windows Explorer to revert
> the
> changes.</p>
> -<a name="N10381"></a><a name="7.+Create+a+patch"></a>
> +<a name="7.+Create+a+patch"></a>
> <h3 class="boxed">7. Create a patch</h3>
> <p>
> Create a patch at the <span class="codefrag">trunk</span> level and only
> include the
> @@ -864,7 +866,7 @@ Create a patch at the <span class="codef
> <p>
> Upload the patch to a Jira issue to make it available to a Derby
> committer.
> </p>
> -<a name="N10398"></a><a name="8.+Commit+changes+to+
> the+src+and+build%2Fsite+directories"></a>
> +<a name="8.+Commit+changes+to+the+src+and+build%2Fsite+directories"></a>
> <h3 class="boxed">8. Commit changes to the src and build/site
> directories</h3>
> <p>
> Apply any patch, if one was provided, then build and test the web site
> @@ -910,7 +912,7 @@ svn commit --message "here is my commit
> cd ../build/site
> svn commit --message "here is my commit message"
> </pre>
> -<a name="N103E0"></a><a name="9.+Make+web+site+changes+visible"></a>
> +<a name="9.+Make+web+site+changes+visible"></a>
> <h3 class="boxed">9. Make web site changes visible</h3>
> <p>
> A Derby committer can force the source tree to be updated to the latest
> change as follows:
> @@ -926,7 +928,7 @@ However, www.apache.org automatically sy
> and the <span class="codefrag">build/site</span> tree will get synced
> right away,
> so there is no need for this.
> </p>
> -<a name="N103F7"></a><a name="10.+Considering+a+quick+
> fix+to+the+build+tree%3F"></a>
> +<a name="10.+Considering+a+quick+fix+to+the+build+tree%3F"></a>
> <h3 class="boxed">10. Considering a quick fix to the build tree?</h3>
> <p>
> If you modify a file in the <span class="codefrag">build/site</span>
> tree,
>
> Modified: websites/production/db/content/derby/papers/field-
> header-non-overflow.png
> ============================================================
> ==================
> Binary files - no diff available.
>
> Modified: websites/production/db/content/derby/papers/field-
> header-overflow.png
> ============================================================
> ==================
> Binary files - no diff available.
>
> Modified: websites/production/db/content/derby/papers/fortune_tut.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/fortune_tut.html
> (original)
> +++ websites/production/db/content/derby/papers/fortune_tut.html Wed Sep
> 28 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Apache Derby Fortune Server Tutorial</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -316,6 +316,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Apache Derby Fortune Server Tutorial</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -337,10 +338,11 @@ document.write("Last Published: " + docu
> <a href="#Revision+History">Revision History</a>
> </li>
> </ul>
> +</div>
> </div>
>
>
> -<a name="N1000D"></a><a name="Overview"></a>
> +<a name="Overview"></a>
> <h2 class="boxed">Overview</h2>
> <div class="section">
> <p>
> @@ -365,7 +367,7 @@ all within Derby's easy-to-use embedded
> </div>
>
>
> -<a name="N10025"></a><a name="Intended+Audience"></a>
> +<a name="Intended+Audience"></a>
> <h2 class="boxed">Intended Audience</h2>
> <div class="section">
> <p>
> @@ -377,7 +379,7 @@ so lack of experience in any of these ar
> </div>
>
>
> -<a name="N1002F"></a><a name="Tutorial+Topics"></a>
> +<a name="Tutorial+Topics"></a>
> <h2 class="boxed">Tutorial Topics</h2>
> <div class="section">
> <p>
> @@ -439,7 +441,7 @@ The tutorial is organized into the secti
>
>
>
> -<a name="N10072"></a><a name="Download+Software"></a>
> +<a name="Download+Software"></a>
> <h2 class="boxed">Download Software</h2>
> <div class="section">
> <ul>
> @@ -469,7 +471,7 @@ The tutorial is organized into the secti
> </div>
>
>
> -<a name="N1009B"></a><a name="Credits+and+Acknowledgments"></a>
> +<a name="Credits+and+Acknowledgments"></a>
> <h2 class="boxed">Credits and Acknowledgments</h2>
> <div class="section">
> <p>
> @@ -499,7 +501,7 @@ was used for generating the web-based ma
> </div>
>
>
> -<a name="N100BD"></a><a name="Revision+History"></a>
> +<a name="Revision+History"></a>
> <h2 class="boxed">Revision History</h2>
> <div class="section">
> <p>
>
> Modified: websites/production/db/content/derby/papers/index.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/index.html (original)
> +++ websites/production/db/content/derby/papers/index.html Wed Sep 28
> 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Apache Derby Papers</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -319,6 +319,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Apache Derby Papers</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -334,6 +335,7 @@ document.write("Last Published: " + docu
> <a href="#How+to+Contribute+Papers">How to Contribute Papers</a>
> </li>
> </ul>
> +</div>
> </div>
>
>
> @@ -343,7 +345,7 @@ This <em>ad hoc</em> spot in the Derby s
> </p>
>
>
> -<a name="N10017"></a><a name="Derby+Engine"></a>
> +<a name="Derby+Engine"></a>
> <h2 class="boxed">Derby Engine</h2>
> <div class="section">
> <p>
> @@ -457,7 +459,7 @@ then open the file you saved.)
> </div>
>
>
> -<a name="N100FF"></a><a name="Derby+Network+Client"></a>
> +<a name="Derby+Network+Client"></a>
> <h2 class="boxed">Derby Network Client</h2>
> <div class="section">
> <p>
> @@ -479,7 +481,7 @@ The table below summarizes white papers
> </div>
>
>
> -<a name="N10125"></a><a name="Instruction"></a>
> +<a name="Instruction"></a>
> <h2 class="boxed">Instruction</h2>
> <div class="section">
> <p>
> @@ -492,7 +494,7 @@ even more tutorials and other instructio
> </div>
>
>
> -<a name="N10137"></a><a name="How+to+Contribute+Papers"></a>
> +<a name="How+to+Contribute+Papers"></a>
> <h2 class="boxed">How to Contribute Papers</h2>
> <div class="section">
> <p>
>
> Modified: websites/production/db/content/derby/papers/logformats.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/logformats.html (original)
> +++ websites/production/db/content/derby/papers/logformats.html Wed Sep
> 28 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Derby Write Ahead Log Format</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -316,6 +316,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Derby Write Ahead Log Format</h1>
> +<div id="front-matter">
> <div class="abstract">This document describes the storage format of Derby
> Write Ahead
> Log. This is a work-in-progress derived from Javadoc comments and
> from
> explanations Mike Matrigali and others posted to the Derby lists.
> Please
> @@ -358,9 +359,10 @@ document.write("Last Published: " + docu
> <a href="#Pointers+to+relevant+classes">Pointers to relevant classes</a>
> </li>
> </ul>
> +</div>
> </div>
>
> -<a name="N10010"></a><a name="introduction"></a>
> +<a name="introduction"></a>
> <h2 class="boxed"> Introduction </h2>
> <div class="section">
> <p> Derby uses a Write Ahead Log to record all changes to the database.
> @@ -389,7 +391,7 @@ document.write("Last Published: " + docu
> paper.</p>
> </div>
>
> -<a name="N1002C"></a><a name="References"></a>
> +<a name="References"></a>
> <h2 class="boxed"> References </h2>
> <div class="section">
> <p> A good description of Write Ahead Logging, and how a log is typically
> @@ -401,7 +403,7 @@ document.write("Last Published: " + docu
> .</p>
> </div>
>
> -<a name="N1003D"></a><a name="Derby+implementation+of+
> the+Write+Ahead+Log"></a>
> +<a name="Derby+implementation+of+the+Write+Ahead+Log"></a>
> <h2 class="boxed">Derby implementation of the Write Ahead Log</h2>
> <div class="section">
> <p> Derby implements the Write Ahead Log using a non-circular file system
> @@ -468,7 +470,7 @@ document.write("Last Published: " + docu
> while"</li>
>
> </ol>
> -<a name="N1007C"></a><a name="LogCounter"></a>
> +<a name="LogCounter"></a>
> <h3 class="boxed">LogCounter</h3>
> <p>Log records are identified using LogCounter, which is an implementation
> of LogInstant, a Derby term for LSN. The LogCounter is made
> up of
> @@ -480,7 +482,7 @@ document.write("Last Published: " + docu
> tells if one log instant is lessThan, equals or greater than
> another.</p>
> </div>
>
> -<a name="N1008A"></a><a name="Format+of+Write+Ahead+Log"></a>
> +<a name="Format+of+Write+Ahead+Log"></a>
> <h2 class="boxed"> Format of Write Ahead Log </h2>
> <div class="section">
> <p> An implementation of file based log is in
> @@ -488,7 +490,7 @@ document.write("Last Published: " + docu
> This LogFactory is responsible for the formats of 2 kinds of
> file:
> the log file and the log control file. And it is responsible
> for the
> format of the log record wrapper. </p>
> -<a name="N10096"></a><a name="Format+of+Log+Control+File"></a>
> +<a name="Format+of+Log+Control+File"></a>
> <h3 class="boxed">Format of Log Control File</h3>
> <p>The log control file contains information about which log files are
> present and where the last checkpoint log record is
> located.</p>
> @@ -586,7 +588,7 @@ document.write("Last Published: " + docu
> </tr>
>
> </table>
> -<a name="N1014C"></a><a name="Format+of+the+log+file"></a>
> +<a name="Format+of+the+log+file"></a>
> <h3 class="boxed">Format of the log file</h3>
> <p>The log file contains log records which record all the changes to
> the database. The complete transaction log is composed of a
> series
> @@ -654,7 +656,7 @@ document.write("Last Published: " + docu
> </tr>
>
> </table>
> -<a name="N101C1"></a><a name="Format+of+the+log+record+wrapper"></a>
> +<a name="Format+of+the+log+record+wrapper"></a>
> <h3 class="boxed">Format of the log record wrapper</h3>
> <p>The log record wrapper provides information for the log scan.</p>
> <table class="ForrestTable" cellspacing="1" cellpadding="4">
> @@ -695,7 +697,7 @@ document.write("Last Published: " + docu
> </tr>
>
> </table>
> -<a name="N1020F"></a><a name="The+format+of+a+log+record"></a>
> +<a name="The+format+of+a+log+record"></a>
> <h3 class="boxed">The format of a log record</h3>
> <p>The log record described every change to the persistent store</p>
> <table class="ForrestTable" cellspacing="1" cellpadding="4">
> @@ -851,7 +853,7 @@ document.write("Last Published: " + docu
> </table>
> </div>
>
> -<a name="N1033C"></a><a name="Pointers+to+relevant+classes"></a>
> +<a name="Pointers+to+relevant+classes"></a>
> <h2 class="boxed">Pointers to relevant classes</h2>
> <div class="section">
> <div class="fixme">
>
> Modified: websites/production/db/content/derby/papers/optimizer.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/optimizer.html (original)
> +++ websites/production/db/content/derby/papers/optimizer.html Wed Sep 28
> 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Derby Optimizer Design</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -316,6 +316,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Derby Optimizer Design</h1>
> +<div id="front-matter">
> <div class="abstract">This document describes the Derby Optimizer. This
> is a work-in-progress
> derived from Javadoc comments and from explanations Jeffrey
> Lichtman and
> others posted to the Derby lists. Please post questions,
> comments, and
> @@ -332,9 +333,10 @@ document.write("Last Published: " + docu
> <a href="#Potential+Improvements+to+the+Optimizer">Potential
> Improvements to the Optimizer</a>
> </li>
> </ul>
> +</div>
> </div>
>
> -<a name="N10010"></a><a name="overview"></a>
> +<a name="overview"></a>
> <h2 class="boxed">Overview</h2>
> <div class="section">
> <div class="note">
> @@ -404,7 +406,7 @@ document.write("Last Published: " + docu
> the join order musn't be inverted under the current
> implementation). </p>
> </div>
>
> -<a name="N10032"></a><a name="Example+of+a+5-way+Join"></a>
> +<a name="Example+of+a+5-way+Join"></a>
> <h2 class="boxed">Example of a 5-way Join</h2>
> <div class="section">
> <p> The optimizer looks at so many
> @@ -522,7 +524,7 @@ t1 t2 t3 JOIN
> - t5 - t2. </p>
> </div>
>
> -<a name="N10078"></a><a name="Potential+Improvements+
> to+the+Optimizer"></a>
> +<a name="Potential+Improvements+to+the+Optimizer"></a>
> <h2 class="boxed">Potential Improvements to the Optimizer</h2>
> <div class="section">
> <p> It's hard to consider the optimizer by itself. Many optimizer
> enhancements
>
> Modified: websites/production/db/content/derby/papers/page-format.png
> ============================================================
> ==================
> Binary files - no diff available.
>
> Modified: websites/production/db/content/derby/papers/pageformats.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/pageformats.html
> (original)
> +++ websites/production/db/content/derby/papers/pageformats.html Wed Sep
> 28 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Derby On Disk Page Format</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -316,6 +316,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Derby On Disk Page Format</h1>
> +<div id="front-matter">
> <div class="abstract">This document describes the storage format of Derby
> disk pages.
>
> This is a work-in-progress derived from Javadoc comments and
> @@ -367,8 +368,9 @@ document.write("Last Published: " + docu
> </li>
> </ul>
> </div>
> +</div>
>
> -<a name="N10010"></a><a name="introduction"></a>
> +<a name="introduction"></a>
> <h2 class="boxed"> Introduction </h2>
> <div class="section">
> <p>Derby stores table and index data in Containers, which currently map
> @@ -437,18 +439,18 @@ have allocation bit maps.
> </p>
> </div>
>
> -<a name="N10049"></a><a name="storedpage"></a>
> +<a name="storedpage"></a>
> <h2 class="boxed">Data Page Format</h2>
> <div class="section">
> <p>A data page is broken into five sections.
>
> <img alt="" src="page-format.png"></p>
> -<a name="N10055"></a><a name="formatid"></a>
> +<a name="formatid"></a>
> <h3 class="boxed">Format Id </h3>
> <p> The formatId is a 4 bytes array, it contains the format Id of this
>
> page. The possible values are RAW_STORE_STORED_PAGE or
> RAW_STORE_ALLOC_PAGE.</p>
> -<a name="N1005F"></a><a name="pageheader"></a>
> +<a name="pageheader"></a>
> <h3 class="boxed"> Page Header </h3>
> <p> The page header is a fixed size, 56 bytes. </p>
> <table class="ForrestTable" cellspacing="1" cellpadding="4">
> @@ -608,7 +610,7 @@ have allocation bit maps.
>
> that 0 means field was never assigned. </div>
> </div>
> -<a name="N1017A"></a><a name="records"></a>
> +<a name="records"></a>
> <h3 class="boxed"> Records </h3>
> <p>The records section contains zero or more records. Each record starts
>
> @@ -896,7 +898,7 @@ have allocation bit maps.
>
> </div>
> </div>
> -<a name="N102C3"></a><a name="slottable"></a>
> +<a name="slottable"></a>
> <h3 class="boxed">Slot Offset Table</h3>
> <p>The slot offset table is a table of 6 or 12 bytes per record, depending
>
> @@ -941,14 +943,14 @@ have allocation bit maps.
> First slot is slot 0. The slot table grows backwards. Slots are
> never
>
> left empty. </p>
> -<a name="N1030A"></a><a name="checksum"></a>
> +<a name="checksum"></a>
> <h3 class="boxed">Checksum</h3>
> <p>8 bytes of a java.util.zip.CRC32 checksum of the entire's page contents
>
> without the 8 bytes representing the checksum.</p>
> </div>
>
> -<a name="N10315"></a><a name="allocpage"></a>
> +<a name="allocpage"></a>
> <h2 class="boxed">Allocation Page</h2>
> <div class="section">
> <p> An allocation page of the file container extends a normal Stored page,
> @@ -1162,7 +1164,7 @@ have allocation bit maps.
> extent row to the alloc page.
>
> </p>
> -<a name="N103EA"></a><a name="Alloc+Page+detailed+
> implementation+notes"></a>
> +<a name="Alloc+Page+detailed+implementation+notes"></a>
> <h3 class="boxed">
>
> Alloc Page detailed implementation notes</h3>
> @@ -1232,7 +1234,7 @@ have allocation bit maps.
> <p>For the fields in an allocation extent row.</p>
> </div>
>
> -<a name="N10404"></a><a name="Allocation+Extent"></a>
> +<a name="Allocation+Extent"></a>
> <h2 class="boxed">Allocation Extent</h2>
> <div class="section">
> <p>
>
> Modified: websites/production/db/content/derby/papers/recovery.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/recovery.html (original)
> +++ websites/production/db/content/derby/papers/recovery.html Wed Sep 28
> 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Derby Logging and Recovery</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -316,6 +316,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Derby Logging and Recovery</h1>
> +<div id="front-matter">
> <div class="abstract">This document describes how Derby implements
> logging and recovery.
> This is a work-in-progress derived from Javadoc comments and from
> explanations
> Mike Matrigali and others posted to the Derby lists. Please post
> questions,
> @@ -366,14 +367,15 @@ document.write("Last Published: " + docu
> </li>
> </ul>
> </div>
> +</div>
>
> -<a name="N10010"></a><a name="introduction"></a>
> +<a name="introduction"></a>
> <h2 class="boxed"> Introduction </h2>
> <div class="section">
> <p>Derby transaction logging and recovery is based upon the ARIES
> algorithm.</p>
> </div>
>
> -<a name="N1001A"></a><a name="ARIES+-+An+Overview"></a>
> +<a name="ARIES+-+An+Overview"></a>
> <h2 class="boxed">ARIES - An Overview</h2>
> <div class="section">
> <p>Following is a brief description of the main principles behind
> ARIES.</p>
> @@ -418,7 +420,7 @@ transaction decides to rollback.
> system need to know about high level data structures. </p>
> </div>
>
> -<a name="N10033"></a><a name="Features+of+ARIES"></a>
> +<a name="Features+of+ARIES"></a>
> <h2 class="boxed">Features of ARIES</h2>
> <div class="section">
> <p>ARIES includes a number of optimisations to reduce the amount of work
> @@ -458,7 +460,7 @@ transaction decides to rollback.
> UndoLsn pointer as described previously.</p>
> </div>
>
> -<a name="N10049"></a><a name="References"></a>
> +<a name="References"></a>
> <h2 class="boxed">References</h2>
> <div class="section">
> <ol>
> @@ -489,7 +491,7 @@ transaction decides to rollback.
> </ol>
> </div>
>
> -<a name="N1006B"></a><a name="Derby+implementation+of+ARIES"></a>
> +<a name="Derby+implementation+of+ARIES"></a>
> <h2 class="boxed">Derby implementation of ARIES</h2>
> <div class="section">
> <p>I shall only describe how Derby differs from standard ARIES
> implementation.
> @@ -551,7 +553,7 @@ transaction decides to rollback.
> done.</p>
> </div>
>
> -<a name="N1008F"></a><a name="Derby+recovery+process"></a>
> +<a name="Derby+recovery+process"></a>
> <h2 class="boxed">Derby recovery process</h2>
> <div class="section">
> <p>Implemented in <span class="codefrag">org.apache.
> derby.impl.store.raw.log.LogToFile.recover()</span>
> @@ -574,7 +576,7 @@ transaction decides to rollback.
> </dl>
> </div>
>
> -<a name="N100B0"></a><a name="Recovery+Redo+pass"></a>
> +<a name="Recovery+Redo+pass"></a>
> <h2 class="boxed">Recovery Redo pass</h2>
> <div class="section">
> <p>Implemented in <span class="codefrag">org.apache.
> derby.impl.store.raw.log.FileLogger.redo()</span>
> @@ -598,7 +600,7 @@ transaction decides to rollback.
> </ol>
> </div>
>
> -<a name="N100CB"></a><a name="Recovery+Undo+pass"></a>
> +<a name="Recovery+Undo+pass"></a>
> <h2 class="boxed">Recovery Undo pass</h2>
> <div class="section">
> <p>Implemented in <span class="codefrag">org.apache.
> derby.impl.store.raw.xact.XactFactory.rollbackAllTransactions()</span>
> @@ -614,7 +616,7 @@ transaction decides to rollback.
> </ol>
> </div>
>
> -<a name="N100E3"></a><a name="Checkpoints"></a>
> +<a name="Checkpoints"></a>
> <h2 class="boxed">Checkpoints</h2>
> <div class="section">
> <p>Implemented in <span class="codefrag">org.apache.
> derby.impl.store.raw.log.LogToFile.checkpoint()</span>
> @@ -739,7 +741,7 @@ transaction decides to rollback.
> </p>
> </div>
>
> -<a name="N1015E"></a><a name="Derby+Logging+Overview"></a>
> +<a name="Derby+Logging+Overview"></a>
> <h2 class="boxed">Derby Logging Overview</h2>
> <div class="section">
> <p>A loggable action in Derby is redoable. If the action implements
> Undoable interface, then it is also
> @@ -775,7 +777,7 @@ transaction decides to rollback.
> </ol>
> </div>
>
> -<a name="N10180"></a><a name="Loggable+Interface+Hierarchy"></a>
> +<a name="Loggable+Interface+Hierarchy"></a>
> <h2 class="boxed">Loggable Interface Hierarchy</h2>
> <div class="section">
> <ul>
> @@ -805,7 +807,7 @@ transaction decides to rollback.
> </ul>
> </div>
>
> -<a name="N101B2"></a><a name="Container+Log+Operations+Hierarchy"></a>
> +<a name="Container+Log+Operations+Hierarchy"></a>
> <h2 class="boxed">Container Log Operations Hierarchy</h2>
> <div class="section">
> <ul>
> @@ -826,7 +828,7 @@ transaction decides to rollback.
> </ul>
> </div>
>
> -<a name="N101F7"></a><a name="Transaction+Management+
> Log+Operations+Hierarchy"></a>
> +<a name="Transaction+Management+Log+Operations+Hierarchy"></a>
> <h2 class="boxed">Transaction Management Log Operations Hierarchy</h2>
> <div class="section">
> <ul>
> @@ -840,7 +842,7 @@ transaction decides to rollback.
> </ul>
> </div>
>
> -<a name="N1022B"></a><a name="Page+Level+Log+Operations+Hierarchy"></a>
> +<a name="Page+Level+Log+Operations+Hierarchy"></a>
> <h2 class="boxed">Page Level Log Operations Hierarchy</h2>
> <div class="section">
> <ul>
>
> Modified: websites/production/db/content/derby/papers/versionupgrade.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/papers/versionupgrade.html
> (original)
> +++ websites/production/db/content/derby/papers/versionupgrade.html Wed
> Sep 28 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Derby Versioning Scheme</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -316,6 +316,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Derby Versioning Scheme</h1>
> +<div id="front-matter">
> <div class="abstract">This document describes the Derby Versioning
> Scheme. This is a
> work-in-progress derived from Javadoc comments and from
> explanations Dan
> Debrunner and others posted to the Derby lists. Please post
> questions,
> @@ -335,9 +336,10 @@ document.write("Last Published: " + docu
> <a href="#Upgrading+System+Catalogs">Upgrading System Catalogs</a>
> </li>
> </ul>
> +</div>
> </div>
>
> -<a name="N10010"></a><a name="Basic+Numbering+Scheme"></a>
> +<a name="Basic+Numbering+Scheme"></a>
> <h2 class="boxed">Basic Numbering Scheme</h2>
> <div class="section">
> <div class="note">
> @@ -393,7 +395,7 @@ document.write("Last Published: " + docu
> had undergone 3 additional QA testing cycles. </p>
> </div>
>
> -<a name="N10038"></a><a name="Sysinfo+and+how+it+reports+versions"></a>
> +<a name="Sysinfo+and+how+it+reports+versions"></a>
> <h2 class="boxed">Sysinfo and how it reports versions</h2>
> <div class="section">
> <p> This version value is reported by the sysinfo utility, in some
> messages
> @@ -442,7 +444,7 @@ document.write("Last Published: " + docu
> </table>
> </div>
>
> -<a name="N1008E"></a><a name="Version+Upgrade+Mechanism"></a>
> +<a name="Version+Upgrade+Mechanism"></a>
> <h2 class="boxed">Version Upgrade Mechanism</h2>
> <div class="section">
> <div class="note">
> @@ -511,7 +513,7 @@ document.write("Last Published: " + docu
> SALESDB with 10.0.x.y or 10.1.x.y would fail. </p>
> </div>
>
> -<a name="N100D7"></a><a name="Upgrading+System+Catalogs"></a>
> +<a name="Upgrading+System+Catalogs"></a>
> <h2 class="boxed">Upgrading System Catalogs</h2>
> <div class="section">
> <div class="note">
>
> Modified: websites/production/db/content/derby/quick_start.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/quick_start.html (original)
> +++ websites/production/db/content/derby/quick_start.html Wed Sep 28
> 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Apache Derby: Quick Start</title>
> <link type="text/css" href="skin/basic.css" rel="stylesheet">
> @@ -157,6 +157,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Apache Derby: Quick Start</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -169,10 +170,11 @@ document.write("Last Published: " + docu
> <a href="#Next+Steps+for+Developers">Next Steps for Developers</a>
> </li>
> </ul>
> +</div>
> </div>
>
>
> -<a name="N1000D"></a><a name="The+Basics"></a>
> +<a name="The+Basics"></a>
> <h2 class="boxed">The Basics</h2>
> <div class="section">
> <p>
> @@ -208,7 +210,7 @@ The resources listed below are intended
> </div>
>
>
> -<a name="N10040"></a><a name="Next+Steps+for+Users"></a>
> +<a name="Next+Steps+for+Users"></a>
> <h2 class="boxed">Next Steps for Users</h2>
> <div class="section">
> <p>
> @@ -329,7 +331,7 @@ As you learn more about Derby, feel free
> </div>
>
>
> -<a name="N100CB"></a><a name="Next+Steps+for+Developers"></a>
> +<a name="Next+Steps+for+Developers"></a>
> <h2 class="boxed">Next Steps for Developers</h2>
> <div class="section">
> <p>
>
> Modified: websites/production/db/content/derby/releases/
> release-10.0.2.1.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/releases/release-10.0.2.1.html
> (original)
> +++ websites/production/db/content/derby/releases/release-10.0.2.1.html
> Wed Sep 28 01:33:43 2016
> @@ -3,7 +3,7 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> <title>Apache Derby 10.0.2.1 Incubator Release</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> @@ -157,6 +157,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Apache Derby 10.0.2.1 Incubator Release</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -173,8 +174,9 @@ document.write("Last Published: " + docu
> </li>
> </ul>
> </div>
> +</div>
>
> -<a name="N1000D"></a><a name="Distributions"></a>
> +<a name="Distributions"></a>
> <h2 class="boxed">Distributions</h2>
> <div class="section">
> <p>There are three different distributions:</p>
> @@ -204,7 +206,7 @@ document.write("Last Published: " + docu
> </div>
>
>
> -<a name="N1007C"></a><a name="Release+Overview"></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
> @@ -266,7 +268,7 @@ document.write("Last Published: " + docu
> </div>
>
>
> -<a name="N100D7"></a><a name="Release+Notes"></a>
> +<a name="Release+Notes"></a>
> <h2 class="boxed">Release Notes</h2>
> <div class="section">
> <p>Derby version 10.0.2.1</p>
> @@ -588,7 +590,7 @@ document.write("Last Published: " + docu
> </div>
>
>
> -<a name="N10464"></a><a name="Testing"></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>
>
> Modified: websites/production/db/content/derby/releases/
> release-10.1.1.0.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/releases/release-10.1.1.0.html
> (original)
> +++ websites/production/db/content/derby/releases/release-10.1.1.0.html
> Wed Sep 28 01:33:43 2016
> @@ -3,9 +3,8 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> -<meta name="generator" content="">
> <title>Apache Derby 10.1.1.0 Release</title>
> <link type="text/css" href="../skin/basic.css" rel="stylesheet">
> <link media="screen" type="text/css" href="../skin/screen.css"
> rel="stylesheet">
> @@ -158,6 +157,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Apache Derby 10.1.1.0 Release</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -177,7 +177,8 @@ document.write("Last Published: " + docu
> </li>
> </ul>
> </div>
> -<a name="N10010"></a><a name="Distributions"></a>
> +</div>
> +<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. It is good practice to <a href="#Verifying+releases">verify
> the integrity</a> of the distribution files.</p>
> @@ -206,7 +207,7 @@ document.write("Last Published: " + docu
> <a class="external" href="http://archive.apache.
> org/dist/db/derby/db-derby-10.1.1.0/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.1.0/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.1.0/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="N1009C"></a><a name="Release+Overview"></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.</p>
> @@ -258,7 +259,7 @@ document.write("Last Published: " + docu
> <li>JSR-169, JDBC 2.1, and JDBC 3.0 support</li>
> </ul>
> </div>
> -<a name="N100F1"></a><a name="Release+Notes"></a>
> +<a name="Release+Notes"></a>
> <h2 class="boxed">Release Notes</h2>
> <div class="section">
> <p>Derby version 10.1.1.0</p>
> @@ -776,7 +777,7 @@ document.write("Last Published: " + docu
> </tr>
> </table>
> </div>
> -<a name="N1059F"></a><a name="Testing"></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>
> @@ -852,7 +853,7 @@ document.write("Last Published: " + docu
> <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="N1064A"></a><a name="Verifying+releases"></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>
>
> Modified: websites/production/db/content/derby/releases/
> release-10.1.2.1.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/releases/release-10.1.2.1.html
> (original)
> +++ websites/production/db/content/derby/releases/release-10.1.2.1.html
> Wed Sep 28 01:33:43 2016
> @@ -3,9 +3,8 @@
> <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-version" content="0.9">
> <meta name="Forrest-skin-name" content="pelt">
> -<meta name="generator" content="">
> <title>Apache Derby 10.1.2.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">
> @@ -158,6 +157,7 @@ document.write("Last Published: " + docu
> <input value="+a" class="biggerfont"
> title="Enlarge text" onclick="ndeSetTextSize('incr'); return false;"
> type="button">
> </div>
> <h1>Apache Derby 10.1.2.1 Release</h1>
> +<div id="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -185,7 +185,8 @@ document.write("Last Published: " + docu
> </li>
> </ul>
> </div>
> -<a name="N10010"></a><a name="Distributions"></a>
> +</div>
> +<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. It is good practice to <a href="#Verifying+releases">verify
> the integrity</a> of the distribution files.</p>
> @@ -214,7 +215,7 @@ document.write("Last Published: " + docu
> <a class="external" href="http://archive.apache.
> org/dist/db/derby/db-derby-10.1.2.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.2.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.2.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="N1009C"></a><a name="Release+Overview"></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.2.1 is a bug fix release providing quality
> improvements for Derby 10.1</p>
> @@ -263,12 +264,12 @@ document.write("Last Published: " + docu
> <li>JSR-169, JDBC 2.1, and JDBC 3.0 support</li>
> </ul>
> </div>
> -<a name="N100EB"></a><a name="Release+Notes"></a>
> +<a name="Release+Notes"></a>
> <h2 class="boxed">Release Notes</h2>
> <div class="section">
> <p>Derby version 10.1.2.1 is a bug fix release based on Apache Derby <a
> href="http://db.apache.org/derby/releases/release-10.1.1.0.html">10.1.1.0.</a>
> In addition to many other bug fixes, this release contains the fix for
> DERBY-662 which is a rare but potentially serious data loss issue on case
> insensitive file systems such as Windows.</p>
> <p>The following reported JIRA issues were fixed in the 10.1.2.1
> release:</p>
> -<a name="N100F7"></a><a name="Bugs"></a>
> +<a name="Bugs"></a>
> <h3 class="boxed">Bugs</h3>
> <ul>
> <li>[<a class="external" href="http://issues.apache.
> org/jira/browse/DERBY-626">DERBY-626</a>] - Booting embedded engine
> requires read permission to derby.jar be granted for all code in the
> stack</li>
> @@ -318,7 +319,7 @@ document.write("Last Published: " + docu
> <li>[<a class="external" href="http://issues.apache.
> org/jira/browse/DERBY-620">DERBY-620</a>] - BUILDING.txt section 3.2(1):
> Instructions for finding user home directory are not reliable</li>
> <li>[<a class="external" href="http://issues.apache.
> org/jira/browse/DERBY-624">DERBY-624</a>] - Running derbynetclientmats
> and derbynetmats requires accessDeclaredMembers permission to be granted
> with sane=true</li>
> </ul>
> -<a name="N10210"></a><a name="Improvements"></a>
> +<a name="Improvements"></a>
> <h3 class="boxed">Improvements</h3>
> <ul>
> <li>[<a class="external" href="http://issues.apache.
> org/jira/browse/DERBY-419">DERBY-419</a>] - Support direct execution of
> derbynet.jar using the -jar option of the VM.</li>
> @@ -326,7 +327,7 @@ document.write("Last Published: " + docu
> <li>[<a class="external" href="http://issues.apache.
> org/jira/browse/DERBY-636">DERBY-636</a>] - Updated localized messages
> for Derby 10.1</li>
> </ul>
> </div>
> -<a name="N10227"></a><a name="Testing"></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>
> @@ -387,7 +388,7 @@ document.write("Last Published: " + docu
> <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="N102AF"></a><a name="Verifying+releases"></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>
>
> Modified: websites/production/db/content/derby/releases/
> release-10.1.3.1.html
> ============================================================
> ==================
> --- websites/production/db/content/derby/releases/release-10.1.3.1.html
> (original)
> +++ websites/production/db/content/derby/releases/release-10.1.3.1.html
> Wed Sep 28 01:33:43 2016
> @@ -3,9 +3,8 @@
> <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-version" content="0.9">
> <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">
> @@ -158,6 +157,7 @@ document.write("Last Published: " + docu
> <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="front-matter">
> <div id="minitoc-area">
> <ul class="minitoc">
> <li>
> @@ -179,13 +179,13 @@ document.write("Last Published: " + docu
> <a href="#">DERBY-283</a>
> </li>
> <li>
> -<a href="#-N103D0">DERBY-526</a>
> +<a href="#-N103C7">DERBY-526</a>
> </li>
> <li>
> -<a href="#-N103FA">DERBY-1327</a>
> +<a href="#-N103F1">DERBY-1327</a>
> </li>
> <li>
> -<a href="#-N10434">DERBY-541</a>
> +<a href="#-N1042B">DERBY-541</a>
> </li>
> </ul>
> </li>
> @@ -197,7 +197,8 @@ document.write("Last Published: " + docu
> </li>
> </ul>
> </div>
> -<a name="N10010"></a><a name="Distributions"></a>
> +</div>
> +<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>
> @@ -230,7 +231,7 @@ document.write("Last Published: " + docu
> <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>
> +<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>
> @@ -281,13 +282,13 @@ document.write("Last Published: " + docu
> <li>JSR-169, JDBC 2.1, and JDBC 3.0 support</li>
> </ul>
> </div>
> -<a name="N10113"></a><a name="Release+Notes"></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>
> +<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>
> @@ -388,7 +389,7 @@ document.write("Last Published: " + docu
> <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>
> +<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>
> @@ -401,7 +402,7 @@ document.write("Last Published: " + docu
> <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>
> +<a class="external" href="http://issues.apache.org/jira/browse/DERBY"></a><a
> name="N1039E"></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>
> @@ -415,7 +416,7 @@ document.write("Last Published: " + docu
> <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>
> +<a name="-N103C7"></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>
> @@ -429,7 +430,7 @@ document.write("Last Published: " + docu
> <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>
> +<a name="-N103F1"></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>
> @@ -445,7 +446,7 @@ document.write("Last Published: " + docu
> <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>
> +<a name="-N1042B"></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>
> @@ -460,7 +461,7 @@ document.write("Last Published: " + docu
> <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>
> +<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>
> @@ -632,7 +633,7 @@ document.write("Last Published: " + docu
> <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>
> +<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>
>
>
>
>