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.

Derby provides three ClientDataSource implementations. You can use the org.apache.derby.jdbc.ClientDataSource class on Java SE 5 and above (except Java SE 8 Compact Profiles), in applications that call JDBC 3 or JDBC 4.0 methods. You can use the org.apache.derby.jdbc.ClientDataSource40 class on Java SE 6 and above (except Java SE 8 Compact Profiles), in applications that call JDBC 4.1 or JDBC 4.2 methods. You must use the org.apache.derby.jdbc.BasicClientDataSource40 class on Java SE 8 Compact Profile 2 or 3.

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