traceLevel=value attribute

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.

Derby provides two ClientDataSource implementations. You can use the org.apache.derby.jdbc.ClientDataSource class on all supported Java SE versions except Java SE 8 Compact Profile 2. On Java SE 8 Compact Profile 2, you must use the org.apache.derby.jdbc.BasicClientDataSource40 class. See JDBC support for Java SE 8 Compact Profiles for more information.

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.

-- enable tracing on a new database
jdbc:derby://localhost:1527/mydb;create=true;traceFile=trace.out;
    traceLevel=65