public Interface Property

Property that specifies the name of the hash algorithm to use with the configurable hash authentication scheme.

Alternative default value for derby.authentication.builtin.algorithm if AUTHENTICATION_BUILTIN_ALGORITHM_DEFAULT is not available at database creation time.

Default value for derby.authentication.builtin.iterations.

The default value for derby.authentication.builtin.saltLength.

derby.system.bootAll Automatically boot any services at start up time.

Property name for specifying checkpoint interval Undocumented.

derby.database.classpath Consists of a series of two part jar names.

derby.database.propertiesOnly

Configuration parameter for deadlock timeouts, set in seconds.

Turn on deadlock trace to help debug deadlocks.

Default value for above

derby.__deleteOnCreate Before creating this service delete any remenants (e.g. the directory) of a previous service at the same location.

This property is private to Derby.

derby.drda.logConnections

Indicates whether to log connections and disconnections.

derby.drda.securityMechanism This property can be set to one of the following values USER_ONLY_SECURITY CLEAR_TEXT_PASSWORD_SECURITY ENCRYPTED_USER_AND_PASSWORD_SECURITY STRONG_PASSWORD_SUBSTITUTE_SECURITY if derby.drda.securityMechanism is set to a valid mechanism, then the Network Server accepts only connections which use that security mechanism.

derby.drda.streamOutBufferSize size of buffer used when stream out for client.

derby.drda.trace

derby.drda.traceDirectory The directory used for network server tracing files.

This is a value supported for derby.system.durability When derby.system.durability=test, the storage system does not force syncs and the system may not recover.

derby.stream.error.file=absolute or relative error log filename Takes precendence over derby.stream.error.method.

derby.stream.error.rollingfile.count=the rolling file count

The default count is 10

derby.stream.error.rollingfile.pattern=the pattern A pattern consists of a string that includes the following special components that will be replaced at runtime:

• "/" the local pathname separator
• "%t" the system temporary directory
• "%h" the value of the "user.home" system property
• "%d" the value of the "derby.system.home" system property
• "%g" the generation number to distinguish rotated logs
• "%u" a unique number to resolve conflicts
• "%%" translates to a single percent sign "%"

derby.stream.error.ExtendedDiagSeverityLevel=integerValue Indicates the minimum level of severity for errors that are reported thread dump information and diagnosis information depends on jvm vender.

derby.database.forceDatabaseLock Derby attempts to prevent two instances of Derby from booting the same database with the use of a file called db.lck inside the database directory.

List of users with full access connection level authorization.

The bump threshold for pages size for index.

The size of the permissions cache used by the data dictionary.

The size of the sequence generator cache used by the data dictionary.

Name of the implementation of SequencePreallocator which is used to tune how many values Derby pre-allocates for identity columns and sequences.

derby.locks.escalationThreshold The number of row locks on a table after which we escalate to table locking.

Configuration parameter for lock wait timeouts, set in seconds.

derby.stream.error.logBootTrace defaults to false.

derby.storage.logDeviceWhenBackedUp This property indicates the logDevice location(path) when the backup was taken, used to restore the log to the same location while restoring from backup.

derby.stream.error.logSeverityLevel=integerValue Indicates the minimum level of severity for errors that are reported to the error stream.

The minimum value for LOCKS_ESCALATION_THRESHOLD

Declare a minimum JDK level the class for a module or sub sub protocol supports.

The default page size to use for tables that contain a long column.

The property name used to get the default value for XA transaction timeout in seconds.

Name of the file that contains system wide properties.

Property name for specifying the size of the replication log buffers

Property name for specifying the minimum log shipping interval

Internal.

derby.drda.startNetworkServer

If true then we will attempt to start a DRDA network server when Derby boots, turning the current JVM into a server.

Specifies the lower threshold for the absolute difference between the row estimate for the table and the row estimate for the index before creating statistics for the associated indexes.

Specifies the lower threshold for the number of rows in a table before creating statistics for the associated indexes.

Specifies whether to revert to 10.8 behavior and keep disposable stats.

Tells if more detailed activities related to automatic index statistics update should be traced.

db2j.storage.dataNotSyncedAtCheckPoint

When set, the store system will not force a sync() call on the containers during a checkpoint.

derby.storage.tempDirectory

Sets the temp directory for a database.

derby.subSubProtocol.xxx

A new subsubprotocol can be defined by specifying the class that handles storage for the subsubprotocol by implementing the org.apache.derby.io.StorageFactory StorageFactory or org.apache.derby.io.WritableStorageFactory WritableStorageFactory interface.

The bump threshold for pages sizes for create tables If the approximate column sizes of a table is greater than this threshold, the page size for the tbl is bumped to PAGE_SIZE_DEFAULT_LONG provided the page size is not already specified as a property

Default value for wait timeouts (60 seconds)