db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r1065675 - in /db/derby/site/trunk: build/site/ build/site/papers/ build/site/papers/DerbyTut/ build/site/skin/images/ src/documentation/content/xdocs/
Date Mon, 31 Jan 2011 16:29:10 GMT
Author: dag
Date: Mon Jan 31 16:29:09 2011
New Revision: 1065675

URL: http://svn.apache.org/viewvc?rev=1065675&view=rev
Log:
Updated FAQ: doc links to 10.7, changed working for SEQUENCE question,
updated question on 10.5 support to be general info on running on Java
release X.


Modified:
    db/derby/site/trunk/build/site/faq.html
    db/derby/site/trunk/build/site/papers/DerbyTut/embedded.png
    db/derby/site/trunk/build/site/papers/DerbyTut/embedded_server.png
    db/derby/site/trunk/build/site/papers/DerbyTut/network_server.png
    db/derby/site/trunk/build/site/papers/alloc-page.png
    db/derby/site/trunk/build/site/papers/container-format.png
    db/derby/site/trunk/build/site/papers/field-header-non-overflow.png
    db/derby/site/trunk/build/site/papers/field-header-overflow.png
    db/derby/site/trunk/build/site/papers/page-format.png
    db/derby/site/trunk/build/site/skin/images/rc-b-l-15-1body-2menu-3menu.png
    db/derby/site/trunk/build/site/skin/images/rc-b-r-15-1body-2menu-3menu.png
    db/derby/site/trunk/build/site/skin/images/rc-b-r-5-1header-2tab-selected-3tab-selected.png
    db/derby/site/trunk/build/site/skin/images/rc-t-l-5-1header-2searchbox-3searchbox.png
    db/derby/site/trunk/build/site/skin/images/rc-t-l-5-1header-2tab-selected-3tab-selected.png
    db/derby/site/trunk/build/site/skin/images/rc-t-l-5-1header-2tab-unselected-3tab-unselected.png
    db/derby/site/trunk/build/site/skin/images/rc-t-r-15-1body-2menu-3menu.png
    db/derby/site/trunk/build/site/skin/images/rc-t-r-5-1header-2searchbox-3searchbox.png
    db/derby/site/trunk/build/site/skin/images/rc-t-r-5-1header-2tab-selected-3tab-selected.png
    db/derby/site/trunk/build/site/skin/images/rc-t-r-5-1header-2tab-unselected-3tab-unselected.png
    db/derby/site/trunk/src/documentation/content/xdocs/faq.xml

Modified: db/derby/site/trunk/build/site/faq.html
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/faq.html?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
--- db/derby/site/trunk/build/site/faq.html (original)
+++ db/derby/site/trunk/build/site/faq.html Mon Jan 31 16:29:09 2011
@@ -251,8 +251,8 @@ document.write("Last Published: " + docu
       </a>
 </li>
 <li>
-<a href="#derby_jdk51">4.6. 
-      Can I use Derby on JDK 5.0?
+<a href="#derby_javax">4.6. 
+      Can I use Derby on Java release X?
       </a>
 </li>
 <li>
@@ -442,10 +442,10 @@ document.write("Last Published: " + docu
             <a class="external" href="http://www.google.com/help/refinesearch.html">domain

            search</a>.  
            For example, the search string below looks for all references
-           to "create table" in the 10.5 documentation set:
+           to "create table" in the 10.7 documentation set:
         </p>
 <pre class="code">
-"create table" site:db.apache.org/derby/docs/10.5
+"create table" site:db.apache.org/derby/docs/10.7
 </pre>
 </div>
 <a name="N10064"></a><a name="developers"></a>
@@ -615,7 +615,7 @@ document.write("Last Published: " + docu
       Starting in 10.1, Derby added support for
       J2ME/CDC/Foundation with JSR169 as the JDBC api. 
       For more information, see the 
-<a href="http://db.apache.org/derby/docs/10.5/ref/rrefjdbcjsr169.html">Reference
+<a href="http://db.apache.org/derby/docs/10.7/ref/rrefjdbcjsr169.html">Reference
       Guide</a>.
       </p>
 </div>
@@ -645,26 +645,30 @@ document.write("Last Published: " + docu
 	sync instead of write sync for log writes.
 	</p>
 </div>
-<a name="N10112"></a><a name="derby_jdk51"></a>
+<a name="N10112"></a><a name="derby_javax"></a>
 <h4 class="faq">4.6. 
-      Can I use Derby on JDK 5.0?
+      Can I use Derby on Java release X?
       </h4>
 <div align="right">
-<a href="#derby_jdk51-menu">^</a>
+<a href="#derby_javax-menu">^</a>
 </div>
 <div style="margin-left: 15px">
 <p>
+        Derby runs on Java 1.4 and newer (Derby 10.2 and earlier also
+        runs with Java 1.3, should you need that).
+      </p>
+<p>
       Two problems with handling Decimal conversion on 
-      JDK 5.0 
+      Java 5.0 and newer:
       (<a class="external" href="http://issues.apache.org/jira/browse/DERBY-74">DERBY-74</a>
       and
       <a class="external" href="http://issues.apache.org/jira/browse/DERBY-83">DERBY-83</a>)
-      were fixed in Derby 10.1.
-      <a class="external" href="http://java.sun.com/j2se/naming_versioning_5_0.html">JDK

-      5.0 is also known as JDK 1.5</a>.
+      were fixed in Derby 10.1. Note: Java 5.0 is also known as 
+      <a class="external" href="http://java.sun.com/j2se/naming_versioning_5_0.html">
+      Java 1.5</a>.
       </p>
 </div>
-<a name="N10126"></a><a name="in_memory"></a>
+<a name="N10129"></a><a name="in_memory"></a>
 <h4 class="faq">4.7. 
       Does Derby have a mode that causes it to run entirely in memory?
       </h4>
@@ -678,7 +682,7 @@ document.write("Last Published: " + docu
           here</a>.
       </p>
 </div>
-<a name="N10132"></a><a name="derby_gui"></a>
+<a name="N10135"></a><a name="derby_gui"></a>
 <h4 class="faq">4.8. 
       Does Derby have a GUI?
       </h4>
@@ -691,13 +695,11 @@ document.write("Last Published: " + docu
       the web site includes a writeup on how to use
       <a href="integrate/SQuirreL_Derby.html">SQuirreL SQL</a>
       with Derby, and the
-      <a class="external" href="http://wiki.apache.org/db-derby/WorkingWithDerby">WorkingWithDerby</a>
-      and
-     <a class="external" href="http://wiki.apache.org/db-derby/UsesOfDerby">UsesOfDerby</a>
-      Wiki pages list GUIs that work with Derby.
+      <a class="external" href="http://wiki.apache.org/db-derby/UsesOfDerby">UsesOfDerby</a>
+      Wiki page list GUIs that work with Derby.
       </p>
 </div>
-<a name="N10146"></a><a name="db_name"></a>
+<a name="N10145"></a><a name="db_name"></a>
 <h4 class="faq">4.9. 
       How do you specify database location?
       </h4>
@@ -709,13 +711,13 @@ document.write("Last Published: " + docu
       You can specify a
       database name using an absolute or relative path.
       Details are in the
-      <a href="http://db.apache.org/derby/docs/10.5/devguide/cdevdvlp34964.html">Developer's
Guide</a>
+      <a href="http://db.apache.org/derby/docs/10.7/devguide/cdevdvlp34964.html">Developer's
Guide</a>
       and helpful tips are on the
       <a class="external" href="http://wiki.apache.org/db-derby/DatabaseNamesRelativeAbsolute">Derby
       Wiki</a>.
       </p>
 </div>
-<a name="N10156"></a><a name="win_service"></a>
+<a name="N10155"></a><a name="win_service"></a>
 <h4 class="faq">4.10. 
       Can you run Derby as a Windows service?
       </h4>
@@ -729,7 +731,7 @@ document.write("Last Published: " + docu
       Windows service.
       </p>
 </div>
-<a name="N10162"></a><a name="derby_version"></a>
+<a name="N10161"></a><a name="derby_version"></a>
 <h4 class="faq">4.11. 
       How do I find out which version of Derby I am using? 
       </h4>
@@ -744,9 +746,9 @@ document.write("Last Published: " + docu
       wiki page</a> for more details. 
       </p>
 </div>
-<a name="N1016E"></a><a name="users_sql"></a>
+<a name="N1016D"></a><a name="users_sql"></a>
 <h3 class="boxed">5. Using Derby: SQL</h3>
-<a name="N10172"></a><a name="null_args"></a>
+<a name="N10171"></a><a name="null_args"></a>
 <h4 class="faq">5.1. 
       Why can't my SQL function/procedure pass a NULL INTEGER?
       </h4>
@@ -762,7 +764,7 @@ document.write("Last Published: " + docu
       derby-user mail list topic.
       </p>
 </div>
-<a name="N1017E"></a><a name="limit"></a>
+<a name="N1017D"></a><a name="limit"></a>
 <h4 class="faq">5.2. 
       Does Derby support a LIMIT command? 
       </h4>
@@ -772,9 +774,9 @@ document.write("Last Published: " + docu
 <div style="margin-left: 15px">
 <p>
           Derby does not support the LIMIT syntax. However, Derby 10.4
-          added the <a href="http://db.apache.org/derby/docs/10.5/ref/rreffuncrownumber.html">ROW_NUMBER
function</a>
-          and Derby 10.5 added the
-          <a href="http://db.apache.org/derby/docs/10.5/ref/rrefsqljoffsetfetch.html">OFFSET
and FETCH clauses</a>.
+          added the <a href="http://db.apache.org/derby/docs/10.7/ref/rreffuncrownumber.html">ROW_NUMBER
function</a>
+          and Derby 10.7 added the
+          <a href="http://db.apache.org/derby/docs/10.7/ref/rrefsqljoffsetfetch.html">OFFSET
and FETCH clauses</a>.
           </p>
 <p>
       Derby also supports limiting the number of rows returned by a query through
@@ -854,7 +856,7 @@ document.write("Last Published: " + docu
       and is currently not supported.
       </p>
 </div>
-<a name="N101FA"></a><a name="schema_exist"></a>
+<a name="N101F9"></a><a name="schema_exist"></a>
 <h4 class="faq">5.3. 
       Why do I get the error 'schema does not exist'?
       </h4>
@@ -886,7 +888,7 @@ document.write("Last Published: " + docu
       to create in a particular schema and no explicit CREATE SCHEMA was issued.
       </p>
 </div>
-<a name="N1020B"></a><a name="debug_lock_timeout"></a>
+<a name="N1020A"></a><a name="debug_lock_timeout"></a>
 <h4 class="faq">5.4. 
       I get a lock timeout error. How do I debug this?
       </h4>
@@ -919,7 +921,7 @@ document.write("Last Published: " + docu
       wiki page.
       </p>
 </div>
-<a name="N1022C"></a><a name="identity"></a>
+<a name="N1022B"></a><a name="identity"></a>
 <h4 class="faq">5.5. 
       Can Derby generate unique identifiers like sequences?
       </h4>
@@ -928,22 +930,20 @@ document.write("Last Published: " + docu
 </div>
 <div style="margin-left: 15px">
 <p>
-      Derby supports generated "identity" columns; examples are in
-      the 
-      <a href="http://db.apache.org/derby/docs/10.5/ref/rrefsqlj37836.html">Reference
Guide</a>.
-      The
- <a href="http://db.apache.org/derby/docs/10.5/ref/rrefidentityvallocal.html#rrefidentityvallocal">IDENTITY_VAL_LOCAL</a>
-       function returns the most recently assigned number.
-   </p>
-<p>
-   Work is underway to add SEQUENCE support to Derby 10.6. See
-   <a class="external" href="https://issues.apache.org/jira/browse/DERBY-712">DERBY-712</a>
-for detailed status.
+        SEQUENCE support was added to Derby in release 10.6.
+      </p>
+<p>
+        Also, Derby supports generated "identity" columns; examples are in
+        the 
+        <a href="http://db.apache.org/derby/docs/10.7/ref/rrefsqlj37836.html">Reference
Guide</a>.
+        The
+        <a href="http://db.apache.org/derby/docs/10.7/ref/rrefidentityvallocal.html#rrefidentityvallocal">IDENTITY_VAL_LOCAL</a>
+        function returns the most recently assigned number.
       </p>
 </div>
-<a name="N10243"></a><a name="users_client"></a>
+<a name="N1023E"></a><a name="users_client"></a>
 <h3 class="boxed">6. Using Derby: Client Programming</h3>
-<a name="N10247"></a><a name="clientserv"></a>
+<a name="N10242"></a><a name="clientserv"></a>
 <h4 class="faq">6.1. 
       Can you use Derby for client-server applications?
       </h4>
@@ -954,7 +954,7 @@ for detailed status.
 <p>
       Yes, you can use derby for client-server applications.
       Starting in 10.1 Derby includes the
-      <a href="http://db.apache.org/derby/docs/10.5/adminguide/cadminappsclient.html">Derby
Network Client jdbc driver</a>.
+      <a href="http://db.apache.org/derby/docs/10.7/adminguide/cadminappsclient.html">Derby
Network Client jdbc driver</a>.
       The <a class="external" href="http://wiki.apache.org/db-derby/UsesOfDerby">UsesOfDerby</a>
       Wiki pages lists additional drivers, including
       <a class="external" href="http://c-jdbc.objectweb.org/">C-JDBC</a>,
@@ -964,7 +964,7 @@ for detailed status.
       <a class="external" href="http://sequoia.continuent.org/HomePage">Sequoia</a>.
       </p>
 </div>
-<a name="N10263"></a><a name="netclient"></a>
+<a name="N1025E"></a><a name="netclient"></a>
 <h4 class="faq">6.2. 
       Does Derby include a client-server ("network") jdbc driver?
       </h4>
@@ -976,11 +976,11 @@ for detailed status.
       Yes, Apache Derby has a JDBC driver
       that works with the Derby Network Server.
       It is called the
-      <a href="http://db.apache.org/derby/docs/10.5/adminguide/cadminappsclient.html">Derby
Network Client</a>
+      <a href="http://db.apache.org/derby/docs/10.7/adminguide/cadminappsclient.html">Derby
Network Client</a>
       and it became available starting with Derby 10.1.
       </p>
 </div>
-<a name="N1026F"></a><a name="db2_jcc_errors"></a>
+<a name="N1026A"></a><a name="db2_jcc_errors"></a>
 <h4 class="faq">6.3. 
       How can I get the message text for an error using the DB2 JDBC
       Universal Driver?
@@ -998,7 +998,7 @@ for detailed status.
       mail list topic.
       </p>
 </div>
-<a name="N1027E"></a><a name="derby_xa"></a>
+<a name="N10279"></a><a name="derby_xa"></a>
 <h4 class="faq">6.4. 
       Can you execute a query that spans two Derby databases 
       across different JVMs?
@@ -1011,10 +1011,10 @@ for detailed status.
       XA support using Network Server allows you to do this and the
       Derby Network Client, new in 10.1, supports this functionality.
       An example of establishing an XA connection is in the 
-      <a href="http://db.apache.org/derby/docs/10.5/adminguide/cadminapps811478.html">Admin
and Server Guide</a>.
+      <a href="http://db.apache.org/derby/docs/10.7/adminguide/cadminapps811478.html">Admin
and Server Guide</a>.
       </p>
 </div>
-<a name="N1028A"></a><a name="derby_faster"></a>
+<a name="N10285"></a><a name="derby_faster"></a>
 <h4 class="faq">6.5. 
       Are there any tips to make Derby go faster?
       </h4>
@@ -1031,8 +1031,8 @@ for detailed status.
          Use PreparedStatement with dynamic markers('?') instead of Statement. 
          This will be faster since the statement does not need to be 
          recompiled every time. See the
-<a href="http://db.apache.org/derby/docs/10.5/tuning/ctunperf18705.html">Use prepared
statements with substitution parameters</a> and
-<a href="http://db.apache.org/derby/docs/10.5/tuning/ctundepth29804.html#ctundepth29804">Avoid
compiling SQL statements</a> sections of the Tuning Derby guide.
+<a href="http://db.apache.org/derby/docs/10.7/tuning/ctunperf18705.html">Use prepared
statements with substitution parameters</a> and
+<a href="http://db.apache.org/derby/docs/10.7/tuning/ctundepth29804.html#ctundepth29804">Avoid
compiling SQL statements</a> sections of the Tuning Derby guide.
       </li>
       
 <li> 
@@ -1049,7 +1049,7 @@ for detailed status.
       
 </ol>
 </div>
-<a name="N102A3"></a><a name="jdbc_lob"></a>
+<a name="N1029E"></a><a name="jdbc_lob"></a>
 <h4 class="faq">6.6. 
       Where is an example that shows how to insert a CLOB?
       </h4>
@@ -1059,7 +1059,7 @@ for detailed status.
 <div style="margin-left: 15px">
 <p>
       The <em>Reference Guide</em> includes an 
-      <a href="http://db.apache.org/derby/docs/10.5/ref/rrefclob.html">example
+      <a href="http://db.apache.org/derby/docs/10.7/ref/rrefclob.html">example
       that shows how to insert a CLOB</a>.
       Also
       <a class="external" href="http://mail-archives.apache.org/mod_mbox/db-derby-user/200509.mbox/%3c1126857139.2375.75.camel@pc977.sb.statsbiblioteket.dk%3e">this

@@ -1067,7 +1067,7 @@ for detailed status.
       provides another example.
       </p>
 </div>
-<a name="N102B6"></a><a name="jdbc4"></a>
+<a name="N102B1"></a><a name="jdbc4"></a>
 <h4 class="faq">6.7. 
       Does Derby support JDBC 4.0?
       </h4>

Modified: db/derby/site/trunk/build/site/papers/DerbyTut/embedded.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/embedded.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/papers/DerbyTut/embedded_server.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/embedded_server.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/papers/DerbyTut/network_server.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/DerbyTut/network_server.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/papers/alloc-page.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/alloc-page.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/papers/container-format.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/container-format.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/papers/field-header-non-overflow.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/field-header-non-overflow.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/papers/field-header-overflow.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/field-header-overflow.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/papers/page-format.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/papers/page-format.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/skin/images/rc-b-l-15-1body-2menu-3menu.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/skin/images/rc-b-l-15-1body-2menu-3menu.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/skin/images/rc-b-r-15-1body-2menu-3menu.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/skin/images/rc-b-r-15-1body-2menu-3menu.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/skin/images/rc-b-r-5-1header-2tab-selected-3tab-selected.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/skin/images/rc-b-r-5-1header-2tab-selected-3tab-selected.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/skin/images/rc-t-l-5-1header-2searchbox-3searchbox.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/skin/images/rc-t-l-5-1header-2searchbox-3searchbox.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/skin/images/rc-t-l-5-1header-2tab-selected-3tab-selected.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/skin/images/rc-t-l-5-1header-2tab-selected-3tab-selected.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/skin/images/rc-t-l-5-1header-2tab-unselected-3tab-unselected.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/skin/images/rc-t-l-5-1header-2tab-unselected-3tab-unselected.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/skin/images/rc-t-r-15-1body-2menu-3menu.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/skin/images/rc-t-r-15-1body-2menu-3menu.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/skin/images/rc-t-r-5-1header-2searchbox-3searchbox.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/skin/images/rc-t-r-5-1header-2searchbox-3searchbox.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/skin/images/rc-t-r-5-1header-2tab-selected-3tab-selected.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/skin/images/rc-t-r-5-1header-2tab-selected-3tab-selected.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/build/site/skin/images/rc-t-r-5-1header-2tab-unselected-3tab-unselected.png
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/build/site/skin/images/rc-t-r-5-1header-2tab-unselected-3tab-unselected.png?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
Binary files - no diff available.

Modified: db/derby/site/trunk/src/documentation/content/xdocs/faq.xml
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/src/documentation/content/xdocs/faq.xml?rev=1065675&r1=1065674&r2=1065675&view=diff
==============================================================================
--- db/derby/site/trunk/src/documentation/content/xdocs/faq.xml (original)
+++ db/derby/site/trunk/src/documentation/content/xdocs/faq.xml Mon Jan 31 16:29:09 2011
@@ -93,10 +93,10 @@
             <a href="http://www.google.com/help/refinesearch.html">domain 
            search</a>.  
            For example, the search string below looks for all references
-           to "create table" in the 10.5 documentation set:
+           to "create table" in the 10.7 documentation set:
         </p>
 <source>
-"create table" site:db.apache.org/derby/docs/10.5
+"create table" site:db.apache.org/derby/docs/10.7
 </source>
 
       </answer>
@@ -263,7 +263,7 @@
       Starting in 10.1, Derby added support for
       J2ME/CDC/Foundation with JSR169 as the JDBC api. 
       For more information, see the 
-<a href="http://db.apache.org/derby/docs/10.5/ref/rrefjdbcjsr169.html">Reference
+<a href="http://db.apache.org/derby/docs/10.7/ref/rrefjdbcjsr169.html">Reference
       Guide</a>.
       </p>
       </answer>
@@ -292,20 +292,24 @@
 	</p>
       </answer>
     </faq>
-    <faq id="derby_jdk51">
+    <faq id="derby_javax">
       <question>
-      Can I use Derby on JDK 5.0?
+      Can I use Derby on Java release X?
       </question>
       <answer>
       <p>
+        Derby runs on Java 1.4 and newer (Derby 10.2 and earlier also
+        runs with Java 1.3, should you need that).
+      </p>
+      <p>
       Two problems with handling Decimal conversion on 
-      JDK 5.0 
+      Java 5.0 and newer:
       (<a href="http://issues.apache.org/jira/browse/DERBY-74">DERBY-74</a>
       and
       <a href="http://issues.apache.org/jira/browse/DERBY-83">DERBY-83</a>)
-      were fixed in Derby 10.1.
-      <a href="http://java.sun.com/j2se/naming_versioning_5_0.html">JDK 
-      5.0 is also known as JDK 1.5</a>.
+      were fixed in Derby 10.1. Note: Java 5.0 is also known as 
+      <a href="http://java.sun.com/j2se/naming_versioning_5_0.html">
+      Java 1.5</a>.
       </p>
       </answer>
     </faq>
@@ -333,10 +337,8 @@
       the web site includes a writeup on how to use
       <a href="integrate/SQuirreL_Derby.html">SQuirreL SQL</a>
       with Derby, and the
-      <a href="http://wiki.apache.org/db-derby/WorkingWithDerby">WorkingWithDerby</a>
-      and
-     <a href="http://wiki.apache.org/db-derby/UsesOfDerby">UsesOfDerby</a>
-      Wiki pages list GUIs that work with Derby.
+      <a href="http://wiki.apache.org/db-derby/UsesOfDerby">UsesOfDerby</a>
+      Wiki page list GUIs that work with Derby.
       </p>
       </answer>
     </faq>
@@ -349,7 +351,7 @@
       You can specify a
       database name using an absolute or relative path.
       Details are in the
-      <a href="http://db.apache.org/derby/docs/10.5/devguide/cdevdvlp34964.html">Developer's
Guide</a>
+      <a href="http://db.apache.org/derby/docs/10.7/devguide/cdevdvlp34964.html">Developer's
Guide</a>
       and helpful tips are on the
       <a href="http://wiki.apache.org/db-derby/DatabaseNamesRelativeAbsolute">Derby
       Wiki</a>.
@@ -409,9 +411,9 @@
       <answer>
       <p>
           Derby does not support the LIMIT syntax. However, Derby 10.4
-          added the <a href="http://db.apache.org/derby/docs/10.5/ref/rreffuncrownumber.html">ROW_NUMBER
function</a>
-          and Derby 10.5 added the
-          <a href="http://db.apache.org/derby/docs/10.5/ref/rrefsqljoffsetfetch.html">OFFSET
and FETCH clauses</a>.
+          added the <a href="http://db.apache.org/derby/docs/10.7/ref/rreffuncrownumber.html">ROW_NUMBER
function</a>
+          and Derby 10.7 added the
+          <a href="http://db.apache.org/derby/docs/10.7/ref/rrefsqljoffsetfetch.html">OFFSET
and FETCH clauses</a>.
           </p><p>
       Derby also supports limiting the number of rows returned by a query through
       <a href="http://mail-archives.apache.org/mod_mbox/db-derby-dev/200411.mbox/%3c41A95632.3010301@debrunners.com%3e">JDBC</a>.
For example, to fetch the first 5 rows of a large table:
@@ -541,17 +543,15 @@
       </question>
       <answer>
       <p>
-      Derby supports generated "identity" columns; examples are in
-      the 
-      <a href="http://db.apache.org/derby/docs/10.5/ref/rrefsqlj37836.html">Reference
Guide</a>.
-      The
- <a href="http://db.apache.org/derby/docs/10.5/ref/rrefidentityvallocal.html#rrefidentityvallocal">IDENTITY_VAL_LOCAL</a>
-       function returns the most recently assigned number.
-   </p>
-   <p>
-   Work is underway to add SEQUENCE support to Derby 10.6. See
-   <a href="https://issues.apache.org/jira/browse/DERBY-712">DERBY-712</a>
-for detailed status.
+        SEQUENCE support was added to Derby in release 10.6.
+      </p>
+      <p>
+        Also, Derby supports generated "identity" columns; examples are in
+        the 
+        <a href="http://db.apache.org/derby/docs/10.7/ref/rrefsqlj37836.html">Reference
Guide</a>.
+        The
+        <a href="http://db.apache.org/derby/docs/10.7/ref/rrefidentityvallocal.html#rrefidentityvallocal">IDENTITY_VAL_LOCAL</a>
+        function returns the most recently assigned number.
       </p>
       </answer>
     </faq>
@@ -566,7 +566,7 @@ for detailed status.
       <p>
       Yes, you can use derby for client-server applications.
       Starting in 10.1 Derby includes the
-      <a href="http://db.apache.org/derby/docs/10.5/adminguide/cadminappsclient.html">Derby
Network Client jdbc driver</a>.
+      <a href="http://db.apache.org/derby/docs/10.7/adminguide/cadminappsclient.html">Derby
Network Client jdbc driver</a>.
       The <a href="http://wiki.apache.org/db-derby/UsesOfDerby">UsesOfDerby</a>
       Wiki pages lists additional drivers, including
       <a href="http://c-jdbc.objectweb.org/">C-JDBC</a>,
@@ -586,7 +586,7 @@ for detailed status.
       Yes, Apache Derby has a JDBC driver
       that works with the Derby Network Server.
       It is called the
-      <a href="http://db.apache.org/derby/docs/10.5/adminguide/cadminappsclient.html">Derby
Network Client</a>
+      <a href="http://db.apache.org/derby/docs/10.7/adminguide/cadminappsclient.html">Derby
Network Client</a>
       and it became available starting with Derby 10.1.
       </p>
       </answer>
@@ -617,7 +617,7 @@ for detailed status.
       XA support using Network Server allows you to do this and the
       Derby Network Client, new in 10.1, supports this functionality.
       An example of establishing an XA connection is in the 
-      <a href="http://db.apache.org/derby/docs/10.5/adminguide/cadminapps811478.html">Admin
and Server Guide</a>.
+      <a href="http://db.apache.org/derby/docs/10.7/adminguide/cadminapps811478.html">Admin
and Server Guide</a>.
       </p>
       </answer>
     </faq>
@@ -634,8 +634,8 @@ for detailed status.
          Use PreparedStatement with dynamic markers('?') instead of Statement. 
          This will be faster since the statement does not need to be 
          recompiled every time. See the
-<a href="http://db.apache.org/derby/docs/10.5/tuning/ctunperf18705.html">Use prepared
statements with substitution parameters</a> and
-<a href="http://db.apache.org/derby/docs/10.5/tuning/ctundepth29804.html#ctundepth29804">Avoid
compiling SQL statements</a> sections of the Tuning Derby guide.
+<a href="http://db.apache.org/derby/docs/10.7/tuning/ctunperf18705.html">Use prepared
statements with substitution parameters</a> and
+<a href="http://db.apache.org/derby/docs/10.7/tuning/ctundepth29804.html#ctundepth29804">Avoid
compiling SQL statements</a> sections of the Tuning Derby guide.
       </li>
       <li> 
         Avoid inserts in autocommit mode if possible. 
@@ -658,7 +658,7 @@ for detailed status.
       <answer>
       <p>
       The <em>Reference Guide</em> includes an 
-      <a href="http://db.apache.org/derby/docs/10.5/ref/rrefclob.html">example
+      <a href="http://db.apache.org/derby/docs/10.7/ref/rrefclob.html">example
       that shows how to insert a CLOB</a>.
       Also
       <a href="http://mail-archives.apache.org/mod_mbox/db-derby-user/200509.mbox/%3c1126857139.2375.75.camel@pc977.sb.statsbiblioteket.dk%3e">this




Mime
View raw message