<< traceFile=path attribute | upgrade=true attribute >>

traceLevel=value attribute

<< traceFile=path attribute | upgrade=true attribute >>

Derby Reference Manual

351

traceLevel=value attribute

Function

If tracing is enabled, specifies the level of tracing to be used by the Derby Network Client.
The value is numeric. If you do not specify a trace level, the default is TRACE_ALL.

For more information about tracing, see "Network client tracing" in the Derby
Server and Administration Guide. See

traceFile=path

traceFileAppend=true

, and

traceDirectory=path

for other attributes related to tracing.

Tracing levels

The following table shows the available tracing levels and their values.

Table 131.

Available tracing levels and values

Trace Level

Hex

Value

Decimal

Value

org.apache.derby.jdbc.ClientDataSource.TRACE_NONE

0x0

org.apache.derby.jdbc.ClientDataSource.TRACE_CONNECTION_CALLS0x1

org.apache.derby.jdbc.ClientDataSource.TRACE_STATEMENT_CALLS 0x2

org.apache.derby.jdbc.ClientDataSource.TRACE_RESULT_SET_CALLS0x4

org.apache.derby.jdbc.ClientDataSource.TRACE_DRIVER_CONFIGURATION

0x10

org.apache.derby.jdbc.ClientDataSource.TRACE_CONNECTS

0x20

org.apache.derby.jdbc.ClientDataSource.TRACE_PROTOCOL_FLOWS 0x40

org.apache.derby.jdbc.ClientDataSource.TRACE_RESULT_SET_META_DATA

0x80

128

org.apache.derby.jdbc.ClientDataSource.TRACE_PARAMETER_META_DATA

0x100 256

org.apache.derby.jdbc.ClientDataSource.TRACE_DIAGNOSTICS

0x200 512

org.apache.derby.jdbc.ClientDataSource.TRACE_XA_CALLS

0x800 2048

org.apache.derby.jdbc.ClientDataSource.TRACE_ALL

0xFFFFFFFF

-1

To specify more than one trace level, use one of the following techniques:

· If you are using the

tool, add the decimal values together and specify the sum.

For example, to trace both PROTOCOL flows and connection calls, add the values
for TRACE_PROTOCOL_FLOWS (64) and TRACE_CONNECTION_CALLS (1).
Specify the sum, the value 65.

· If you are running a JDBC program, do one of the following:

· Use bitwise OR operators ( | ) with two or more trace values. For example, to

trace protocol flows and connection calls, specify this value for traceLevel:

TRACE_PROTOCOL_FLOWS | TRACE_CONNECTION_CALLS

· Use a bitwise complement operator ( ~ ) with a trace value to specify all

except a certain trace. For example, to trace everything except protocol flows,
specify this value for traceLevel:

~TRACE_PROTOCOL_FLOWS

Combining with other attributes

If you specify this attribute, you must also specify either the traceFile=path attribute or the
traceDirectory=path attribute.