Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 9904 invoked from network); 23 Aug 2006 18:57:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 23 Aug 2006 18:57:42 -0000 Received: (qmail 21886 invoked by uid 500); 23 Aug 2006 18:57:42 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 21807 invoked by uid 500); 23 Aug 2006 18:57:42 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 21796 invoked by uid 99); 23 Aug 2006 18:57:42 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Aug 2006 11:57:42 -0700 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [140.211.166.113] (HELO eris.apache.org) (140.211.166.113) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Aug 2006 11:57:41 -0700 Received: by eris.apache.org (Postfix, from userid 65534) id E1A8E1A981A; Wed, 23 Aug 2006 11:57:20 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r434125 - in /db/derby/docs/trunk/src/devguide: cdevdvlp30653.dita cdevstandards805975.dita cdevstandardsxml.dita derbydev.ditamap Date: Wed, 23 Aug 2006 18:57:20 -0000 To: derby-commits@db.apache.org From: jta@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20060823185720.E1A8E1A981A@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Author: jta Date: Wed Aug 23 11:57:19 2006 New Revision: 434125 URL: http://svn.apache.org/viewvc?rev=434125&view=rev Log: DERBY-1655: Documentation for XML functionality to the Developers Guide. Reverted the patch committed in revision 433708 because the addition of src/devguide/cdevstandardsxml.dita (or perhaps the corresponding modification to src/devguide/derbydev.ditamap) causes the DITA PDF build to fail. Removed: db/derby/docs/trunk/src/devguide/cdevstandardsxml.dita Modified: db/derby/docs/trunk/src/devguide/cdevdvlp30653.dita db/derby/docs/trunk/src/devguide/cdevstandards805975.dita db/derby/docs/trunk/src/devguide/derbydev.ditamap Modified: db/derby/docs/trunk/src/devguide/cdevdvlp30653.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/devguide/cdevdvlp30653.dita?rev=434125&r1=434124&r2=434125&view=diff ============================================================================== --- db/derby/docs/trunk/src/devguide/cdevdvlp30653.dita (original) +++ db/derby/docs/trunk/src/devguide/cdevdvlp30653.dita Wed Aug 23 11:57:19 2006 @@ -1,5 +1,5 @@ - + -<ph conref="devconrefs.dita#prod/productshortname"></ph> database limitations +Database limitations databases have a few limitations. -limitationsDerby databases -indexeslimitations +Limitationsin current version +Indexeslimitations ofnot supported +for CLOB, BLOB, and LONG VARCHAR data types -
Indexes

Indexes are not supported for columns defined -on CLOB, BLOB, LONG VARCHAR, and XML data types.

If the length of the -key columns in an index is larger than half the page size of the index, creating -an index on those key columns for the table fails. For existing indexes, an -insert of new rows for which the key columns are larger than half of the index -page size causes the insert to fail.

Avoid creating indexes on long -columns. Create indexes on small columns that provide a quick look-up to larger, -unwieldy data in the row. You might not see performance improvements if you -index long columns. For information about indexes, see .

-
System shutdowns

The system shuts down if the database -log cannot allocate more disk space.

A "LogFull" error or some sort -of IOException occurs in the derby.log file -when the system runs out of space. If the system has no more disk space to -append to the derby.log file, you might not see the error -messages.

+
    +
  • Indexes are not supported for columns defined on CLOB, BLOB, and LONG +VARCHAR data types.

    If the length of the key columns in an index +is larger than half the page size of the index, creating an index on those +key columns for the table fails. For existing indexes, an insert of new rows +for which the key columns are larger than half of the index page size causes +the insert to fail.

    It is generally not recommended to create indexes +on long columns. It is best to create indexes on small columns that provide +a quick look-up to larger, unwieldy data in the row. You might not see performance +improvements if you index long columns. For information about indexes, see .

  • +
  • The system shuts down if the database log cannot allocate more disk +space.

    A "LogFull" error or some sort of IOException will +occur in the derby.log if the system runs out of space. If the system +has no more disk space to append to the derby.log, you might not see +the error messages.

  • +
Modified: db/derby/docs/trunk/src/devguide/cdevstandards805975.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/devguide/cdevstandards805975.dita?rev=434125&r1=434124&r2=434125&view=diff ============================================================================== --- db/derby/docs/trunk/src/devguide/cdevstandards805975.dita (original) +++ db/derby/docs/trunk/src/devguide/cdevstandards805975.dita Wed Aug 23 11:57:19 2006 @@ -1,5 +1,5 @@ - + -CLOB and BLOB +CLOB, and BLOB supports the standard CLOB and BLOB data types. BLOB and CLOB values are limited to a maximum of 2,147,483,647 characters. - -data typesCLOBdata -typesBLOB - + Modified: db/derby/docs/trunk/src/devguide/derbydev.ditamap URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/devguide/derbydev.ditamap?rev=434125&r1=434124&r2=434125&view=diff ============================================================================== --- db/derby/docs/trunk/src/devguide/derbydev.ditamap (original) +++ db/derby/docs/trunk/src/devguide/derbydev.ditamap Wed Aug 23 11:57:19 2006 @@ -1817,7 +1817,7 @@ - + @@ -1840,7 +1840,7 @@ - + @@ -1862,7 +1862,7 @@ - + @@ -1883,7 +1883,7 @@ - + @@ -1903,7 +1903,7 @@ - + @@ -1921,7 +1921,7 @@ - + @@ -1937,7 +1937,7 @@ - + @@ -1963,7 +1963,7 @@ - + @@ -1971,7 +1971,7 @@ - + @@ -1997,13 +1997,6 @@ - - - - - - - @@ -2442,26 +2435,24 @@ - - - - - - - - - + - - + + - + + + + + + +