db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j..@apache.org
Subject svn commit: r290319 - in /db/derby/site/trunk: build/site/faq.html src/documentation/content/xdocs/faq.xml
Date Tue, 20 Sep 2005 00:17:37 GMT
Author: jta
Date: Mon Sep 19 17:17:34 2005
New Revision: 290319

URL: http://svn.apache.org/viewcvs?rev=290319&view=rev
Log:
Added FAQs for inserting a CLOB and generating unique id's.

Modified:
    db/derby/site/trunk/build/site/faq.html
    db/derby/site/trunk/src/documentation/content/xdocs/faq.xml

Modified: db/derby/site/trunk/build/site/faq.html
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/build/site/faq.html?rev=290319&r1=290318&r2=290319&view=diff
==============================================================================
--- db/derby/site/trunk/build/site/faq.html (original)
+++ db/derby/site/trunk/build/site/faq.html Mon Sep 19 17:17:34 2005
@@ -103,136 +103,156 @@
 <a href="#Questions">Questions</a>
 <ul class="minitoc">
 <li>
-<a href="#developers">1. Developing Derby</a>
+<a href="#general">1. General</a>
 <ul class="minitoc">
 <li>
-<a href="#derby_source">1.1. 
+<a href="#faq_add">1.1. 
+        How can I add a new entry to the Derby FAQ?
+      </a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#developers">2. Developing Derby</a>
+<ul class="minitoc">
+<li>
+<a href="#derby_source">2.1. 
         Where is the Derby source code?
       </a>
 </li>
 <li>
-<a href="#derby_internals">1.2. 
+<a href="#derby_internals">2.2. 
         Where can I read about Derby internals?
       </a>
 </li>
 <li>
-<a href="#derby_issues">1.3. 
+<a href="#derby_issues">2.3. 
         Where are Apache Derby bugs logged?
       </a>
 </li>
 <li>
-<a href="#derby_update">1.4. 
+<a href="#derby_update">2.4. 
         Who can create a new Apache Derby issue?
       </a>
 </li>
 <li>
-<a href="#derby_eclipse">1.5. 
+<a href="#derby_eclipse">2.5. 
         How do you build Derby using Eclipse?
       </a>
 </li>
 </ul>
 </li>
 <li>
-<a href="#users_getstart">2. Using Derby: Getting Started</a>
+<a href="#users_getstart">3. Using Derby: Getting Started</a>
 <ul class="minitoc">
 <li>
-<a href="#derby_ask">2.1. 
+<a href="#derby_ask">3.1. 
         Where can I ask questions about how to use Derby?
       </a>
 </li>
 <li>
-<a href="#derby_jar">2.2. 
+<a href="#derby_jar">3.2. 
         Where can I download the Derby jar files?
       </a>
 </li>
 <li>
-<a href="#derby_alpha">2.3. 
+<a href="#derby_alpha">3.3. 
       What are Derby alpha snaphots and should I use them?
       </a>
 </li>
 <li>
-<a href="#where_are_docs">2.4. 
+<a href="#where_are_docs">3.4. 
       Where can I find the Derby documentation?
       </a>
 </li>
 <li>
-<a href="#pda">2.5. 
+<a href="#pda">3.5. 
       Can you run Derby on PDAs?
       </a>
 </li>
 <li>
-<a href="#createdb_OS_X">2.6. 
+<a href="#createdb_OS_X">3.6. 
         Why can't I create a new database or modify an existing database 
 	on Mac OS X?
       </a>
 </li>
 <li>
-<a href="#derby_jdk51">2.7. 
+<a href="#derby_jdk51">3.7. 
       Can I use Derby on JDK 5.0?
       </a>
 </li>
 <li>
-<a href="#in_memory">2.8. 
+<a href="#in_memory">3.8. 
       Does Derby have a mode that causes it to run entirely in memory?
       </a>
 </li>
 </ul>
 </li>
 <li>
-<a href="#users_sql">3. Using Derby: SQL</a>
+<a href="#users_sql">4. Using Derby: SQL</a>
 <ul class="minitoc">
 <li>
-<a href="#null_args">3.1. 
+<a href="#null_args">4.1. 
       Why can't my SQL function/procedure pass a NULL INTEGER?
       </a>
 </li>
 <li>
-<a href="#limit">3.2. 
+<a href="#limit">4.2. 
       Does Derby support a LIMIT command? 
       </a>
 </li>
 <li>
-<a href="#schema_exist">3.3. 
+<a href="#schema_exist">4.3. 
       Why do I get the error 'schema does not exist'?
       </a>
 </li>
 <li>
-<a href="#debug_lock_timeout">3.4. 
+<a href="#debug_lock_timeout">4.4. 
       I get a lock timeout error. How do I debug this?
       </a>
 </li>
+<li>
+<a href="#identity">4.5. 
+      Can Derby generate unique identifiers like sequences?
+      </a>
+</li>
 </ul>
 </li>
 <li>
-<a href="#users_client">4. Using Derby: Client Programming</a>
+<a href="#users_client">5. Using Derby: Client Programming</a>
 <ul class="minitoc">
 <li>
-<a href="#clientserv">4.1. 
+<a href="#clientserv">5.1. 
       Can you use Derby for client-server applications?
       </a>
 </li>
 <li>
-<a href="#netclient">4.2. 
+<a href="#netclient">5.2. 
       Does Derby include a client-server ("network") jdbc driver?
       </a>
 </li>
 <li>
-<a href="#db2_jcc_errors">4.3. 
+<a href="#db2_jcc_errors">5.3. 
       How can I get the message text for an error using the DB2 JDBC
       Universal Driver?
       </a>
 </li>
 <li>
-<a href="#derby_xa">4.4. 
+<a href="#derby_xa">5.4. 
       Can you execute a query that spans two Derby databases 
       across different JVMs?
       </a>
 </li>
 <li>
-<a href="#derby_faster">4.5. 
+<a href="#derby_faster">5.5. 
       Are there any tips to make Derby go faster?
       </a>
 </li>
+<li>
+<a href="#jdbc_lob">5.6. 
+      Where is an example that shows how to insert a CLOB?
+      </a>
+</li>
 </ul>
 </li>
 </ul>
@@ -242,10 +262,28 @@
 <a name="N10008"></a><a name="Questions"></a>
 <h2 class="boxed">Questions</h2>
 <div class="section">
-<a name="N1000C"></a><a name="developers"></a>
-<h3 class="boxed">1. Developing Derby</h3>
-<a name="N10010"></a><a name="derby_source"></a>
+<a name="N1000C"></a><a name="general"></a>
+<h3 class="boxed">1. General</h3>
+<a name="N10010"></a><a name="faq_add"></a>
 <h4 class="faq">1.1. 
+        How can I add a new entry to the Derby FAQ?
+      </h4>
+<div align="right">
+<a href="#faq_add-menu">^</a>
+</div>
+<div style="margin-left: 15px">
+<p> We welcome additions!
+        Please add your new entry to 
+        <a class="external" href="http://issues.apache.org/jira/browse/DERBY-232">DERBY-232</a>.
+        All you need is to create a 
+        <a class="external" href="http://issues.apache.org">Jira id</a>
+         if you don't already have one.
+        </p>
+</div>
+<a name="N10020"></a><a name="developers"></a>
+<h3 class="boxed">2. Developing Derby</h3>
+<a name="N10024"></a><a name="derby_source"></a>
+<h4 class="faq">2.1. 
         Where is the Derby source code?
       </h4>
 <div align="right">
@@ -262,8 +300,8 @@
 	interface to view Derby source code using your web browser.
         </p>
 </div>
-<a name="N10020"></a><a name="derby_internals"></a>
-<h4 class="faq">1.2. 
+<a name="N10034"></a><a name="derby_internals"></a>
+<h4 class="faq">2.2. 
         Where can I read about Derby internals?
       </h4>
 <div align="right">
@@ -279,8 +317,8 @@
 	mail list and post any questions you have.
         </p>
 </div>
-<a name="N10030"></a><a name="derby_issues"></a>
-<h4 class="faq">1.3. 
+<a name="N10044"></a><a name="derby_issues"></a>
+<h4 class="faq">2.3. 
         Where are Apache Derby bugs logged?
       </h4>
 <div align="right">
@@ -293,8 +331,8 @@
 	tracker</a> to track bugs.
 	</p>
 </div>
-<a name="N1003C"></a><a name="derby_update"></a>
-<h4 class="faq">1.4. 
+<a name="N10050"></a><a name="derby_update"></a>
+<h4 class="faq">2.4. 
         Who can create a new Apache Derby issue?
       </h4>
 <div align="right">
@@ -312,8 +350,8 @@
          request that it be added to the derby-developers Jira list.
 	</p>
 </div>
-<a name="N1004C"></a><a name="derby_eclipse"></a>
-<h4 class="faq">1.5. 
+<a name="N10060"></a><a name="derby_eclipse"></a>
+<h4 class="faq">2.5. 
         How do you build Derby using Eclipse?
       </h4>
 <div align="right">
@@ -326,10 +364,10 @@
 
 	</p>
 </div>
-<a name="N10058"></a><a name="users_getstart"></a>
-<h3 class="boxed">2. Using Derby: Getting Started</h3>
-<a name="N1005C"></a><a name="derby_ask"></a>
-<h4 class="faq">2.1. 
+<a name="N1006C"></a><a name="users_getstart"></a>
+<h3 class="boxed">3. Using Derby: Getting Started</h3>
+<a name="N10070"></a><a name="derby_ask"></a>
+<h4 class="faq">3.1. 
         Where can I ask questions about how to use Derby?
       </h4>
 <div align="right">
@@ -348,8 +386,8 @@
         feel free to ask for more help.
         </p>
 </div>
-<a name="N10068"></a><a name="derby_jar"></a>
-<h4 class="faq">2.2. 
+<a name="N1007C"></a><a name="derby_jar"></a>
+<h4 class="faq">3.2. 
         Where can I download the Derby jar files?
       </h4>
 <div align="right">
@@ -361,8 +399,8 @@
 	from the <a href="derby_downloads.html">Derby Downloads</a> page.
 	</p>
 </div>
-<a name="N10074"></a><a name="derby_alpha"></a>
-<h4 class="faq">2.3. 
+<a name="N10088"></a><a name="derby_alpha"></a>
+<h4 class="faq">3.3. 
       What are Derby alpha snaphots and should I use them?
       </h4>
 <div align="right">
@@ -379,8 +417,8 @@
       must not be used for production</a>.
       </p>
 </div>
-<a name="N10084"></a><a name="where_are_docs"></a>
-<h4 class="faq">2.4. 
+<a name="N10098"></a><a name="where_are_docs"></a>
+<h4 class="faq">3.4. 
       Where can I find the Derby documentation?
       </h4>
 <div align="right">
@@ -405,8 +443,8 @@
       instructions.
       </p>
 </div>
-<a name="N100A6"></a><a name="pda"></a>
-<h4 class="faq">2.5. 
+<a name="N100BA"></a><a name="pda"></a>
+<h4 class="faq">3.5. 
       Can you run Derby on PDAs?
       </h4>
 <div align="right">
@@ -421,8 +459,8 @@
       Guide</a>.
       </p>
 </div>
-<a name="N100B2"></a><a name="createdb_OS_X"></a>
-<h4 class="faq">2.6. 
+<a name="N100C6"></a><a name="createdb_OS_X"></a>
+<h4 class="faq">3.6. 
         Why can't I create a new database or modify an existing database 
 	on Mac OS X?
       </h4>
@@ -443,8 +481,8 @@
 	sync instead of write sync for log writes.
 	</p>
 </div>
-<a name="N100C2"></a><a name="derby_jdk51"></a>
-<h4 class="faq">2.7. 
+<a name="N100D6"></a><a name="derby_jdk51"></a>
+<h4 class="faq">3.7. 
       Can I use Derby on JDK 5.0?
       </h4>
 <div align="right">
@@ -462,8 +500,8 @@
       5.0 is also known as JDK 1.5</a>.
       </p>
 </div>
-<a name="N100D6"></a><a name="in_memory"></a>
-<h4 class="faq">2.8. 
+<a name="N100EA"></a><a name="in_memory"></a>
+<h4 class="faq">3.8. 
       Does Derby have a mode that causes it to run entirely in memory?
       </h4>
 <div align="right">
@@ -479,10 +517,10 @@
       Check that mail list for current status.
       </p>
 </div>
-<a name="N100E6"></a><a name="users_sql"></a>
-<h3 class="boxed">3. Using Derby: SQL</h3>
-<a name="N100EA"></a><a name="null_args"></a>
-<h4 class="faq">3.1. 
+<a name="N100FA"></a><a name="users_sql"></a>
+<h3 class="boxed">4. Using Derby: SQL</h3>
+<a name="N100FE"></a><a name="null_args"></a>
+<h4 class="faq">4.1. 
       Why can't my SQL function/procedure pass a NULL INTEGER?
       </h4>
 <div align="right">
@@ -500,8 +538,8 @@
       mail list topic.
       </p>
 </div>
-<a name="N100F6"></a><a name="limit"></a>
-<h4 class="faq">3.2. 
+<a name="N1010A"></a><a name="limit"></a>
+<h4 class="faq">4.2. 
       Does Derby support a LIMIT command? 
       </h4>
 <div align="right">
@@ -513,8 +551,8 @@
       <a class="external" href="http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200411.mbox/%3c41A95632.3010301@debrunners.com%3e">JDBC</a>.
       </p>
 </div>
-<a name="N10102"></a><a name="schema_exist"></a>
-<h4 class="faq">3.3. 
+<a name="N10116"></a><a name="schema_exist"></a>
+<h4 class="faq">4.3. 
       Why do I get the error 'schema does not exist'?
       </h4>
 <div align="right">
@@ -545,8 +583,8 @@
       to create in a particular schema and no explicit CREATE SCHEMA was issued.
       </p>
 </div>
-<a name="N10113"></a><a name="debug_lock_timeout"></a>
-<h4 class="faq">3.4. 
+<a name="N10127"></a><a name="debug_lock_timeout"></a>
+<h4 class="faq">4.4. 
       I get a lock timeout error. How do I debug this?
       </h4>
 <div align="right">
@@ -574,10 +612,27 @@
       to narrow down which statements may be holding the locks.
       </p>
 </div>
-<a name="N1012D"></a><a name="users_client"></a>
-<h3 class="boxed">4. Using Derby: Client Programming</h3>
-<a name="N10131"></a><a name="clientserv"></a>
-<h4 class="faq">4.1. 
+<a name="N10141"></a><a name="identity"></a>
+<h4 class="faq">4.5. 
+      Can Derby generate unique identifiers like sequences?
+      </h4>
+<div align="right">
+<a href="#identity-menu">^</a>
+</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.1/ref/rrefsqlj37836.html">Reference
Guide</a>.
+      The
+ <a href="http://db.apache.org/derby/docs/10.1/ref/rrefidentityvallocal.html#rrefidentityvallocal">IDENTITY_VAL_LOCAL</a>
+       function returns the most recently assigned number.
+      </p>
+</div>
+<a name="N10151"></a><a name="users_client"></a>
+<h3 class="boxed">5. Using Derby: Client Programming</h3>
+<a name="N10155"></a><a name="clientserv"></a>
+<h4 class="faq">5.1. 
       Can you use Derby for client-server applications?
       </h4>
 <div align="right">
@@ -597,8 +652,8 @@
       DB2 JDBC Universal Driver</a>.
       </p>
 </div>
-<a name="N10149"></a><a name="netclient"></a>
-<h4 class="faq">4.2. 
+<a name="N1016D"></a><a name="netclient"></a>
+<h4 class="faq">5.2. 
       Does Derby include a client-server ("network") jdbc driver?
       </h4>
 <div align="right">
@@ -613,8 +668,8 @@
       and it became available in Derby 10.1.
       </p>
 </div>
-<a name="N10155"></a><a name="db2_jcc_errors"></a>
-<h4 class="faq">4.3. 
+<a name="N10179"></a><a name="db2_jcc_errors"></a>
+<h4 class="faq">5.3. 
       How can I get the message text for an error using the DB2 JDBC
       Universal Driver?
       </h4>
@@ -631,8 +686,8 @@
       mail list topic.
       </p>
 </div>
-<a name="N10164"></a><a name="derby_xa"></a>
-<h4 class="faq">4.4. 
+<a name="N10188"></a><a name="derby_xa"></a>
+<h4 class="faq">5.4. 
       Can you execute a query that spans two Derby databases 
       across different JVMs?
       </h4>
@@ -647,8 +702,8 @@
       <a href="http://db.apache.org/derby/docs/10.1/adminguide/cadminapps811478.html">Admin
and Server Guide</a>.
       </p>
 </div>
-<a name="N10170"></a><a name="derby_faster"></a>
-<h4 class="faq">4.5. 
+<a name="N10194"></a><a name="derby_faster"></a>
+<h4 class="faq">5.5. 
       Are there any tips to make Derby go faster?
       </h4>
 <div align="right">
@@ -681,6 +736,24 @@
       </li>
       
 </ol>
+</div>
+<a name="N101AD"></a><a name="jdbc_lob"></a>
+<h4 class="faq">5.6. 
+      Where is an example that shows how to insert a CLOB?
+      </h4>
+<div align="right">
+<a href="#jdbc_lob-menu">^</a>
+</div>
+<div style="margin-left: 15px">
+<p>
+      The <em>Reference Guide</em> includes an 
+      <a href="http://db.apache.org/derby/docs/10.1/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

+      derby-user post</a>
+      provides another example.
+      </p>
 </div>
 </div>
 </div>

Modified: db/derby/site/trunk/src/documentation/content/xdocs/faq.xml
URL: http://svn.apache.org/viewcvs/db/derby/site/trunk/src/documentation/content/xdocs/faq.xml?rev=290319&r1=290318&r2=290319&view=diff
==============================================================================
--- db/derby/site/trunk/src/documentation/content/xdocs/faq.xml (original)
+++ db/derby/site/trunk/src/documentation/content/xdocs/faq.xml Mon Sep 19 17:17:34 2005
@@ -20,6 +20,24 @@
 <faqs>
    <title>Frequently Asked Questions</title>
 
+  <faqsection id="general">
+    <title>General</title>
+    <faq id="faq_add">
+      <question>
+        How can I add a new entry to the Derby FAQ?
+      </question>
+      <answer>
+        <p> We welcome additions!
+        Please add your new entry to 
+        <a href="http://issues.apache.org/jira/browse/DERBY-232">DERBY-232</a>.
+        All you need is to create a 
+        <a href="http://issues.apache.org">Jira id</a>
+         if you don't already have one.
+        </p>
+      </answer>
+    </faq>
+  </faqsection>
+
   <faqsection id="developers">
 
     <title>Developing Derby</title>
@@ -340,6 +358,21 @@
       </p>
       </answer>
     </faq>
+    <faq id="identity">
+      <question>
+      Can Derby generate unique identifiers like sequences?
+      </question>
+      <answer>
+      <p>
+      Derby supports generated "identity" columns; examples are in
+      the 
+      <a href="http://db.apache.org/derby/docs/10.1/ref/rrefsqlj37836.html">Reference
Guide</a>.
+      The
+ <a href="http://db.apache.org/derby/docs/10.1/ref/rrefidentityvallocal.html#rrefidentityvallocal">IDENTITY_VAL_LOCAL</a>
+       function returns the most recently assigned number.
+      </p>
+      </answer>
+    </faq>
   </faqsection>
   <faqsection id="users_client">
     <title>Using Derby: Client Programming</title>
@@ -434,6 +467,22 @@
         issue a commit.
       </li>
       </ol>
+      </answer>
+    </faq>
+    <faq id="jdbc_lob">
+      <question>
+      Where is an example that shows how to insert a CLOB?
+      </question>
+      <answer>
+      <p>
+      The <em>Reference Guide</em> includes an 
+      <a href="http://db.apache.org/derby/docs/10.1/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

+      derby-user post</a>
+      provides another example.
+      </p>
       </answer>
     </faq>
   </faqsection>



Mime
View raw message