HP Driver for JDBC User's Manual

56 Chapter6

Troubleshooting

Client Tracing

Tracing of the JDBC Driver client class ﬁles is invoked by adding

tracing commands to the connection URL. The connection URL can be

altered to both invoke tracing, and to control the type of information

that is traced. The tracing information is sent to a Java stream, which

must be speciﬁed by the application using the

java.sql.DriverManager.setLogStream method.

Both the tracing level and tracing output must be speciﬁed before any

tracing can be done.

Note that the use of tracing will impact performance of the application.

The greater the detail in the tracing, the slower the performance of the

application.

The URL syntax to invoke tracing is:

“jdbc:allbase://server[:port]/database?TRACE=trace”

where

trace

is any vertical bar (|) separated combination of the

values:

ARGUMENTS Trace HP Driver for JDBC class

method arguments. Input arguments

and return values are all traced. Only

the methods called by the application

are traced.

ARGUMENTS_ALL Trace all HP Driver for JDBC class

methods that are called by both the

application and the driver itself.

TIME Include the time in HHMMSSFFF format

on all tracing output lines where HH is

the hour from 00 to 23, MM is the

minute from 00 to 59, SS is the second

from 00 to 59, and FFF is the

millisecond from 000 to 999. The

information appears in the third

column of the tracing output.

DATE Include the date in YYYYMMDD format

on all tracing output lines where YYYY

is the year from 0000 to 9999, MM is the

month from 01 to 12, DD is the day of

the month from 00 to 31. This

information appears in the second

column of the tracing output.