Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 59304 invoked from network); 13 Nov 2008 16:10:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Nov 2008 16:10:10 -0000 Received: (qmail 33617 invoked by uid 500); 13 Nov 2008 16:10:18 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 33594 invoked by uid 500); 13 Nov 2008 16:10:18 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 33585 invoked by uid 99); 13 Nov 2008 16:10:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Nov 2008 08:10:18 -0800 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Nov 2008 16:09:05 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id D5D7C2388999; Thu, 13 Nov 2008 08:09:48 -0800 (PST) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r713746 [3/3] - /db/derby/docs/trunk/src/ref/ Date: Thu, 13 Nov 2008 16:09:46 -0000 To: derby-commits@db.apache.org From: chaase3@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20081113160948.D5D7C2388999@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Added: db/derby/docs/trunk/src/ref/rrefproperstormin.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproperstormin.dita?rev=713746&view=auto ============================================================================== --- db/derby/docs/trunk/src/ref/rrefproperstormin.dita (added) +++ db/derby/docs/trunk/src/ref/rrefproperstormin.dita Thu Nov 13 08:09:44 2008 @@ -0,0 +1,66 @@ + + + + +derby.storage.minimumRecordSize + +derby.storage.minimumRecordSize + + + +
Function +

Indicates the minimum user row size in bytes for on-disk database pages for +tables when you are creating a table. This property ensures that there is enough +room for a row to grow on a page when updated without having to overflow. This +is generally most useful for VARCHAR and VARCHAR FOR BIT DATA data types and for +tables that are updated a lot, in which the rows start small and grow due to +updates. Reserving the space at the time of insertion minimizes row overflow +due to updates, but it can result in wasted space. Set the property prior to +issuing the CREATE TABLE statement.

+

See also .

+
+
Valid conglomerates +

Tables only.

+
+
Default +

12 bytes.

+
+
Minimum value +

12 bytes.

+
+
Maximum value +

derby.storage.pageSize * (1 +- derby.storage.pageReservedSpace/100) " +100.

+

If you set this property to a value outside the legal range, uses +the default value.

+
+Example +-- changing the default for the system +derby.storage.minimumRecordSize=128 +-- changing the default for the database +CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( + 'derby.storage.minimumRecordSize', + '128') + + +
Dynamic or static +

This property is dynamic; if you change it while is running, +the change takes effect immediately. For information about dynamic changes +to properties, see .

+
Propchange: db/derby/docs/trunk/src/ref/rrefproperstormin.dita ------------------------------------------------------------------------------ svn:eol-style = native Added: db/derby/docs/trunk/src/ref/rrefproperverbose.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproperverbose.dita?rev=713746&view=auto ============================================================================== --- db/derby/docs/trunk/src/ref/rrefproperverbose.dita (added) +++ db/derby/docs/trunk/src/ref/rrefproperverbose.dita Thu Nov 13 08:09:44 2008 @@ -0,0 +1,44 @@ + + + + +derby.replication.verbose + +derby.replication.verbose +replicationspecifying message logging + + + +
Function +

Specifies whether replication messages are written to the + log.

+
+
Default +

True.

+
+Example +derby.replication.verbose=false + +
Scope +

system-wide

+
+
Dynamic or static +

This property is static; if you change it while + is running, the change +does not take effect until you reboot.

+
Propchange: db/derby/docs/trunk/src/ref/rrefproperverbose.dita ------------------------------------------------------------------------------ svn:eol-style = native Added: db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita?rev=713746&view=auto ============================================================================== --- db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita (added) +++ db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita Thu Nov 13 08:09:44 2008 @@ -0,0 +1,50 @@ + + + + +derby.jdbc.xaTransactionTimeout + +derby.jdbc.xaTransactionTimeout +XA Transactionstransaction timeout property + + + +
Function +

Specifies the default value of the XA transaction timeout that is used when +a user either does not specify the XA transaction timeout or requests to use the +default value. It is possible to use the +XAResource.setTransactionTimeout method to specify the XA +transaction timeout value for the global transaction.

+

A zero or negative value for this property means that the transaction timeout +is not used.

+
+
Default +

The transaction timeout is not used.

+
+Example +-- system-wide property +derby.jdbc.xaTransactionTimeout=120 +-- database-wide property +CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( + 'derby.jdbc.xaTransactionTimeout', '120') + +
Dynamic or static +

Dynamic; the change takes effect immediately. For information about dynamic +changes to properties, see +.

+
Propchange: db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita ------------------------------------------------------------------------------ svn:eol-style = native Modified: db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita?rev=713746&r1=713745&r2=713746&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita (original) +++ db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita Thu Nov 13 08:09:44 2008 @@ -23,14 +23,16 @@

Use the SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY system procedure to set or delete the value of a property of the database on the -current connection.

+current connection. For information about properties, see +.

If "VALUE" is not null, then the property with key value "KEY" is set to "VALUE". If "VALUE" is null, then the property with key value "KEY" is deleted from the database property set.

Syntax SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY(IN KEY VARCHAR(128), IN VALUE VARCHAR(32672))

This procedure does not return any results.

-
JDBC example

Set the derby.locks.deadlockTimeout property +

JDBC example

Set the +derby.locks.deadlockTimeout property to a value of 10:

CallableStatement cs = conn.prepareCall ("CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?, ?)"); cs.setString(1, "derby.locks.deadlockTimeout"); Modified: db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita?rev=713746&r1=713745&r2=713746&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita (original) +++ db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita Thu Nov 13 08:09:44 2008 @@ -33,11 +33,13 @@
Valid values for CONNECTION_PERMISSION are:
fullAccess
Adds the user to the list of users with full access to the database. The -value for the database property is derby.database.fullAccessUsers.
+value for the database property is +derby.database.fullAccessUsers.
readOnlyAccess
Adds the user to the list of users with read-only access to the database. -The value for the database property is derby.database.readOnlyAccessUsers.
+The value for the database property is +derby.database.readOnlyAccessUsers.
null
Removes the user from the list of permissions, reverting the user to the Modified: db/derby/docs/trunk/src/ref/rrefsqlj31580.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj31580.dita?rev=713746&r1=713745&r2=713746&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefsqlj31580.dita (original) +++ db/derby/docs/trunk/src/ref/rrefsqlj31580.dita Thu Nov 13 08:09:44 2008 @@ -35,7 +35,7 @@ schema name cannot exceed 128 characters. Schema names must be unique within the database.

The CREATE SCHEMA statement is subject to access control when the -derby.database.sqlAuthorization property is set to +derby.database.sqlAuthorization property is set to true for the database or system. Only the database owner can create a schema with a name different from the current user name, and only the the database owner can specify Modified: db/derby/docs/trunk/src/ref/rrefsqljgrant.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljgrant.dita?rev=713746&r1=713745&r2=713746&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefsqljgrant.dita (original) +++ db/derby/docs/trunk/src/ref/rrefsqljgrant.dita Thu Nov 13 08:09:44 2008 @@ -38,7 +38,8 @@

  • Create a trigger on a table.
  • Update data in a table or in a subset of columns in a table.
  • Run a specified function or procedure.
  • -

    Before you issue a GRANT statement, check that the derby.database.sqlAuthorization property +

    Before you issue a GRANT statement, check that the +derby.database.sqlAuthorization property is set to true. The derby.database.sqlAuthorization property enables the SQL Authorization mode.

    You can grant privileges to database objects that you are authorized to grant. See the CREATE statement for the Modified: db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita?rev=713746&r1=713745&r2=713746&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita (original) +++ db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita Thu Nov 13 08:09:44 2008 @@ -37,7 +37,8 @@

  • Create a trigger on a table.
  • Update data in a table or in a subset of columns in a table.
  • Run a specified routine (function or procedure).
  • -

    Before you issue a REVOKE statement, check that the derby.database.sqlAuthorization property +

    Before you issue a REVOKE statement, check that the +derby.database.sqlAuthorization property is set to true. The derby.database.sqlAuthorization property enables the SQL Authorization mode.

    You can revoke privileges from an object if you are the owner of the object or the database Modified: db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita?rev=713746&r1=713745&r2=713746&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita (original) +++ db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita Thu Nov 13 08:09:44 2008 @@ -112,9 +112,12 @@ to a Java string.

    For example:SELECT * FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER('myderbyerrors.log')) AS T1

    By default log -files contain only boot, shutdown, and error messages. In the guide, -see the derby.stream.error.logSeverityLevel property -and the derby.language.logStatementText property for +files contain only boot, shutdown, and error messages. +See the +derby.stream.error.logSeverityLevel +property and the +derby.language.logStatementText +property for instructions on how to print more information to log files. You can then query that information by using the SYSCS_DIAG.ERROR_LOG_READER diagnostic table function.

    @@ -177,9 +180,12 @@ whose data type maps to a Java string.

    For example:SELECT * FROM TABLE (SYSCS_DIAG.STATEMENT_DURATION('somederby.log')) AS T1

    By default log -files contain only boot, shutdown, and error messages. In the guide, -see the derby.stream.error.logSeverityLevel property -and the derby.language.logStatementText property for +files contain only boot, shutdown, and error messages. +See the +derby.stream.error.logSeverityLevel +property and the +derby.language.logStatementText +property for instructions on how to print more information to log files. You can then query that information by using the SYSCS_DIAG.STATEMENT_DURATION diagnostic table function.