# derby.stream.error.extendedDiagSeverityLevel

The derby.stream.error.extendedDiagSeverityLevel property specifies whether thread dump information and extended diagnostic information are created, and at what level, in the event of a system crash or session error.

If errors have a severity level greater than or equal to the value of the derby.stream.error.extendedDiagSeverityLevel property, thread dump and diagnostic information will appear in the derby.log file. In addition, with IBM Java Virtual Machines (JVMs), a javacore file with additional information is created.

To allow the information to be dumped to the log, you must grant two permissions to Derby in your security policy file. See "Configuring Java security" in the Derby Security Guide.

Any error raised in a Derby system is given a level of severity. This property indicates the minimum severity necessary for an error to appear in the log file. The severities are defined in the class org.apache.derby.types.ExceptionSeverity. The higher the number, the more severe the error.

- 10000

  Warnings.

- 20000

  Errors that cause the statement to be rolled back, such as syntax errors and constraint violations.

- 30000

  Errors that cause the transaction to be rolled back, such as deadlocks.

- 40000

  Errors that cause the session to be closed.

- 45000

  Errors that cause the database to be closed.

- 50000

  Errors that shut down the Derby system.

## Default

40000.

## Example

    // send errors of level 30000 and higher to the log
    derby.stream.error.extendedDiagSeverityLevel=30000

## Scope

system-wide

## Dynamic or static

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

Parent topic: Derby properties
Related reference
derby.authentication.builtin.algorithm
derby.authentication.builtin.iterations
derby.authentication.builtin.saltLength
derby.authentication.ldap.searchAuthDN
derby.authentication.ldap.searchAuthPW
derby.authentication.ldap.searchBase
derby.authentication.ldap.searchFilter
derby.authentication.native.passwordLifetimeMillis
derby.authentication.native.passwordLifetimeThreshold
derby.authentication.provider
derby.authentication.server
derby.connection.requireAuthentication
derby.database.classpath
derby.database.defaultConnectionMode
derby.database.forceDatabaseLock
derby.database.fullAccessUsers
derby.database.noAutoBoot
derby.database.propertiesOnly
derby.database.readOnlyAccessUsers
derby.database.sqlAuthorization
derby.infolog.append
derby.jdbc.xaTransactionTimeout
derby.language.logQueryPlan
derby.language.logStatementText
derby.language.sequence.preallocator
derby.language.statementCacheSize
derby.locks.deadlockTimeout
derby.locks.deadlockTrace
derby.locks.escalationThreshold
derby.locks.monitor
derby.locks.waitTimeout
derby.replication.logBufferSize
derby.replication.maxLogShippingInterval
derby.replication.minLogShippingInterval
derby.replication.verbose
derby.storage.indexStats.auto
derby.storage.indexStats.log
derby.storage.indexStats.trace
derby.storage.initialPages
derby.storage.minimumRecordSize
derby.storage.pageCacheSize
derby.storage.pageReservedSpace
derby.storage.pageSize
derby.storage.rowLocking
derby.storage.tempDirectory
derby.storage.useDefaultFilePermissions
derby.stream.error.field
derby.stream.error.file
derby.stream.error.logBootTrace
derby.stream.error.logSeverityLevel
derby.stream.error.method
derby.stream.error.rollingFile.count
derby.stream.error.rollingFile.limit
derby.stream.error.rollingFile.pattern
derby.stream.error.style
derby.system.bootAll
derby.system.durability
derby.system.home
derby.user.UserName
DataDictionaryVersion