db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r708179 - in /db/derby/docs/trunk/src/tuning: ctunproper22250.dita ctunsetprop824500.dita
Date Mon, 27 Oct 2008 13:57:04 GMT
Author: chaase3
Date: Mon Oct 27 06:57:04 2008
New Revision: 708179

URL: http://svn.apache.org/viewvc?rev=708179&view=rev
Log:
DERBY-3847: Tuning Guide lacks information on turning off Derby property settings

Modified 2 files to add this information along with some clarifications.

Patch: DERBY-3847-5.diff

Modified:
    db/derby/docs/trunk/src/tuning/ctunproper22250.dita
    db/derby/docs/trunk/src/tuning/ctunsetprop824500.dita

Modified: db/derby/docs/trunk/src/tuning/ctunproper22250.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/ctunproper22250.dita?rev=708179&r1=708178&r2=708179&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tuning/ctunproper22250.dita (original)
+++ db/derby/docs/trunk/src/tuning/ctunproper22250.dita Mon Oct 27 06:57:04 2008
@@ -28,10 +28,41 @@
 </keywords>
 </metadata></prolog>
 <conbody>
-<p>This section includes all of the core <ph conref="../conrefs.dita#prod/productshortname"></ph>
properties. <note>When
+<p>The table
+<xref href="ctunproper22250.dita#ctunproper22250/rtunproper24108"></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
+<xref href="ctunsetprop24222.dita#ctunsetprop24222"></xref>.</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.</note></p>
+around the word <i>true</i>. Extra spaces around the word 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
+<xref href="ctunsetprop23308.dita#ctunsetprop23308"></xref>):</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
+<xref href="rtunproper24390.dita#rtunproper24390"></xref> 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>derby.database.fullAccessUsers</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
+<xref href="rtunpropersqlauth.dita#rtunpropersqlauth"></xref> cannot be disabled
+after it has been enabled, even with a reboot.</p>
 <p><xref href="ctunproper22250.dita#ctunproper22250/rtunproper24108"></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
@@ -114,6 +145,11 @@
 <entry colname="3">X<xref href="ctunproper22250.dita#ctunproper22250/rtunproper97948">*</xref></entry>
 </row>
 <row>
+<entry colname="1"><i><xref href="rtunpropersqlauth.dita#rtunpropersqlauth">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="rtunproper13217.dita#rtunproper13217">derby.infolog.append</xref></i></entry>
 <entry colname="2">S</entry>
 <entry colname="3">&nbsp;</entry>
@@ -254,6 +290,6 @@
 <p id="rtunproper97948">* 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 <i><ph conref="../conrefs.dita#pub/citutilities"></ph>
Guide</i>.</p>
+For more information about tool-specific properties, see the <ph conref="../conrefs.dita#pub/citutilities"></ph>.</p>
 </conbody>
 </concept>

Modified: db/derby/docs/trunk/src/tuning/ctunsetprop824500.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/ctunsetprop824500.dita?rev=708179&r1=708178&r2=708179&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tuning/ctunsetprop824500.dita (original)
+++ db/derby/docs/trunk/src/tuning/ctunsetprop824500.dita Mon Oct 27 06:57:04 2008
@@ -29,12 +29,18 @@
 stored in the database. Typically, it is in effect until you explicitly change
 the property or until you set a system-wide property with precedence over
 database-wide properties (see <xref href="ctunsetprop23308.dita#ctunsetprop23308"/>).</p>
+<p>To disable or turn off a database-wide property setting, set its value to
+null. This has the effect of removing the property from the list of database
+properties and restoring the system property setting, if there is one (and if
+<i>derby.database.propertiesOnly</i> has not been set; see
+<xref href="ctunsetprop824533.dita#ctunsetprop824533"></xref>).</p>
 <p>A system-wide property might have persistence, depending on how you set
 it. If you set it programmatically, it persists only for the duration of the
-JVM of the application that set it. If you set it in the <i>derby.properties</i>
file, a property persists until:  
+JVM of the application that set it. If you set it in the
+<i>derby.properties</i> file, a property persists until:</p>  
 <ul>
-<li>That value is changed </li>
-<li>The file is removed from the system</li>
+<li>That value is changed and the system is rebooted</li>
+<li>The file is removed from the system and the system is rebooted</li>
 <li>The database is booted outside of that system</li>
-</ul></p>
+</ul>
 </conbody></concept>



Mime
View raw message