Derby properties

This chapter includes all the core Derby properties.

Note: When setting properties that have boolean values, be sure to trim extra spaces around the word true. Extra spaces around the word true cause the property to be set to false.

Derby properties summarizes the general Derby properties. In that 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 1. Derby properties
Property	Scope	Dynamic
derby.authentication.ldap.searchAuthDN	S, D
derby.authentication.ldap.searchAuthPW	S, D
derby.authentication.ldap.searchBase	S, D
derby.authentication.ldap.searchFilter	S, D
derby.authentication.provider	S, D
derby.authentication.server	S, D
derby.connection.requireAuthentication	S, D
derby.database.defaultConnectionMode	S, D	X*
derby.database.forceDatabaseLock	S
derby.database.fullAccessUsers	S, D	X*
derby.database.propertiesOnly	D	X
derby.database.readOnlyAccessUsers	S, D	X*
derby.infolog.append	S
derby.language.logQueryPlan	S
derby.language.logStatementText	S, D
derby.locks.deadlockTimeout	S, D	X
derby.locks.deadlockTrace	S, D	X
derby.locks.escalationThreshold	S, D	X
derby.locks.monitor	S, D	X
derby.locks.waitTimeout	S, D	X
derby.storage.initialPages	C
derby.storage.minimumRecordSize	S, D, C	X
derby.storage.pageCacheSize	S
derby.storage.pageReservedSpace	S, D, C	X
derby.storage.pageSize	S, D, C	X
derby.storage.tempDirectory	S, D	X
derby.stream.error.field	S
derby.stream.error.file	S
derby.stream.error.method	S
derby.stream.error.logSeverityLevel	S
derby.system.durability	S
derby.system.home	S
derby.user.UserName	S, D	X

* See the main page for this property for information about when changes to the property are dynamic.

There are additional properties associated with the Derby tools. For more information about tool-specific properties, see the Derby Tools and Utilities Guide Guide.