You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by jt...@apache.org on 2005/05/27 02:29:01 UTC
svn commit: r178719 - in /incubator/derby/site/trunk: build/site/faq.html
src/documentation/content/xdocs/faq.xml
Author: jta
Date: Thu May 26 17:29:00 2005
New Revision: 178719
URL: http://svn.apache.org/viewcvs?rev=178719&view=rev
Log:
DERBY-232: added Stan Bradbury's May 26 FAQ contributions. Also split the
"Using Derby" FAQs into multiple sections.
Modified:
incubator/derby/site/trunk/build/site/faq.html
incubator/derby/site/trunk/src/documentation/content/xdocs/faq.xml
Modified: incubator/derby/site/trunk/build/site/faq.html
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/build/site/faq.html?rev=178719&r1=178718&r2=178719&view=diff
==============================================================================
--- incubator/derby/site/trunk/build/site/faq.html (original)
+++ incubator/derby/site/trunk/build/site/faq.html Thu May 26 17:29:00 2005
@@ -187,63 +187,89 @@
</ul>
</li>
<li>
-<a href="#users">2. Using Derby</a>
+<a href="#users_getstart">2. Using Derby: Getting Started</a>
<ul class="minitoc">
<li>
-<a href="#where_are_docs">2.1.
+<a href="#derby_jar">2.1.
+ Where can I download the Derby jar files?
+ </a>
+</li>
+<li>
+<a href="#derby_alpha">2.2.
+ What are Derby alpha snaphots and should I use them?
+ </a>
+</li>
+<li>
+<a href="#where_are_docs">2.3.
Where can I find the Derby documentation?
</a>
</li>
<li>
-<a href="#createdb_OS_X">2.2.
+<a href="#pda">2.4.
+ Can you run Derby on PDAs and phones?
+ </a>
+</li>
+<li>
+<a href="#createdb_OS_X">2.5.
Why can't I create a new database or modify an existing database
on Mac OS X?
</a>
</li>
<li>
-<a href="#derby_jar">2.3.
- Where can I download the Derby jar files?
+<a href="#derby_jdk51">2.6.
+ Can I use Derby on JDK 5.1?
</a>
</li>
<li>
-<a href="#null_args">2.4.
- Why can't my SQL function/procedure pass a NULL INTEGER?
+<a href="#in_memory">2.7.
+ Does Derby have a mode that causes it to run entirely in memory?
</a>
</li>
+</ul>
+</li>
<li>
-<a href="#pda">2.5.
- Can you run Derby on PDAs and phones?
+<a href="#users_sql">3. Using Derby: SQL</a>
+<ul class="minitoc">
+<li>
+<a href="#null_args">3.1.
+ Why can't my SQL function/procedure pass a NULL INTEGER?
</a>
</li>
<li>
-<a href="#limit">2.6.
+<a href="#limit">3.2.
Does Derby support a LIMIT command?
</a>
</li>
<li>
-<a href="#clientserv">2.7.
+<a href="#schema_exist">3.3.
+ Why do I get the error 'schema does not exist'?
+ </a>
+</li>
+</ul>
+</li>
+<li>
+<a href="#users_client">4. Using Derby: Client Programming</a>
+<ul class="minitoc">
+<li>
+<a href="#clientserv">4.1.
Can you use Derby for client-server applications?
</a>
</li>
<li>
-<a href="#netclient">2.8.
+<a href="#netclient">4.2.
Does Derby include a client-server ("network") jdbc driver?
</a>
</li>
<li>
-<a href="#db2_jcc_errors">2.9.
+<a href="#db2_jcc_errors">4.3.
How can I get the message text for an error using the DB2 JDBC
Universal Driver?
</a>
</li>
<li>
-<a href="#schema_exist">2.10.
- Why do I get the error 'schema does not exist'?
- </a>
-</li>
-<li>
-<a href="#in_memory">2.11.
- Does Derby have a mode that causes it to run entirely in memory?
+<a href="#derby_xa">4.4.
+ Can you execute a query that spans two Derby databases
+ across different JVMs?
</a>
</li>
</ul>
@@ -339,10 +365,41 @@
</p>
</div>
-<a name="N10058"></a><a name="users"></a>
-<h3 class="boxed">2. Using Derby</h3>
-<a name="N1005C"></a><a name="where_are_docs"></a>
+<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_jar"></a>
<h4 class="faq">2.1.
+ Where can I download the Derby jar files?
+ </h4>
+<div align="right">
+<a href="#derby_jar-menu">^</a>
+</div>
+<div style="margin-left: 15px">
+<p>
+ You can download the Derby jar files
+ from the <a href="derby_downloads.html">Derby Downloads</a> page.
+ </p>
+</div>
+<a name="N10068"></a><a name="derby_alpha"></a>
+<h4 class="faq">2.2.
+ What are Derby alpha snaphots and should I use them?
+ </h4>
+<div align="right">
+<a href="#derby_alpha-menu">^</a>
+</div>
+<div style="margin-left: 15px">
+<p>
+ The alpha snapshots available for download from the
+ <a href="derby_downloads.html">downloads page</a> include new
+ functionality and are made available
+ for those who want to test these new features.
+ However,
+ <a href="derby_downloads.html#Development+trunk">they
+ must not be used for production</a>.
+ </p>
+</div>
+<a name="N10078"></a><a name="where_are_docs"></a>
+<h4 class="faq">2.3.
Where can I find the Derby documentation?
</h4>
<div align="right">
@@ -367,8 +424,27 @@
instructions.
</p>
</div>
-<a name="N1007E"></a><a name="createdb_OS_X"></a>
-<h4 class="faq">2.2.
+<a name="N1009A"></a><a name="pda"></a>
+<h4 class="faq">2.4.
+ Can you run Derby on PDAs and phones?
+ </h4>
+<div align="right">
+<a href="#pda-menu">^</a>
+</div>
+<div style="margin-left: 15px">
+<p>
+ Derby requires a JVM of 1.3 (J2SE) or higher,
+ which is rarely what is found on PDAs and phones.
+ A feature on the <a href="DerbyToDo.html#Features">To Do list</a>
+ will modify Derby to support
+ J2ME/CDC/Foundation with JSR169 as the JDBC api.
+ Also see the
+ <a class="external" href="http://mail-archives.eu.apache.org/mod_mbox/db-derby-user/200411.mbox/%3c41A6478B.2020909@g2k.es%3e">"derby inside pda"</a>
+ mail list topic.
+ </p>
+</div>
+<a name="N100AA"></a><a name="createdb_OS_X"></a>
+<h4 class="faq">2.5.
Why can't I create a new database or modify an existing database
on Mac OS X?
</h4>
@@ -388,21 +464,43 @@
sync instead of write sync for log writes.
</p>
</div>
-<a name="N1008E"></a><a name="derby_jar"></a>
-<h4 class="faq">2.3.
- Where can I download the Derby jar files?
+<a name="N100BA"></a><a name="derby_jdk51"></a>
+<h4 class="faq">2.6.
+ Can I use Derby on JDK 5.1?
</h4>
<div align="right">
-<a href="#derby_jar-menu">^</a>
+<a href="#derby_jdk51-menu">^</a>
</div>
<div style="margin-left: 15px">
<p>
- You can download the Derby jar files
- from the <a href="derby_downloads.html">Derby Downloads</a> page.
- </p>
+ Two problems with handling Decimal conversion on JDK 1.5
+ (<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>)
+ have been fixed in the Derby 10.1 development codeline.
+ </p>
</div>
-<a name="N1009A"></a><a name="null_args"></a>
-<h4 class="faq">2.4.
+<a name="N100CA"></a><a name="in_memory"></a>
+<h4 class="faq">2.7.
+ Does Derby have a mode that causes it to run entirely in memory?
+ </h4>
+<div align="right">
+<a href="#in_memory-menu">^</a>
+</div>
+<div style="margin-left: 15px">
+<p>
+ No, Derby does not support an in-memory mode, though a feature
+ is on the <a href="DerbyToDo.html">To Do list</a>.
+ When this FAQ entry was written
+ <a href="derby_mail.html">derby-dev@db.apache.org</a> list activity
+ indicated that the feature is not actively being worked on.
+ Check that mail list for current status.
+ </p>
+</div>
+<a name="N100DA"></a><a name="users_sql"></a>
+<h3 class="boxed">3. Using Derby: SQL</h3>
+<a name="N100DE"></a><a name="null_args"></a>
+<h4 class="faq">3.1.
Why can't my SQL function/procedure pass a NULL INTEGER?
</h4>
<div align="right">
@@ -420,40 +518,55 @@
mail list topic.
</p>
</div>
-<a name="N100A6"></a><a name="pda"></a>
-<h4 class="faq">2.5.
- Can you run Derby on PDAs and phones?
+<a name="N100EA"></a><a name="limit"></a>
+<h4 class="faq">3.2.
+ Does Derby support a LIMIT command?
</h4>
<div align="right">
-<a href="#pda-menu">^</a>
+<a href="#limit-menu">^</a>
</div>
<div style="margin-left: 15px">
<p>
- Derby requires a JVM of 1.3 (J2SE) or higher,
- which is rarely what is found on PDAs and phones.
- A feature on the <a href="DerbyToDo.html#Features">To Do list</a>
- will modify Derby to support
- J2ME/CDC/Foundation with JSR169 as the JDBC api.
- Also see the
- <a class="external" href="http://mail-archives.eu.apache.org/mod_mbox/db-derby-user/200411.mbox/%3c41A6478B.2020909@g2k.es%3e">"derby inside pda"</a>
- mail list topic.
+ Derby supports limiting the number of rows returned by a query through
+ <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="N100B6"></a><a name="limit"></a>
-<h4 class="faq">2.6.
- Does Derby support a LIMIT command?
+<a name="N100F6"></a><a name="schema_exist"></a>
+<h4 class="faq">3.3.
+ Why do I get the error 'schema does not exist'?
</h4>
<div align="right">
-<a href="#limit-menu">^</a>
+<a href="#schema_exist-menu">^</a>
</div>
<div style="margin-left: 15px">
<p>
- Derby supports limiting the number of rows returned by a query through
- <a class="external" href="http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200411.mbox/%3c41A95632.3010301@debrunners.com%3e">JDBC</a>.
+ The current schema for any connection defaults to a schema corresponding
+ to the user name. If no user name is supplied then the user name (and
+ hence current schema) defaults to APP.
+ </p>
+<p>
+ However even though the current schema is set to the user name, that
+ schema may not exist. A schema is only created by CREATE SCHEMA or
+ creating an object (table etc.) in that schema (this is implicit schema
+ creation).
+ </p>
+<p>
+ The one exception to this is the APP schema, which is always created,
+ though applications should not depend on that.
+ </p>
+<p>
+ So you will see the schema not exists error if your application tries to
+ access the current schema before any objects have been created in it.
+ Possibilities are you try to perform a DROP TABLE before creating it, or
+ try to SELECT from a table to see if it should be created or not, or
+ when there is a problem with the sql for the very first object you try
+ to create in a particular schema and no explicit CREATE SCHEMA was issued.
</p>
</div>
-<a name="N100C2"></a><a name="clientserv"></a>
-<h4 class="faq">2.7.
+<a name="N10107"></a><a name="users_client"></a>
+<h3 class="boxed">4. Using Derby: Client Programming</h3>
+<a name="N1010B"></a><a name="clientserv"></a>
+<h4 class="faq">4.1.
Can you use Derby for client-server applications?
</h4>
<div align="right">
@@ -473,8 +586,8 @@
<a href="papers/DerbyClientSpec.html">Derby Network Client</a>.
</p>
</div>
-<a name="N100DA"></a><a name="netclient"></a>
-<h4 class="faq">2.8.
+<a name="N10123"></a><a name="netclient"></a>
+<h4 class="faq">4.2.
Does Derby include a client-server ("network") jdbc driver?
</h4>
<div align="right">
@@ -495,9 +608,14 @@
<a href="papers/DerbyClientSpec.html">functional specification</a>
provides API descriptions and example usage.
</p>
+<p>
+ Just remember that
+ <a href="derby_downloads.html#Development+trunk">the alpha snapshots
+ must not be used for production</a>.
+ </p>
</div>
-<a name="N100EA"></a><a name="db2_jcc_errors"></a>
-<h4 class="faq">2.9.
+<a name="N1013A"></a><a name="db2_jcc_errors"></a>
+<h4 class="faq">4.3.
How can I get the message text for an error using the DB2 JDBC
Universal Driver?
</h4>
@@ -514,53 +632,30 @@
mail list topic.
</p>
</div>
-<a name="N100F9"></a><a name="schema_exist"></a>
-<h4 class="faq">2.10.
- Why do I get the error 'schema does not exist'?
+<a name="N10149"></a><a name="derby_xa"></a>
+<h4 class="faq">4.4.
+ Can you execute a query that spans two Derby databases
+ across different JVMs?
</h4>
<div align="right">
-<a href="#schema_exist-menu">^</a>
+<a href="#derby_xa-menu">^</a>
</div>
<div style="margin-left: 15px">
<p>
- The current schema for any connection defaults to a schema corresponding
- to the user name. If no user name is supplied then the user name (and
- hence current schema) defaults to APP.
+ XA support using Network Server will allow you to do this.
+ This functionality has been added to the Derby 10.1 development codeline.
+ You can test drive the functionality using the
+ Derby 10.1 alpha snapshot available on the
+ <a href="http://incubator.apache.org/derby/derby_downloads.html#Snapshot+Jars">downloads page</a>.
+ There is an example of establishing an XA connection in the 10.1
+ build of the
+ <a href="http://incubator.apache.org/derby/docs/adminguide/cadminapps811478.html">Admin and Server Guide</a>.
</p>
<p>
- However even though the current schema is set to the user name, that
- schema may not exist. A schema is only created by CREATE SCHEMA or
- creating an object (table etc.) in that schema (this is implicit schema
- creation).
- </p>
-<p>
- The one exception to this is the APP schema, which is always created,
- though applications should not depend on that.
- </p>
-<p>
- So you will see the schema not exists error if your application tries to
- access the current schema before any objects have been created in it.
- Possibilities are you try to perform a DROP TABLE before creating it, or
- try to SELECT from a table to see if it should be created or not, or
- when there is a problem with the sql for the very first object you try
- to create in a particular schema and no explicit CREATE SCHEMA was issued.
- </p>
-</div>
-<a name="N1010A"></a><a name="in_memory"></a>
-<h4 class="faq">2.11.
- Does Derby have a mode that causes it to run entirely in memory?
- </h4>
-<div align="right">
-<a href="#in_memory-menu">^</a>
-</div>
-<div style="margin-left: 15px">
-<p>
- No, Derby does not support an in-memory mode, though a feature
- is on the <a href="DerbyToDo.html">To Do list</a>.
- When this FAQ entry was written
- <a href="derby_mail.html">derby-dev@db.apache.org</a> list activity
- indicated that the feature is not actively being worked on.
- Check that mail list for current status.
+ If you decide to test drive XA on Derby 10.1, just remember that
+ <a href="derby_downloads.html#Development+trunk">the development
+ codeline and alpha snapshots must not be
+ used for production</a>.
</p>
</div>
</div>
Modified: incubator/derby/site/trunk/src/documentation/content/xdocs/faq.xml
URL: http://svn.apache.org/viewcvs/incubator/derby/site/trunk/src/documentation/content/xdocs/faq.xml?rev=178719&r1=178718&r2=178719&view=diff
==============================================================================
--- incubator/derby/site/trunk/src/documentation/content/xdocs/faq.xml (original)
+++ incubator/derby/site/trunk/src/documentation/content/xdocs/faq.xml Thu May 26 17:29:00 2005
@@ -105,8 +105,36 @@
</faqsection>
- <faqsection id="users">
- <title>Using Derby</title>
+ <faqsection id="users_getstart">
+ <title>Using Derby: Getting Started</title>
+
+ <faq id="derby_jar">
+ <question>
+ Where can I download the Derby jar files?
+ </question>
+ <answer>
+ <p>
+ You can download the Derby jar files
+ from the <a href="derby_downloads.html">Derby Downloads</a> page.
+ </p>
+ </answer>
+ </faq>
+ <faq id="derby_alpha">
+ <question>
+ What are Derby alpha snaphots and should I use them?
+ </question>
+ <answer>
+ <p>
+ The alpha snapshots available for download from the
+ <a href="derby_downloads.html">downloads page</a> include new
+ functionality and are made available
+ for those who want to test these new features.
+ However,
+ <a href="derby_downloads.html#Development+trunk">they
+ must not be used for production</a>.
+ </p>
+ </answer>
+ </faq>
<faq id="where_are_docs">
<question>
@@ -132,6 +160,23 @@
</p>
</answer>
</faq>
+ <faq id="pda">
+ <question>
+ Can you run Derby on PDAs and phones?
+ </question>
+ <answer>
+ <p>
+ Derby requires a JVM of 1.3 (J2SE) or higher,
+ which is rarely what is found on PDAs and phones.
+ A feature on the <a href="DerbyToDo.html#Features">To Do list</a>
+ will modify Derby to support
+ J2ME/CDC/Foundation with JSR169 as the JDBC api.
+ Also see the
+ <a href="http://mail-archives.eu.apache.org/mod_mbox/db-derby-user/200411.mbox/%3c41A6478B.2020909@g2k.es%3e">"derby inside pda"</a>
+ mail list topic.
+ </p>
+ </answer>
+ </faq>
<faq id="createdb_OS_X">
<question>
Why can't I create a new database or modify an existing database
@@ -151,18 +196,41 @@
</p>
</answer>
</faq>
- <faq id="derby_jar">
+ <faq id="derby_jdk51">
<question>
- Where can I download the Derby jar files?
+ Can I use Derby on JDK 5.1?
</question>
<answer>
- <p>
- You can download the Derby jar files
- from the <a href="derby_downloads.html">Derby Downloads</a> page.
- </p>
+ <p>
+ Two problems with handling Decimal conversion on JDK 1.5
+ (<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>)
+ have been fixed in the Derby 10.1 development codeline.
+ </p>
</answer>
</faq>
+ <faq id="in_memory">
+ <question>
+ Does Derby have a mode that causes it to run entirely in memory?
+ </question>
+ <answer>
+ <p>
+ No, Derby does not support an in-memory mode, though a feature
+ is on the <a href="DerbyToDo.html">To Do list</a>.
+ When this FAQ entry was written
+ <a href="derby_mail.html">derby-dev@db.apache.org</a> list activity
+ indicated that the feature is not actively being worked on.
+ Check that mail list for current status.
+ </p>
+ </answer>
+ </faq>
+ </faqsection>
+
+ <faqsection id="users_sql">
+ <title>Using Derby: SQL</title>
+
<faq id="null_args">
<question>
Why can't my SQL function/procedure pass a NULL INTEGER?
@@ -180,36 +248,54 @@
</p>
</answer>
</faq>
- <faq id="pda">
+
+ <faq id="limit">
<question>
- Can you run Derby on PDAs and phones?
+ Does Derby support a LIMIT command?
</question>
<answer>
<p>
- Derby requires a JVM of 1.3 (J2SE) or higher,
- which is rarely what is found on PDAs and phones.
- A feature on the <a href="DerbyToDo.html#Features">To Do list</a>
- will modify Derby to support
- J2ME/CDC/Foundation with JSR169 as the JDBC api.
- Also see the
- <a href="http://mail-archives.eu.apache.org/mod_mbox/db-derby-user/200411.mbox/%3c41A6478B.2020909@g2k.es%3e">"derby inside pda"</a>
- mail list topic.
+ Derby supports limiting the number of rows returned by a query through
+ <a href="http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200411.mbox/%3c41A95632.3010301@debrunners.com%3e">JDBC</a>.
</p>
</answer>
-
</faq>
-
- <faq id="limit">
+ <faq id="schema_exist">
<question>
- Does Derby support a LIMIT command?
+ Why do I get the error 'schema does not exist'?
</question>
<answer>
<p>
- Derby supports limiting the number of rows returned by a query through
- <a href="http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200411.mbox/%3c41A95632.3010301@debrunners.com%3e">JDBC</a>.
+ The current schema for any connection defaults to a schema corresponding
+ to the user name. If no user name is supplied then the user name (and
+ hence current schema) defaults to APP.
+ </p>
+
+ <p>
+ However even though the current schema is set to the user name, that
+ schema may not exist. A schema is only created by CREATE SCHEMA or
+ creating an object (table etc.) in that schema (this is implicit schema
+ creation).
+ </p>
+
+ <p>
+ The one exception to this is the APP schema, which is always created,
+ though applications should not depend on that.
+ </p>
+
+ <p>
+ So you will see the schema not exists error if your application tries to
+ access the current schema before any objects have been created in it.
+ Possibilities are you try to perform a DROP TABLE before creating it, or
+ try to SELECT from a table to see if it should be created or not, or
+ when there is a problem with the sql for the very first object you try
+ to create in a particular schema and no explicit CREATE SCHEMA was issued.
</p>
</answer>
</faq>
+ </faqsection>
+ <faqsection id="users_client">
+ <title>Using Derby: Client Programming</title>
<faq id="clientserv">
<question>
Can you use Derby for client-server applications?
@@ -248,6 +334,11 @@
<a href="papers/DerbyClientSpec.html">functional specification</a>
provides API descriptions and example usage.
</p>
+ <p>
+ Just remember that
+ <a href="derby_downloads.html#Development+trunk">the alpha snapshots
+ must not be used for production</a>.
+ </p>
</answer>
</faq>
<faq id="db2_jcc_errors">
@@ -266,54 +357,29 @@
</p>
</answer>
</faq>
- <faq id="schema_exist">
+ <faq id="derby_xa">
<question>
- Why do I get the error 'schema does not exist'?
+ Can you execute a query that spans two Derby databases
+ across different JVMs?
</question>
<answer>
<p>
- The current schema for any connection defaults to a schema corresponding
- to the user name. If no user name is supplied then the user name (and
- hence current schema) defaults to APP.
+ XA support using Network Server will allow you to do this.
+ This functionality has been added to the Derby 10.1 development codeline.
+ You can test drive the functionality using the
+ Derby 10.1 alpha snapshot available on the
+ <a href="http://incubator.apache.org/derby/derby_downloads.html#Snapshot+Jars">downloads page</a>.
+ There is an example of establishing an XA connection in the 10.1
+ build of the
+ <a href="http://incubator.apache.org/derby/docs/adminguide/cadminapps811478.html">Admin and Server Guide</a>.
</p>
-
<p>
- However even though the current schema is set to the user name, that
- schema may not exist. A schema is only created by CREATE SCHEMA or
- creating an object (table etc.) in that schema (this is implicit schema
- creation).
- </p>
-
- <p>
- The one exception to this is the APP schema, which is always created,
- though applications should not depend on that.
- </p>
-
- <p>
- So you will see the schema not exists error if your application tries to
- access the current schema before any objects have been created in it.
- Possibilities are you try to perform a DROP TABLE before creating it, or
- try to SELECT from a table to see if it should be created or not, or
- when there is a problem with the sql for the very first object you try
- to create in a particular schema and no explicit CREATE SCHEMA was issued.
- </p>
- </answer>
- </faq>
- <faq id="in_memory">
- <question>
- Does Derby have a mode that causes it to run entirely in memory?
- </question>
- <answer>
- <p>
- No, Derby does not support an in-memory mode, though a feature
- is on the <a href="DerbyToDo.html">To Do list</a>.
- When this FAQ entry was written
- <a href="derby_mail.html">derby-dev@db.apache.org</a> list activity
- indicated that the feature is not actively being worked on.
- Check that mail list for current status.
+ If you decide to test drive XA on Derby 10.1, just remember that
+ <a href="derby_downloads.html#Development+trunk">the development
+ codeline and alpha snapshots must not be
+ used for production</a>.
</p>
</answer>
</faq>
-
</faqsection>
</faqs>