db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r713746 [1/3] - /db/derby/docs/trunk/src/ref/
Date Thu, 13 Nov 2008 16:09:46 GMT
Author: chaase3
Date: Thu Nov 13 08:09:44 2008
New Revision: 713746

URL: http://svn.apache.org/viewvc?rev=713746&view=rev
Log:
DERBY-2389: Move Derby system and properties info from Tuning Guide into Reference Manual

This patch adds the system properties reference topics to the Reference Manual and fixes references to the topics within the Reference Manual.

Patch: DERBY-2389-ref.diff

Added:
    db/derby/docs/trunk/src/ref/crefproper22250.dita   (with props)
    db/derby/docs/trunk/src/ref/crefproper51399.dita   (with props)
    db/derby/docs/trunk/src/ref/crefproperdynstat.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper10607.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper13217.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper13766.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper18151.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper23835.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper24390.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper24846.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper25025.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper25581.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper26978.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper26985.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper27355.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper27467.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper27529.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper28026.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper32066.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper32213.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper33027.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper34037.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper35028.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper37341.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper39325.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper40346.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper40688.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper43414.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper43517.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper46141.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper81359.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper81405.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproper98166.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproperauthdn.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproperauthpw.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproperbootall.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefpropercachedn.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproperdurability.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproperlogbuffersize.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefpropermaxlogshippinginterval.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproperminlogshippinginterval.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefpropernoautoboot.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproperrowlocking.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefpropersqlauth.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproperstormin.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproperverbose.dita   (with props)
    db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita   (with props)
Modified:
    db/derby/docs/trunk/src/ref/crefmpref23947.dita
    db/derby/docs/trunk/src/ref/refderby.ditamap
    db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita
    db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita
    db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita
    db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
    db/derby/docs/trunk/src/ref/rrefsqljgrant.dita
    db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita
    db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita

Modified: db/derby/docs/trunk/src/ref/crefmpref23947.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/crefmpref23947.dita?rev=713746&r1=713745&r2=713746&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/crefmpref23947.dita (original)
+++ db/derby/docs/trunk/src/ref/crefmpref23947.dita Thu Nov 13 08:09:44 2008
@@ -37,15 +37,23 @@
 about <ph conref="../conrefs.dita#prod/productshortname"></ph> exception messages.</p></li>
 <li><i><xref href="crefjdbc12657.dita#crefjdbc12657"></xref></i>   <p>Information
 about <ph conref="../conrefs.dita#prod/productshortname"></ph>'s implementation
-of the JDBC interface including support for JDBC 2.0 features.</p></li>
+of the Java Database Connectivity (JDBC) API.</p></li>
 <li><i><xref href="rrefattrib24612.dita#rrefattrib24612"></xref></i>   <p>Information
 about the supported attributes to <ph conref="../conrefs.dita#prod/productshortname"></ph>'s
 JDBC database connection URL.</p></li>
+<li><i><xref href="rrefproper32213.dita#rrefproper32213"></xref></i>
+<p>Information about <ph conref="../conrefs.dita#prod/productshortname"></ph>
+properties.</p></li>
 <li><i><xref href="rrefjta16677.dita#rrefjta16677"></xref></i>   <p>Information
-about the supported attributes to <ph conref="../conrefs.dita#prod/productshortname"></ph>'s
-support for the Java Transaction API.</p></li>
+about <ph conref="../conrefs.dita#prod/productshortname"></ph>'s support for the
+Java EE platform, in particular support for the Java Transaction API and the
+JDBC API.</p></li>
 <li><i><xref href="rrefapi10613.dita#rrefapi10613"></xref></i>   <p>Notes
 about proprietary APIs for <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p></li>
+<li><i><xref href="rrefsqlj75638.dita#rrefsqlj75638"></xref></i>  <p>Territories
+supported by <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p></li>
+<li><i><xref href="rreflimits.dita#rreflimits"></xref></i>  <p>Limitations
+of <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p></li>
 </ul></p>
 </conbody>
 </concept>

Added: db/derby/docs/trunk/src/ref/crefproper22250.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/crefproper22250.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/crefproper22250.dita (added)
+++ db/derby/docs/trunk/src/ref/crefproper22250.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,302 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<concept id="crefproper22250" xml:lang="en-us">
+<title>Derby properties</title>
+<shortdesc>The <ph conref="../conrefs.dita#prod/productshortname"></ph> properties
+are used for configuring the system and database, as well as for diagnostics
+such as logging statements, and monitoring and tracing locks.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm><indexterm>properties</indexterm>overview, Derby</indexterm>
+</keywords>
+</metadata></prolog>
+<conbody>
+<p>The table
+<xref href="crefproper22250.dita#crefproper22250/rrefproper24108"></xref> lists
+all the core <ph conref="../conrefs.dita#prod/productshortname"></ph>
+properties.</p>
+<p>For information on how to set
+<ph conref="../conrefs.dita#prod/productshortname"></ph> properties, see
+"Ways of setting Derby properties" in
+<ph conref="../conrefs.dita#pub/cittuning"></ph>.</p>
+<note>When
+setting properties that have boolean values, be sure to trim extra spaces
+around the word <i>true</i>. Extra spaces around the word <i>true</i> cause
+the property to be set to false, regardless of its previous setting.</note>
+<p>To disable or turn off a database-wide property setting, set its value to
+null. To determine the result of this action, recall that the search order for
+properties is as follows (as stated in "Precedence of properties" in 
+<ph conref="../conrefs.dita#pub/cittuning"></ph>).</p>
+<ol>
+<li>[*] System-wide properties set programmatically (as a command-line option
+to the JVM when starting the application or within application code)</li>
+<li>Database-wide properties</li>
+<li>[*] System-wide properties set in the <i>derby.properties</i> file</li>
+</ol><p>[*] Not consulted if
+<i><xref href="rrefproper24390.dita#rrefproper24390"></xref></i> is set to true.</p>
+<p>Setting the database-wide property to null has the effect of removing the
+property from the list of database properties and restoring the system property
+setting from <i>derby.properties</i> if there is one. As always, if no value can
+be determined from the search, the built-in default applies.</p>
+<p>For example, the following code fragment turns off a previous database-wide
+setting of the <i><xref href="rrefproper25025.dita#rrefproper25025"></xref></i>
+property:</p>
+<codeblock>Statement s = conn.createStatement();
+s.executeUpdate("CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(" +
+    "'derby.database.fullAccessUsers', null)");</codeblock>
+<p>If the property is a static one, the null setting does not take effect until
+you reboot the database. Moreover, the static property
+<i><xref href="rrefpropersqlauth.dita#rrefpropersqlauth"></xref></i> cannot be
+disabled after it has been enabled, even with a reboot.</p>
+<p><xref href="crefproper22250.dita#crefproper22250/rrefproper24108"></xref> summarizes
+the general <ph conref="../conrefs.dita#prod/productshortname"></ph> properties.
+In this table, S stands for system-wide, D stands for database-wide, and C
+indicates the value persists with newly created conglomerates. X means yes.
+  <table frame="all" id="rrefproper24108" pgwide="0"><title>Derby properties</title>
+<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="50*"/>
+<colspec colname="2" colnum="2" colwidth="12*"/><colspec colname="3" colnum="3"
+colwidth="38*"/>
+<thead>
+<row>
+<entry colname="1">Property</entry>
+<entry colname="2">Scope</entry>
+<entry colname="3">Dynamic</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="1"><i><xref href="rrefproperauthdn.dita#rrefproperauthdn">derby.authentication.ldap.searchAuthDN</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproperauthpw.dita#rrefproperauthpw">derby.authentication.ldap.searchAuthPW</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper26978.dita#rrefproper26978">derby.authentication.ldap.searchBase</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper37341.dita#rrefproper37341">derby.authentication.ldap.searchFilter</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper13766.dita#rrefproper13766">derby.authentication.provider</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper25581.dita#rrefproper25581">derby.authentication.server</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper27467.dita#rrefproper27467">derby.connection.requireAuthentication</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper24846.dita#rrefproper24846">derby.database.defaultConnectionMode</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X<xref href="crefproper22250.dita#crefproper22250/rrefproper97948">*</xref></entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper81405.dita#rrefproper81405">derby.database.forceDatabaseLock</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper25025.dita#rrefproper25025">derby.database.fullAccessUsers</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X<xref href="crefproper22250.dita#crefproper22250/rrefproper97948">*</xref></entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefpropernoautoboot.dita#rrefpropernoautoboot">derby.database.noAutoBoot</xref></i></entry>
+<entry colname="2">D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper24390.dita#rrefproper24390">derby.database.propertiesOnly</xref></i></entry>
+<entry colname="2">D</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper39325.dita#rrefproper39325">derby.database.readOnlyAccessUsers</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X<xref href="crefproper22250.dita#crefproper22250/rrefproper97948">*</xref></entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefpropersqlauth.dita#rrefpropersqlauth">derby.database.sqlAuthorization</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper13217.dita#rrefproper13217">derby.infolog.append</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproperxatrantimeout.dita#rrefproperxatrantimeout">derby.jdbc.xaTransactionTimeout</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper43414.dita#rrefproper43414">derby.language.logQueryPlan</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper43517.dita#rrefproper43517">derby.language.logStatementText</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper10607.dita#rrefproper10607">derby.locks.deadlockTimeout</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper23835.dita#rrefproper23835">derby.locks.deadlockTrace</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper40346.dita#rrefproper40346">derby.locks.escalationThreshold</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper98166.dita#rrefproper98166">derby.locks.monitor</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper46141.dita#rrefproper46141">derby.locks.waitTimeout</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproperlogbuffersize.dita#rrefproperlogbuffersize">derby.replication.logBufferSize</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefpropermaxlogshippinginterval.dita#rrefpropermaxlogshippinginterval">derby.replication.maxLogShippingInterval</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproperminlogshippinginterval.dita#rrefproperminlogshippinginterval">derby.replication.minLogShippingInterval</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproperverbose.dita#rrefproperverbose">derby.replication.verbose</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper27529.dita#rrefproper27529">derby.storage.initialPages</xref></i></entry>
+<entry colname="2">C</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproperstormin.dita#rrefproperstormin">derby.storage.minimumRecordSize</xref></i></entry>
+<entry colname="2">S, D, C</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper81359.dita#rrefproper81359">derby.storage.pageCacheSize</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper28026.dita#rrefproper28026">derby.storage.pageReservedSpace</xref></i></entry>
+<entry colname="2">S, D, C</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper40688.dita#rrefproper40688">derby.storage.pageSize</xref></i></entry>
+<entry colname="2">S, D, C</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproperrowlocking.dita#rrefproperrowlocking">derby.storage.rowLocking</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper34037.dita#rrefproper34037">derby.storage.tempDirectory</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper33027.dita#rrefproper33027">derby.stream.error.field</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper18151.dita#rrefproper18151">derby.stream.error.file</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper35028.dita#rrefproper35028">derby.stream.error.method</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper26985.dita#rrefproper26985">derby.stream.error.logSeverityLevel</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproperbootall.dita#rrefproperbootall">derby.system.bootAll</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproperdurability.dita#rrefproperdurability">derby.system.durability</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper32066.dita#rrefproper32066">derby.system.home</xref></i></entry>
+<entry colname="2">S</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
+<entry colname="1"><i><xref href="rrefproper27355.dita#rrefproper27355">derby.user.UserName</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">X</entry>
+</row>
+</tbody>
+</tgroup>
+</table></p>
+<p id="rrefproper97948">* See the main page for this property for information
+about when changes to the property are dynamic.</p>
+<p>There are additional properties associated with the <ph conref="../conrefs.dita#prod/productshortname"></ph> tools.
+For more information about tool-specific properties, see the <ph conref="../conrefs.dita#pub/citutilities"></ph>.</p>
+</conbody>
+</concept>

Propchange: db/derby/docs/trunk/src/ref/crefproper22250.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/crefproper51399.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/crefproper51399.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/crefproper51399.dita (added)
+++ db/derby/docs/trunk/src/ref/crefproper51399.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,47 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<concept id="crefproper51399" xml:lang="en-us">
+<title>Scope of Derby properties</title>
+<prolog></prolog>
+<conbody>
+<p>A property in <ph conref="../conrefs.dita#prod/productshortname"></ph> belongs
+to one or more of these scopes:<ul id="i1008301">
+<li id="rrefproper41229"><i>system-wide</i>   <p>System-wide properties apply
+to an entire system, including all its databases and tables if applicable.</p>
+<ul compact="yes">
+<li>Set programmatically<p>System-wide properties set
+programmatically have precedence over database-wide properties and system-wide
+properties set in the <i>derby.properties</i> file.</p></li>
+<li>Set in the <i>derby.properties</i> file<p>The <i>derby.properties</i> file
+is an optional file that can be created to set properties at the system level
+when the <ph conref="../conrefs.dita#prod/productshortname"></ph> driver is
+loaded. <ph conref="../conrefs.dita#prod/productshortname"></ph> looks for
+this file in the directory defined by the derby.system.home property. Any
+property except derby.system.home can be set by including it in the <i>derby.properties</i> file.</p></li>
+</ul></li>
+<li id="rrefproper15705"><i>database-wide</i>   <p>A database-wide property
+is stored in a database and is valid for that specific database only.</p><note>Database-wide
+properties are stored in the database and are simpler for deployment. System-wide
+parameters are probably easier for development.</note></li>
+</ul></p>
+<p>For more information about scopes, precedence, and persistence, see
+"Properties overview" in <ph conref="../conrefs.dita#pub/cittuning"></ph>.</p>
+</conbody>
+</concept>

Propchange: db/derby/docs/trunk/src/ref/crefproper51399.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/crefproperdynstat.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/crefproperdynstat.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/crefproperdynstat.dita (added)
+++ db/derby/docs/trunk/src/ref/crefproperdynstat.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,53 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE concept PUBLIC "-//OASIS//DTD DITA Concept//EN" "../dtd/concept.dtd">
+<concept xml:lang="en-us" id="crefproperdynstat">
+<title>Dynamic and static properties</title>
+<prolog><metadata>
+<keywords>
+<indexterm>Static properties</indexterm>
+<indexterm>Dynamic properties</indexterm>
+<indexterm>Properties<indexterm>dynamic versus static</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog>
+<conbody>
+<p>Most properties are dynamic; that means you can set them while
+<ph conref="../conrefs.dita#prod/productshortname"></ph> is running, and their
+values change without requiring a reboot of
+<ph conref="../conrefs.dita#prod/productshortname"></ph>. In some cases, this
+change takes place immediately; in some cases, it takes place at the next
+connection.</p>
+<p>Some properties are static, which means changes to their values will not
+take effect while <ph conref="../conrefs.dita#prod/productshortname"></ph> is
+running. You must restart or set them before (or while) starting
+<ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<note>Properties set in the <i>derby.properties</i> file and on the command line
+of the application that boots
+<ph conref="../conrefs.dita#prod/productshortname"></ph> are <i>always</i>
+static, because <ph conref="../conrefs.dita#prod/productshortname"></ph> reads
+this file and those parameters only at startup.</note>
+<p>Only properties set in the following ways have the potential to be
+dynamic:</p>
+<ul>
+<li>As database-wide properties</li>
+<li>As system-wide properties via a <i>Properties</i> object in the application
+in which the <ph conref="../conrefs.dita#prod/productshortname"></ph> engine is
+embedded</li>
+</ul>
+</conbody></concept>

Propchange: db/derby/docs/trunk/src/ref/crefproperdynstat.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=713746&r1=713745&r2=713746&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Thu Nov 13 08:09:44 2008
@@ -610,6 +610,89 @@
 <topicref href="rrefattrib34183.dita" navtitle="Creating a connection without specifying attributes">
 </topicref>
 </topicref>
+<topicref collection-type="family" href="rrefproper32213.dita" navtitle="Derby properties">
+<topicref href="crefproper51399.dita" navtitle="Scope of Derby properties">
+</topicref>
+<topicref href="crefproperdynstat.dita" navtitle="Dynamic and static properties">
+</topicref>
+<topicref collection-type="family" href="crefproper22250.dita" navtitle="Derby properties">
+<topicref href="rrefproperauthdn.dita" navtitle="derby.authentication.ldap.searchAuthDN">
+</topicref>
+<topicref href="rrefproperauthpw.dita" navtitle="derby.authentication.ldap.searchAuthPW">
+</topicref>
+<topicref href="rrefproper26978.dita" navtitle="derby.authentication.ldap.searchBase">
+</topicref>
+<topicref href="rrefproper37341.dita" navtitle="derby.authentication.ldap.searchFilter">
+</topicref>
+<topicref href="rrefproper13766.dita" navtitle="derby.authentication.provider">
+</topicref>
+<topicref href="rrefproper25581.dita" navtitle="derby.authentication.server">
+</topicref>
+<topicref href="rrefproper27467.dita" navtitle="derby.connection.requireAuthentication">
+</topicref>
+<topicref href="rrefproper24846.dita" navtitle="derby.database.defaultConnectionMode">
+</topicref>
+<topicref href="rrefproper81405.dita" navtitle="derby.database.forceDatabaseLock">
+</topicref>
+<topicref href="rrefproper25025.dita" navtitle="derby.database.fullAccessUsers">
+</topicref>
+<topicref href="rrefpropernoautoboot.dita" navtitle="derby.database.noAutoBoot">
+</topicref>
+<topicref href="rrefproper24390.dita" navtitle="derby.database.propertiesOnly">
+</topicref>
+<topicref href="rrefproper39325.dita" navtitle="derby.database.readOnlyAccessUsers">
+</topicref>
+<topicref href="rrefpropersqlauth.dita" navtitle="derby.database.sqlAuthorization">
+</topicref>
+<topicref href="rrefproper13217.dita" navtitle="derby.infolog.append"></topicref>
+<topicref href="rrefproperxatrantimeout.dita" navtitle="derby.jdbc.xaTransactionTimeout"></topicref>
+<topicref href="rrefproper43414.dita" navtitle="derby.language.logQueryPlan">
+</topicref>
+<topicref href="rrefproper43517.dita" navtitle="derby.language.logStatementText">
+</topicref>
+<topicref href="rrefproper10607.dita" navtitle="derby.locks.deadlockTimeout">
+</topicref>
+<topicref href="rrefproper23835.dita" navtitle="derby.locks.deadlockTrace">
+</topicref>
+<topicref href="rrefproper40346.dita" navtitle="derby.locks.escalationThreshold">
+</topicref>
+<topicref href="rrefproper98166.dita" navtitle="derby.locks.monitor"></topicref>
+<topicref href="rrefproper46141.dita" navtitle="derby.locks.waitTimeout">
+</topicref>
+<topicref href="rrefproperlogbuffersize.dita" navtitle="derby.replication.logBufferSize"></topicref>
+<topicref href="rrefpropermaxlogshippinginterval.dita" navtitle="derby.replication.maxLogShippingInterval"></topicref>
+<topicref href="rrefproperminlogshippinginterval.dita" navtitle="derby.replication.minLogShippingInterval"></topicref>
+<topicref href="rrefproperverbose.dita" navtitle="derby.replication.verbose"></topicref>
+<topicref href="rrefproper27529.dita" navtitle="derby.storage.initialPages">
+</topicref>
+<topicref href="rrefproperstormin.dita" navtitle="derby.storage.minimumRecordSize">
+</topicref>
+<topicref href="rrefproper81359.dita" navtitle="derby.storage.pageCacheSize">
+</topicref>
+<topicref href="rrefproper28026.dita" navtitle="derby.storage.pageReservedSpace">
+</topicref>
+<topicref href="rrefproper40688.dita" navtitle="derby.storage.pageSize"></topicref>
+<topicref href="rrefproperrowlocking.dita" navtitle="derby.storage.rowLocking"></topicref>
+<topicref href="rrefproper34037.dita" navtitle="derby.storage.tempDirectory">
+</topicref>
+<topicref href="rrefproper33027.dita" navtitle="derby.stream.error.field">
+</topicref>
+<topicref href="rrefproper18151.dita" navtitle="derby.stream.error.file">
+</topicref>
+<topicref href="rrefproper35028.dita" navtitle="derby.stream.error.method">
+</topicref>
+<topicref href="rrefproper26985.dita" navtitle="derby.stream.error.logSeverityLevel">
+</topicref>
+<topicref href="rrefproperbootall.dita" navtitle="derby.system.bootAll">
+</topicref>
+<topicref href="rrefproperdurability.dita" navtitle="derby.system.durability">
+</topicref>
+<topicref href="rrefproper32066.dita" navtitle="derby.system.home"></topicref>
+<topicref href="rrefproper27355.dita" navtitle="derby.user.UserName">
+<topicref href="rrefpropercachedn.dita" navtitle="Caching user DNs"></topicref>
+</topicref>
+</topicref>
+</topicref>
 <topicref collection-type="family" href="rrefjta16677.dita" navtitle="J2EE Compliance: Java Transaction API and javax.sql Interfaces">
 <topicref collection-type="family" href="rrefjta51021.dita" navtitle="The JTA API ">
 <topicref collection-type="family" href="rrefjta1003392.dita" navtitle="Notes on Product Behavior">

Modified: db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita?rev=713746&r1=713745&r2=713746&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefgetuseraccess.dita Thu Nov 13 08:09:44 2008
@@ -25,9 +25,9 @@
 returns the current connection access permission for the user specified.</p><p>If
 no permission is explicitly set for the user, the access permission for the
 user is the value of the default connection mode. The default connection mode
-is set by using the <codeph>derby.database.defaultConnectionMode</codeph> property.
-See "Derby properties" in <cite><ph conref="../conrefs.dita#pub/cittuning"></ph></cite> for
-more information about this property.</p></section>
+is set by using the
+<codeph><xref href="rrefproper24846.dita#rrefproper24846">derby.database.defaultConnectionMode</xref></codeph>
+property.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_GET_USER_ACCESS (USERNAME VARCHAR(128)) RETURNS VARCHAR(128)</codeblock><dl>
 <dlentry>
 <dt>USERNAME</dt>
@@ -35,9 +35,12 @@
 conref="../conrefs.dita#prod/productshortname"></ph> database. </dd>
 </dlentry></dl><p>The value that is returned by this function is either <codeph>fullAccess</codeph>, <codeph>readOnlyAccess</codeph>,
 or <codeph>noAccess</codeph>.</p><p>A return value of <codeph>noAccess</codeph> means
-that the connection attempt by the user will be denied because neither the <varname>derby.database.fullAccessUsers</varname> property
-or the <varname>derby.database.readOnlyAccessUsers</varname> property is set
-for the user, and the <varname>derby.database.defaultConnectionMode</varname> property
+that the connection attempt by the user will be denied because neither the
+<codeph><xref href="rrefproper25025.dita#rrefproper25025">derby.database.fullAccessUsers</xref></codeph>
+property nor the
+<codeph><xref href="rrefproper39325.dita#rrefproper39325">derby.database.readOnlyAccessUsers</xref></codeph>
+property is set
+for the user, and the <codeph>derby.database.defaultConnectionMode</codeph> property
 is set to <codeph>noAccess</codeph>.</p><p>The names of the connection permissions
 match the existing names in use by <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p></section>
 <section><title>Example</title> <codeblock>VALUES SYSCS_UTIL.SYSCS_GET_USER_ACCESS ('BRUNNER')</codeblock></section>

Added: db/derby/docs/trunk/src/ref/rrefproper10607.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper10607.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper10607.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper10607.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper10607">
+<title>derby.locks.deadlockTimeout</title>
+<prolog><metadata>
+<keywords><indexterm>derby.locks.deadlockTimeout</indexterm><indexterm>Deadlocks<indexterm>timeout property</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Determines the number of seconds after which
+<ph conref="../conrefs.dita#prod/productshortname"></ph> checks whether a
+transaction waiting to obtain a lock is involved in a deadlock. If a deadlock
+has occurred, and <ph conref="../conrefs.dita#prod/productshortname"></ph>
+chooses the transaction as a deadlock victim,
+<ph conref="../conrefs.dita#prod/productshortname"></ph> aborts the transaction.
+The transaction receives an <i>SQLException</i> of <i>SQLState</i> 40001. If the
+transaction is not chosen as the victim, it continues to wait for a lock if
+<i><xref href="rrefproper46141.dita#rrefproper46141">derby.locks.waitTimeout</xref></i>
+is set to a higher value than the value of <i>derby.locks.deadlockTimeout</i>.
+</p>
+<p>If this property is set to a higher value than
+<i>derby.locks.waitTimeout</i>, no deadlock checking occurs. See
+<i><xref href="rrefproper46141.dita#rrefproper46141">derby.locks.waitTimeout</xref>.</i></p>
+<p>For more information about deadlock checking, see "Deadlocks" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph>.</p>
+</section>
+<section><title>Default</title>
+<p>20 seconds.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>derby.locks.deadlockTimeout=30
+<ph>-- database-wide property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.locks.deadlockTimeout', '30')</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>Dynamic; the change takes effect immediately. For information about dynamic
+changes to properties, see
+<xref href="crefproperdynstat.dita#crefproperdynstat"/>.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper10607.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper13217.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper13217.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper13217.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper13217.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper13217">
+<title>derby.infolog.append</title>
+<prolog><metadata>
+<keywords><indexterm>derby.infolog.append</indexterm>
+<indexterm>Information log<indexterm>overwriting</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Specifies whether to append to or overwrite (delete and recreate) the
+<i>derby.log</i> file when the
+<ph conref="../conrefs.dita#prod/productshortname"></ph> engine is started. The
+<i>derby.log</i> file is used to record errors and other information. This
+information can help you debug problems within a system.</p>
+<p>You can set this property even if the file does not yet exist;
+<ph conref="../conrefs.dita#prod/productshortname"></ph> creates the file.</p>
+</section>
+<section><title>Default</title>
+<p>False.</p>
+<p>By default, the file is deleted and then re-created.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>derby.infolog.append=true </b></codeblock>
+</example>
+<section><title>Scope</title>
+<p><xref href="crefproper51399.dita#crefproper51399/rrefproper41229">system-wide</xref></p>
+</section>
+<section><title>Dynamic or static</title>
+<p>This property is static; if you change it while
+<ph conref="../conrefs.dita#prod/productshortname"></ph> is running, the change
+does not take effect until you reboot.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper13217.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper13766.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper13766.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper13766.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper13766.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,84 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefproper13766" xml:lang="en-us">
+<title>derby.authentication.provider</title>
+<prolog><metadata>
+<keywords><indexterm>derby.authentication.provider</indexterm>
+<indexterm>Authentication provider<indexterm>specifying</indexterm></indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section><title>Function</title> <p>Specifies the authentication provider
+for <ph conref="../conrefs.dita#prod/productshortname"></ph> user
+authentication.</p>
+<p>Legal values include:</p>
+<ul>
+<li>LDAP   <p>An external LDAP directory service.</p></li>
+<li>BUILTIN   <p><ph conref="../conrefs.dita#prod/productshortname"></ph>'s
+simple internal user authentication repository.</p></li>
+<li>A complete Java class name   <p>A user-defined class that provides user
+authentication.</p></li>
+</ul>
+<p>When using an external authentication service provider (LDAP), you must also
+set:</p>
+<ul>
+<li><i><xref href="rrefproper25581.dita#rrefproper25581">derby.authentication.server</xref></i></li>
+</ul>
+<p>When using LDAP, you can set other LDAP-specific properties. See also:</p>
+<ul>
+<li><i><xref href="rrefproperauthdn.dita#rrefproperauthdn"></xref></i></li>
+<li><i><xref href="rrefproperauthpw.dita#rrefproperauthpw"></xref></i></li>
+<li><i><xref href="rrefproper37341.dita#rrefproper37341"></xref></i></li>
+<li><i><xref href="rrefproper26978.dita#rrefproper26978"></xref></i></li>
+</ul>
+<p>Alternatively, you can write your own class to provide a different external
+authentication service. This class must implement the public interface
+<i>org.apache.derby.authentication.UserAuthenticator</i> and throw exceptions
+of the type <i>java.sql.SQLException</i> where appropriate. Using a user-defined
+class makes <ph conref="../conrefs.dita#prod/productshortname"></ph> adaptable
+to various naming and directory services. For example, the class could allow
+<ph conref="../conrefs.dita#prod/productshortname"></ph> to hook up to an
+existing user authentication service that uses any of the standard directory and
+naming service providers to JNDI.</p>
+<p>To enable any <ph conref="../conrefs.dita#prod/productshortname"></ph> user
+authentication, you must set the
+<i><xref href="rrefproper27467.dita#rrefproper27467">derby.connection.requireAuthentication</xref></i>
+property to true.</p>
+<p>For more information about user authentication, see the <ph
+conref="../conrefs.dita#pub/citdevelop"></ph>.</p></section>
+<refsyn><title>Syntax</title>
+<codeblock><b>derby.authentication.provider={ LDAP | BUILTIN | <b><i>classProviderName</i></b> }</b></codeblock>
+</refsyn>
+<section><title>Default</title> <p>BUILTIN</p> </section>
+<example><title>Example</title> <codeblock><b>-- system-wide property
+derby.authentication.provider=LDAP
+-- database-wide property
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.authentication.provider',
+    'BUILTIN')</b></codeblock> </example>
+<section><title>Dynamic or static</title>
+<p>Static. For system-wide properties, you must reboot
+<ph conref="../conrefs.dita#prod/productshortname"></ph> for the change to take
+effect. For database-wide properties, you must reboot the database for the
+change to take effect.</p>
+</section>
+</refbody>
+</reference>
+

Propchange: db/derby/docs/trunk/src/ref/rrefproper13766.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper18151.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper18151.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper18151.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper18151.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,46 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper18151">
+<title>derby.stream.error.file</title>
+<prolog><metadata>
+<keywords><indexterm>derby.stream.error.file</indexterm>
+<indexterm>Error log<indexterm>specifying file name</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Specifies name of the file to which the error log is written. If the file
+name is relative, it is taken as relative to the system directory.</p>
+<p>If this property is set, the
+<i><xref href="rrefproper35028.dita#rrefproper35028">derby.stream.error.method</xref></i>
+and
+<i><xref href="rrefproper33027.dita#rrefproper33027">derby.stream.error.field</xref></i>
+properties are ignored.</p>
+</section>
+<section><title>Default</title>
+<p><i>derby.log</i>.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>derby.stream.error.file=error.txt</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>This property is static; if you change it while
+<ph conref="../conrefs.dita#prod/productshortname"></ph> is running, the change
+does not take effect until you reboot.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper18151.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper23835.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper23835.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper23835.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper23835.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,54 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper23835">
+<title>derby.locks.deadlockTrace</title>
+<prolog><metadata>
+<keywords><indexterm>derby.locks.deadlockTrace</indexterm>
+<indexterm>Deadlocks<indexterm>tracing</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Causes a detailed list of locks at the time of a deadlock or a timeout
+to be written to the error log (typically the file <i>derby.log</i>). For a
+deadlock, <ph conref="../conrefs.dita#prod/productshortname"></ph> describes the
+cycle of locks which caused the deadlock. For a timeout,
+<ph conref="../conrefs.dita#prod/productshortname"></ph> prints the entire lock
+list at the time of the timeout. This property is meaningful only if the
+<i><xref href="rrefproper98166.dita#rrefproper98166">derby.locks.monitor</xref></i>
+property is set to <i>true</i>.</p>
+<note>This level of debugging is intrusive: it can alter
+the timing of the application, reduce performance severely, and produce a
+large error log file. It should be used with care.</note>
+</section>
+<section><title>Default</title>
+<p>False.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>-- system property
+derby.locks.deadlockTrace=true
+
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.locks.deadlockTrace', 'true')</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>Dynamic; the change takes effect immediately. For information about dynamic
+changes to properties, see
+<xref href="crefproperdynstat.dita#crefproperdynstat"/>.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper23835.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper24390.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper24390.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper24390.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper24390.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper24390">
+<title>derby.database.propertiesOnly</title>
+<prolog><metadata>
+<keywords><indexterm>derby.database.propertiesOnly</indexterm>
+<indexterm>Database-wide properties<indexterm>protecting against
+overrides</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>When set to true, this property ensures that database-wide properties cannot
+be overridden by system-wide properties.</p>
+<p>When this property is set to false, or not set, database-wide properties can
+be overridden by system-wide properties (see "Precedence of properties" in
+<ph conref="../conrefs.dita#pub/cittuning"></ph>).</p>
+<p>This property ensures that a database's environment cannot be modified by the
+environment in which it is booted.</p>
+<p>This property can <i>never</i> be overridden by system properties.</p>
+</section>
+<section><title>Default</title>
+<p>False.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.database.propertiesOnly','true')</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>This property is dynamic; if you change it while
+<ph conref="../conrefs.dita#prod/productshortname"></ph> is running, the change
+takes effect immediately. For information about dynamic changes to properties,
+see <xref href="crefproperdynstat.dita#crefproperdynstat"/>.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper24390.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper24846.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper24846.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper24846.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper24846.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,68 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper24846">
+<title>derby.database.defaultConnectionMode</title>
+<prolog><metadata>
+<keywords><indexterm>derby.database. defaultConnectionMode</indexterm>
+<indexterm>User authorization<indexterm>configuring</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>One of the user authorization properties.</p>
+<p>Defines the default connection mode for users of the database or system
+for which this property is set. The possible values (which are case-insensitive)
+are:</p>
+<ul>
+<li><i>noAccess</i>  
+<p>Disallows connections.</p></li>
+<li><i>readOnlyAccess</i>  
+<p>Grants read-only connections.</p></li>
+<li><i>fullAccess</i>  
+<p>Grants full access.</p></li>
+</ul>
+<p>If the property is set to an invalid value, an exception is raised.</p> 
+<note>It is possible to configure a database so that it cannot be changed
+(or even accessed) using this property. If you set this property to
+<i>noAccess</i> or <i>readOnlyAccess</i>, be sure to allow at least one user
+full access. See <i><xref href="rrefproper25025.dita#rrefproper25025"/></i> and
+<i><xref href="rrefproper39325.dita#rrefproper39325"/>.</i></note>
+<p>For more information about user authorization, see "User Authorization"
+in the <cite><ph conref="../conrefs.dita#pub/citdevelop"></ph></cite>.</p> 
+</section>
+<refsyn><title>Syntax</title>
+<codeblock><b>CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.database.defaultConnectionMode', 
+    '{ noAccess | readOnlyAccess | fullAccess}')</b></codeblock>
+</refsyn>
+<example><title>Example</title>
+<codeblock><b>-- database-wide property
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.database.defaultConnectionMode', 'noAccess')
+-- system-wide property
+derby.database.defaultConnectionMode=noAccess</b></codeblock>
+</example>
+<section><title>Default</title>
+<p><i>fullAccess</i></p>
+</section>
+<section><title>Dynamic or static</title>
+<p>Dynamic. Current connections are not affected, but all future connections
+are affected. For information about dynamic changes to properties, see
+<xref href="crefproperdynstat.dita#crefproperdynstat"/>.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper24846.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper25025.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper25025.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper25025.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper25025.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,60 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper25025">
+<title>derby.database.fullAccessUsers</title>
+<prolog><metadata>
+<keywords><indexterm>derby.database.fullAccessUsers</indexterm>
+<indexterm>User authorization<indexterm>configuring</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>One of the user authorization properties. Specifies a list of users to
+which full (read-write) access to a database is granted. The list consists
+of user names separated by commas. Do not put spaces after commas.</p>
+<p>When set as a system property, specifies a list of users for which full
+access to all the databases in the system is granted.</p>
+<p>See also <i><xref href="rrefproper39325.dita#rrefproper39325"/>.</i></p>
+<p>A malformed list of user names raises an exception. Do not specify a user
+both with this property and in <i>derby.database.readOnlyAccessUsers</i>.</p>
+<note>User names, called authorization identifiers,
+follow the rules of <i>SQL92Identifiers</i> and can be delimited.
+Specifying a user name that does not follow these rules raises an
+exception.</note>
+<p>For more information about user authorization, see "User Authorization"
+in the <cite><ph conref="../conrefs.dita#pub/citdevelop"></ph></cite>.</p>
+</section>
+<refsyn><title>Syntax</title>
+<codeblock><b>-- database-level property
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.database.fullAccessUsers',
+    '<b><i>commaSeparatedlistOfUsers</i></b>')</b></codeblock>
+</refsyn>
+<example><title>Example</title>
+<codeblock><b>-- database-level property
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.database.fullAccessUsers', 'dba,fred,peter')
+--system-level property
+derby.database.fullAccessUsers=dba,fred,peter</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>Dynamic. Current connections are not affected, but all future connections
+are affected. For information about dynamic changes to properties, see
+<xref href="crefproperdynstat.dita#crefproperdynstat"/>.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper25025.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper25581.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper25581.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper25581.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper25581.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,72 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefproper25581" xml:lang="en-us">
+<title>derby.authentication.server</title>
+<prolog><metadata>
+<keywords><indexterm>derby.authentication.server</indexterm>
+<indexterm>LDAP<indexterm>configuring</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section><title>Function</title>
+<p>Specifies the location of the external directory service that provides user
+authentication for the <ph conref="../conrefs.dita#prod/productshortname"></ph>
+system as defined with
+<i><xref href="rrefproper13766.dita#rrefproper13766"/></i>. For LDAP, specify
+the host name and port number.</p>
+<p>The server must be known on the network.</p>
+<p>For more information about external user authentication, see "External
+directory service" in the <ph conref="../conrefs.dita#pub/citdevelop"></ph>.</p>
+</section>
+<section><title>Default</title>
+<p>Not applicable. Note that if the protocol type is unspecified, it defaults to
+LDAP.</p> </section>
+<refsyn><title>Syntax</title>
+<codeblock><b>derby.authentication.server=
+[{ ldap: | ldaps: | nisplus: }]
+[//]
+
+{
+<b><i>    hostname</i></b> [ :<b><i>portnumber </i></b>] |
+<b><i>    nisServerName</i></b>/<b><i>nisDomain</i></b>
+}</b></codeblock> </refsyn>
+<example><title>Example</title>
+<codeblock><b><ph>-- system-wide property
+##LDAP example</ph>
+derby.authentication.server=godfrey:9090
+<ph>##LDAP example</ph>
+derby.authentication.server=ldap://godfrey:9090
+<ph>##LDAP example</ph>
+derby.authentication.server=//godfrey:9090
+<ph>##LDAP over SSL example</ph>
+derby.authentication.server=ldaps://godfrey:636/
+<ph>-- database-wide property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.authentication.server',
+    'godfrey:9090')</b></codeblock> </example>
+<section><title>Dynamic or static</title>
+<p>Static. For system-wide properties, you must reboot
+<ph conref="../conrefs.dita#prod/productshortname"></ph> for the change to take
+effect. For database-wide properties, you must reboot the database for the
+change to take effect.</p> </section>
+</refbody>
+</reference>
+

Propchange: db/derby/docs/trunk/src/ref/rrefproper25581.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper26978.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper26978.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper26978.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper26978.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper26978">
+<title>derby.authentication.ldap.searchBase</title>
+<prolog><metadata>
+<keywords><indexterm>derby.authentication.ldap.searchbase</indexterm>
+<indexterm>LDAP<indexterm>configuring</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Specifies the root DN of the point in your hierarchy from which to begin
+a guest or anonymous search for the user's DN. For example:</p>
+<codeblock><b>ou=people,o=ExampleSite.com</b></codeblock>
+<p>When using Netscape Directory Server, set this property to the root DN,
+the special entry to which access control does not apply.</p>
+<p>For more information about LDAP user authentication, see the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph>.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b><ph>-- system-wide property</ph>
+derby.authentication.ldap.searchBase=
+    ou=people,o=ExampleSite.com
+<ph>-- database-wide property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.authentication.ldap.searchBase',
+    'ou=people,o=ExampleSite.com')</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>Static. For system-wide properties, you must reboot
+<ph conref="../conrefs.dita#prod/productshortname"></ph> for the change to take
+effect. For database-wide properties, you must reboot the database for the
+change to take effect.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper26978.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper26985.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper26985.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper26985.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper26985.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,65 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper26985">
+<title>derby.stream.error.logSeverityLevel</title>
+<prolog><metadata>
+<keywords><indexterm>derby.stream.error.logSeverityLevel</indexterm>
+<indexterm>Error log<indexterm>configuring severity of errors
+that appear in</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Specifies which errors are logged to the
+<ph conref="../conrefs.dita#prod/productshortname"></ph> error log (typically
+the <i>derby.log</i> file). In test environments, use the setting
+<i>derby.stream.error.logSeverityLevel=0</i> so that all problems are
+reported.</p>
+<p>Any error raised in a
+<ph conref="../conrefs.dita#prod/productshortname"></ph> system is given a level
+of severity. This property indicates the minimum severity necessary for an error
+to appear in the error log. The severities are defined in the class
+<i>org.apache.derby.types.ExceptionSeverity</i>. The higher the number, the more
+severe the error.</p>
+<ul>
+<li><i>20000</i>  
+<p>Errors that cause the statement to be rolled back, for example syntax errors
+and constraint violations.</p></li>
+<li><i>30000</i>  
+<p>Errors that cause the transaction to be rolled back, for example
+deadlocks.</p></li>
+<li><i>40000</i>  
+<p>Errors that cause the connection to be closed.</p></li>
+<li><i>50000</i>  
+<p>Errors that shut down the
+<ph conref="../conrefs.dita#prod/productshortname"></ph> system.</p></li>
+</ul>
+</section>
+<section><title>Default</title>
+<p>40000.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b><ph>// send errors of level 30000 and higher to the log</ph>
+derby.stream.error.logSeverityLevel=30000</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>This property is static; if you change it while
+<ph conref="../conrefs.dita#prod/productshortname"></ph> is running, the change
+does not take effect until you reboot.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper26985.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper27355.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper27355.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper27355.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper27355.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,93 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefproper27355" xml:lang="en-us">
+<title>derby.user.UserName</title>
+<prolog><metadata>
+<keywords><indexterm>derby.user</indexterm>
+<indexterm>Users<indexterm>creating</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section><title>Function</title>
+<p>Has two uses:</p>
+<ul>
+<li>Creates users and passwords when
+<i><xref href="rrefproper13766.dita#rrefproper13766">derby.authentication.provider</xref></i>
+is set to <i>BUILTIN</i>.</li>
+<li>Caches user DNs locally when <i>derby.authentication.provider</i> is set to
+<i>LDAP</i> and
+<i><xref href="rrefproper37341.dita#rrefproper37341">derby.authentication.ldap.searchFilter</xref></i>
+is set to <i>derby.user</i>.</li>
+</ul></section>
+<section><title>Users and Passwords</title>
+<p>This property creates valid clear-text users and passwords within
+<ph conref="../conrefs.dita#prod/productshortname"></ph> when the
+<i>derby.authentication.provider</i> property is set to <i>BUILTIN</i>. For
+information about users, see "Working with user authentication" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph>.</p>
+<ul>
+<li><i>Database-Level Properties</i>   <p>When you create users with
+database-level properties, those users are available to the specified database
+only.</p>
+<p>You set the property once for each user. To delete a user, set that user's
+password to null.</p></li>
+<li><i>System-Level Properties</i>   <p>When you create users with system-level
+properties, those users are available to all databases in the system.</p>
+<p>You set the value of this system-wide property once for each user, so you can
+set it several times. To delete a user, remove that user from the file.</p>
+<p>You can define this property in the usual ways -- typically in the
+<i>derby.properties</i> file.</p></li>
+</ul>
+<p>When a user name and its corresponding password are provided in the
+<i>DriverManager.getConnection</i> call,
+<ph conref="../conrefs.dita#prod/productshortname"></ph> validates them against
+the properties defined for the current system.</p>
+<p>User names are <i>SQL92Identifiers</i> and can be delimited.</p> </section>
+<refsyn><title>Syntax</title>
+<codeblock><b>derby.user.{<i>UserName</i>=<i>Password</i>} | <i>UserName=userDN</i> }</b></codeblock>
+<codeblock><b><ph>-- database-level property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.user.<i>UserName</i>',
+    '<i>Password | userDN</i>')</b></codeblock> </refsyn>
+<section><title>Default</title>
+<p>None.</p> </section>
+<example><title>Example</title>
+<codeblock><b><ph>-- system-level property</ph>
+derby.user.guest=java5w</b></codeblock>
+<codeblock><b>derby.user.sa=<ph conref="../conrefs.dita#prod/productshortname"></ph>3x9
+
+derby.user."!Amber"=java5w
+<ph>-- database-level property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.user.sa',
+    '<ph conref="../conrefs.dita#prod/productshortname"></ph>3x9')
+<ph>-- cache a userDN locally, database-level property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.user.richard',
+    'uid=richard, ou=People, o=ExampleSite.com')
+</b></codeblock> </example>
+<section><title>Dynamic or static</title>
+<p>Dynamic; the change takes effect immediately. For information about dynamic
+changes to properties, see
+<xref href="crefproperdynstat.dita#crefproperdynstat"/>.</p>
+</section>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper27355.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper27467.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper27467.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper27467.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper27467.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper27467">
+<title>derby.connection.requireAuthentication</title>
+<prolog><metadata>
+<keywords><indexterm>derby.connection. requireAuthentication</indexterm>
+<indexterm>Authentication<indexterm>turning on</indexterm></indexterm>
+<indexterm>User authentication<indexterm>turning on</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Turns on user authentication for
+<ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<p>When user authentication is turned on, a connection request must provide
+a valid user name and password.</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph> uses the type of
+user authentication specified with the
+<i><xref href="rrefproper13766.dita#rrefproper13766">derby.authentication.provider</xref></i>
+property.</p>
+<p>For more information about user authentication, see "Working with user
+authentication" in the <ph conref="../conrefs.dita#pub/citdevelop"></ph>.</p>
+</section>
+<section><title>Default</title>
+<p>False.</p>
+<p>By default, no user authentication is required.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b><ph>-- system-wide property</ph>
+derby.connection.requireAuthentication=true
+<ph>-- database-wide property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.connection.requireAuthentication',
+    'true')</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>Static. For system-wide properties, you must reboot
+<ph conref="../conrefs.dita#prod/productshortname"></ph> for the change to take
+effect. For database-wide properties, you must reboot the database for the
+change to take effect.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper27467.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper27529.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper27529.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper27529.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper27529.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,67 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper27529">
+<title>derby.storage.initialPages</title>
+<prolog><metadata>
+<keywords><indexterm>derby.storage.initialPages</indexterm>
+<indexterm>Database pages<indexterm>preallocating</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>The on-disk size of a
+<ph conref="../conrefs.dita#prod/productshortname"></ph> table grows by one page
+at a time until eight pages of user data (or nine pages of total disk use; one
+is used for overhead) have been allocated. Then it will grow by eight pages at a
+time if possible.</p>
+<p>A <ph conref="../conrefs.dita#prod/productshortname"></ph> table or index can
+be created with a number of pages already pre-allocated. To do so, specify the
+property prior to the CREATE TABLE or CREATE INDEX statement.</p>
+<p>Define the number of user pages the table or index is to be created with.
+The purpose of this property is to preallocate a table or index of reasonable
+size if the user expects that a large amount of data will be inserted into
+the table or index. A table or index that has the pre-allocated pages will
+enjoy a small performance improvement over a table or index that has no
+pre-allocated pages when the data are loaded.</p>
+<p>The total desired size of the table or index should be the following number
+of bytes:</p>  
+<codeblock><b>(1 + derby.storage.initialPages) * derby.storage.pageSize</b></codeblock>
+<p>When you create a table or an index after setting this property,
+<ph conref="../conrefs.dita#prod/productshortname"></ph> attempts to preallocate
+the requested number of user pages. However, the operations do not fail even if
+they are unable to preallocate the requested number of pages, as long as they
+allocate at least one page.</p>
+</section>
+<section><title>Default</title>
+<p>1 page.</p>
+</section>
+<section><title>Minimum value</title>
+<p>The minimum number of <i>initialPages</i> is 1.</p>
+</section>
+<section><title>Maximum value</title>
+<p>The maximum number of <i>initialPages</i> is 1000.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>-- system-wide property 
+derby.storage.initialPages=30
+
+-- database-wide property 
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 
+'derby.storage.initialPages', '30') </b></codeblock>
+</example></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper27529.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproper28026.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproper28026.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproper28026.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproper28026.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,64 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproper28026">
+<title>derby.storage.pageReservedSpace</title>
+<prolog><metadata>
+<keywords><indexterm>derby.storage.pageReservedSpace</indexterm>
+<indexterm>Reserving space on a page</indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Defines the percentage of space reserved for updates on an on-disk database
+page for tables only (not indexes); indicates the percentage of space to keep
+free on a page when inserting. Leaving reserved space on a page can minimize
+row overflow (and the associated performance hit) during updates. Once a page
+has been filled up to the reserved-space threshold, no new rows are allowed
+on the page. This reserved space is used only for rows that increase in size
+when updated, not for new inserts. Set this property prior to issuing the
+CREATE TABLE statement.</p>
+<p>Regardless of the value of <i>derby.storage.pageReservedSpace</i>, an empty
+page always accepts at least one row.</p>
+</section>
+<section><title>Valid conglomerates</title>
+<p>Tables only.</p>
+</section>
+<section><title>Default</title>
+<p>20%.</p>
+</section>
+<section><title>Minimum value</title>
+<p>The minimum value is 0% and the maximum is 100%. If you specify a value
+outside this range, <ph conref="../conrefs.dita#prod/productshortname"></ph>
+uses the default value of 20%.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b><ph>-- modifying the default for the system</ph>
+derby.storage.pageReservedSpace=40
+<ph>-- modifying the default for the database</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.storage.pageReservedSpace',
+    '40')
+</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>This property is dynamic: if you change it while
+<ph conref="../conrefs.dita#prod/productshortname"></ph> is running, the change
+takes effect immediately. For information about dynamic changes to properties,
+see <xref href="crefproperdynstat.dita#crefproperdynstat"/>.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproper28026.dita
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message