db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bpendle...@apache.org
Subject svn commit: r832277 - in /db/derby/site/trunk: build/site/faq.html forrest.properties src/documentation/content/xdocs/faq.xml
Date Tue, 03 Nov 2009 02:39:29 GMT
Author: bpendleton
Date: Tue Nov  3 02:39:28 2009
New Revision: 832277

URL: http://svn.apache.org/viewvc?rev=832277&view=rev
Log:
DERBY-4236: Update FAQ for Derby 10.5

This change makes several modifications to the Derby FAQ to bring it up to
date with Derby 10.5. The most significant changes were regarding the
in-memory storage engine support and the FETCH/OFFSET support.

The change also changes a number of references to version 10.2 in the FAQ
to refer to the corresponding 10.5 manual pages.

Modified:
    db/derby/site/trunk/build/site/faq.html
    db/derby/site/trunk/forrest.properties
    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=832277&r1=832276&r2=832277&view=diff
==============================================================================
--- db/derby/site/trunk/build/site/faq.html (original)
+++ db/derby/site/trunk/build/site/faq.html Tue Nov  3 02:39:28 2009
@@ -442,10 +442,10 @@
             <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.2 documentation set:
+           to "create table" in the 10.5 documentation set:
         </p>
 <pre class="code">
-"create table" site:db.apache.org/derby/docs/10.2
+"create table" site:db.apache.org/derby/docs/10.5
 </pre>
 </div>
 <a name="N10064"></a><a name="developers"></a>
@@ -615,7 +615,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.2/ref/rrefjdbcjsr169.html">Reference
+<a href="http://db.apache.org/derby/docs/10.5/ref/rrefjdbcjsr169.html">Reference
       Guide</a>.
       </p>
 </div>
@@ -673,15 +673,12 @@
 </div>
 <div style="margin-left: 15px">
 <p>
-      No, Derby does not support an in-memory mode, but a feature request
-      has been logged in JIRA as <a class="external" href="http://issues.apache.org/jira/browse/DERBY-646">DERBY-646</a>.
-      When this FAQ entry was written 
-      <a href="derby_mail.html">derby-dev@db.apache.org</a> list activity
-      indicated that some work had been done but that the feature is 
-      not actively being worked on.  Check that mail list for current status.
+      Yes, Derby now supports such a configuration! For more information,
+      start <a class="external" href="http://wiki.apache.org/db-derby/InMemoryBackEndPrimer">
+          here</a>.
       </p>
 </div>
-<a name="N10136"></a><a name="derby_gui"></a>
+<a name="N10132"></a><a name="derby_gui"></a>
 <h4 class="faq">4.8. 
       Does Derby have a GUI?
       </h4>
@@ -700,7 +697,7 @@
       Wiki pages list GUIs that work with Derby.
       </p>
 </div>
-<a name="N1014A"></a><a name="db_name"></a>
+<a name="N10146"></a><a name="db_name"></a>
 <h4 class="faq">4.9. 
       How do you specify database location?
       </h4>
@@ -712,13 +709,13 @@
       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.2/devguide/cdevdvlp34964.html">Developer's
Guide</a>
+      <a href="http://db.apache.org/derby/docs/10.5/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="N1015A"></a><a name="win_service"></a>
+<a name="N10156"></a><a name="win_service"></a>
 <h4 class="faq">4.10. 
       Can you run Derby as a Windows service?
       </h4>
@@ -732,7 +729,7 @@
       Windows service.
       </p>
 </div>
-<a name="N10166"></a><a name="derby_version"></a>
+<a name="N10162"></a><a name="derby_version"></a>
 <h4 class="faq">4.11. 
       How do I find out which version of Derby I am using? 
       </h4>
@@ -747,9 +744,9 @@
       wiki page</a> for more details. 
       </p>
 </div>
-<a name="N10172"></a><a name="users_sql"></a>
+<a name="N1016E"></a><a name="users_sql"></a>
 <h3 class="boxed">5. Using Derby: SQL</h3>
-<a name="N10176"></a><a name="null_args"></a>
+<a name="N10172"></a><a name="null_args"></a>
 <h4 class="faq">5.1. 
       Why can't my SQL function/procedure pass a NULL INTEGER?
       </h4>
@@ -765,7 +762,7 @@
       derby-user mail list topic.
       </p>
 </div>
-<a name="N10182"></a><a name="limit"></a>
+<a name="N1017E"></a><a name="limit"></a>
 <h4 class="faq">5.2. 
       Does Derby support a LIMIT command? 
       </h4>
@@ -774,7 +771,13 @@
 </div>
 <div style="margin-left: 15px">
 <p>
-      Derby supports limiting the number of rows returned by a query through
+          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>.
+          </p>
+<p>
+      Derby also supports limiting the number of rows returned by a query through
       <a class="external" 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:
       </p>
 <p>
@@ -851,7 +854,7 @@
       and is currently not supported.
       </p>
 </div>
-<a name="N101F4"></a><a name="schema_exist"></a>
+<a name="N101FA"></a><a name="schema_exist"></a>
 <h4 class="faq">5.3. 
       Why do I get the error 'schema does not exist'?
       </h4>
@@ -883,7 +886,7 @@
       to create in a particular schema and no explicit CREATE SCHEMA was issued.
       </p>
 </div>
-<a name="N10205"></a><a name="debug_lock_timeout"></a>
+<a name="N1020B"></a><a name="debug_lock_timeout"></a>
 <h4 class="faq">5.4. 
       I get a lock timeout error. How do I debug this?
       </h4>
@@ -916,7 +919,7 @@
       wiki page.
       </p>
 </div>
-<a name="N10226"></a><a name="identity"></a>
+<a name="N1022C"></a><a name="identity"></a>
 <h4 class="faq">5.5. 
       Can Derby generate unique identifiers like sequences?
       </h4>
@@ -927,15 +930,20 @@
 <p>
       Derby supports generated "identity" columns; examples are in
       the 
-      <a href="http://db.apache.org/derby/docs/10.2/ref/rrefsqlj37836.html">Reference
Guide</a>.
+      <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.2/ref/rrefidentityvallocal.html#rrefidentityvallocal">IDENTITY_VAL_LOCAL</a>
+ <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.
       </p>
 </div>
-<a name="N10236"></a><a name="users_client"></a>
+<a name="N10243"></a><a name="users_client"></a>
 <h3 class="boxed">6. Using Derby: Client Programming</h3>
-<a name="N1023A"></a><a name="clientserv"></a>
+<a name="N10247"></a><a name="clientserv"></a>
 <h4 class="faq">6.1. 
       Can you use Derby for client-server applications?
       </h4>
@@ -946,7 +954,7 @@
 <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.2/adminguide/cadminappsclient.html">Derby
Network Client jdbc driver</a>.
+      <a href="http://db.apache.org/derby/docs/10.5/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>,
@@ -956,7 +964,7 @@
       <a class="external" href="http://sequoia.continuent.org/HomePage">Sequoia</a>.
       </p>
 </div>
-<a name="N10256"></a><a name="netclient"></a>
+<a name="N10263"></a><a name="netclient"></a>
 <h4 class="faq">6.2. 
       Does Derby include a client-server ("network") jdbc driver?
       </h4>
@@ -968,11 +976,11 @@
       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.2/adminguide/cadminappsclient.html">Derby
Network Client</a>
+      <a href="http://db.apache.org/derby/docs/10.5/adminguide/cadminappsclient.html">Derby
Network Client</a>
       and it became available starting with Derby 10.1.
       </p>
 </div>
-<a name="N10262"></a><a name="db2_jcc_errors"></a>
+<a name="N1026F"></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?
@@ -990,7 +998,7 @@
       mail list topic.
       </p>
 </div>
-<a name="N10271"></a><a name="derby_xa"></a>
+<a name="N1027E"></a><a name="derby_xa"></a>
 <h4 class="faq">6.4. 
       Can you execute a query that spans two Derby databases 
       across different JVMs?
@@ -1003,10 +1011,10 @@
       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.2/adminguide/cadminapps811478.html">Admin
and Server Guide</a>.
+      <a href="http://db.apache.org/derby/docs/10.5/adminguide/cadminapps811478.html">Admin
and Server Guide</a>.
       </p>
 </div>
-<a name="N1027D"></a><a name="derby_faster"></a>
+<a name="N1028A"></a><a name="derby_faster"></a>
 <h4 class="faq">6.5. 
       Are there any tips to make Derby go faster?
       </h4>
@@ -1023,8 +1031,8 @@
          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.2/tuning/ctunperf18705.html">Use prepared
statements with substitution parameters</a> and
-<a href="http://db.apache.org/derby/docs/10.2/tuning/ctundepth29804.html#ctundepth29804">Avoid
compiling SQL statements</a> sections of the Tuning Derby guide.
+<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.
       </li>
       
 <li> 
@@ -1041,7 +1049,7 @@
       
 </ol>
 </div>
-<a name="N10296"></a><a name="jdbc_lob"></a>
+<a name="N102A3"></a><a name="jdbc_lob"></a>
 <h4 class="faq">6.6. 
       Where is an example that shows how to insert a CLOB?
       </h4>
@@ -1051,7 +1059,7 @@
 <div style="margin-left: 15px">
 <p>
       The <em>Reference Guide</em> includes an 
-      <a href="http://db.apache.org/derby/docs/10.2/ref/rrefclob.html">example
+      <a href="http://db.apache.org/derby/docs/10.5/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

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

Modified: db/derby/site/trunk/forrest.properties
URL: http://svn.apache.org/viewvc/db/derby/site/trunk/forrest.properties?rev=832277&r1=832276&r2=832277&view=diff
==============================================================================
--- db/derby/site/trunk/forrest.properties (original)
+++ db/derby/site/trunk/forrest.properties Tue Nov  3 02:39:28 2009
@@ -73,8 +73,8 @@
 #forrest.validate=true
 #forrest.validate.xdocs=${forrest.validate}
 #forrest.validate.skinconf=${forrest.validate}
-#forrest.validate.sitemap=${forrest.validate}
-#forrest.validate.stylesheets=${forrest.validate}
+forrest.validate.sitemap=false
+forrest.validate.stylesheets=false
 #forrest.validate.skins=${forrest.validate}
 #forrest.validate.skins.stylesheets=${forrest.validate.skins}
 

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=832277&r1=832276&r2=832277&view=diff
==============================================================================
--- db/derby/site/trunk/src/documentation/content/xdocs/faq.xml (original)
+++ db/derby/site/trunk/src/documentation/content/xdocs/faq.xml Tue Nov  3 02:39:28 2009
@@ -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.2 documentation set:
+           to "create table" in the 10.5 documentation set:
         </p>
 <source>
-"create table" site:db.apache.org/derby/docs/10.2
+"create table" site:db.apache.org/derby/docs/10.5
 </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.2/ref/rrefjdbcjsr169.html">Reference
+<a href="http://db.apache.org/derby/docs/10.5/ref/rrefjdbcjsr169.html">Reference
       Guide</a>.
       </p>
       </answer>
@@ -316,12 +316,9 @@
       </question>
       <answer>
       <p>
-      No, Derby does not support an in-memory mode, but a feature request
-      has been logged in JIRA as <a href="http://issues.apache.org/jira/browse/DERBY-646">DERBY-646</a>.
-      When this FAQ entry was written 
-      <a href="derby_mail.html">derby-dev@db.apache.org</a> list activity
-      indicated that some work had been done but that the feature is 
-      not actively being worked on.  Check that mail list for current status.
+      Yes, Derby now supports such a configuration! For more information,
+      start <a href="http://wiki.apache.org/db-derby/InMemoryBackEndPrimer">
+          here</a>.
       </p>
       </answer>
     </faq>
@@ -352,7 +349,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.2/devguide/cdevdvlp34964.html">Developer's
Guide</a>
+      <a href="http://db.apache.org/derby/docs/10.5/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>.
@@ -411,7 +408,12 @@
       </question>
       <answer>
       <p>
-      Derby supports limiting the number of rows returned by a query through
+          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>.
+          </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:
       </p>
       <!-- Using <code> and <br/> tags etc. as a workaround for including

@@ -541,10 +543,15 @@
       <p>
       Derby supports generated "identity" columns; examples are in
       the 
-      <a href="http://db.apache.org/derby/docs/10.2/ref/rrefsqlj37836.html">Reference
Guide</a>.
+      <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.2/ref/rrefidentityvallocal.html#rrefidentityvallocal">IDENTITY_VAL_LOCAL</a>
+ <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.
       </p>
       </answer>
     </faq>
@@ -559,7 +566,7 @@
       <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.2/adminguide/cadminappsclient.html">Derby
Network Client jdbc driver</a>.
+      <a href="http://db.apache.org/derby/docs/10.5/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>,
@@ -579,7 +586,7 @@
       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.2/adminguide/cadminappsclient.html">Derby
Network Client</a>
+      <a href="http://db.apache.org/derby/docs/10.5/adminguide/cadminappsclient.html">Derby
Network Client</a>
       and it became available starting with Derby 10.1.
       </p>
       </answer>
@@ -610,7 +617,7 @@
       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.2/adminguide/cadminapps811478.html">Admin
and Server Guide</a>.
+      <a href="http://db.apache.org/derby/docs/10.5/adminguide/cadminapps811478.html">Admin
and Server Guide</a>.
       </p>
       </answer>
     </faq>
@@ -627,8 +634,8 @@
          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.2/tuning/ctunperf18705.html">Use prepared
statements with substitution parameters</a> and
-<a href="http://db.apache.org/derby/docs/10.2/tuning/ctundepth29804.html#ctundepth29804">Avoid
compiling SQL statements</a> sections of the Tuning Derby guide.
+<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.
       </li>
       <li> 
         Avoid inserts in autocommit mode if possible. 
@@ -651,7 +658,7 @@
       <answer>
       <p>
       The <em>Reference Guide</em> includes an 
-      <a href="http://db.apache.org/derby/docs/10.2/ref/rrefclob.html">example
+      <a href="http://db.apache.org/derby/docs/10.5/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