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
. 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.
Available tracing levels and values
This table lists the network client tracing levels and their values.
Trace Level
Hex Value
Decimal Value
org.apache.derby.jdbc.ClientDataSource.TRACE_NONE
0x0
0
org.apache.derby.jdbc.ClientDataSource.TRACE_CONNECTION_CALLS
0x1
1
org.apache.derby.jdbc.ClientDataSource.TRACE_STATEMENT_CALLS
0x2
2
org.apache.derby.jdbc.ClientDataSource.TRACE_RESULT_SET_CALLS
0x4
4
org.apache.derby.jdbc.ClientDataSource.TRACE_DRIVER_CONFIGURATION
0x10
16
org.apache.derby.jdbc.ClientDataSource.TRACE_CONNECTS
0x20
32
org.apache.derby.jdbc.ClientDataSource.TRACE_PROTOCOL_FLOWS
0x40
64
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 ij 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.
Example
-- enable tracing on a new database
jdbc:derby://localhost:1527/mydb;create=true;traceFile=trace.out;
traceLevel=65