JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

T4LogLevel
The T4LogLevel property sets the logging levels that control logging output for the Type 4 driver.
The Java package java.util.logging logs error messages and traces messages in the driver.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
Data type: String
Default: OFF
Logging Levels
OFF
is a special level that turns off logging; the default setting.
SEVERE
indicates a serious failure; usually applies to SQL exceptions generated by the Type 4 driver.
WARNING
indicates a potential problem, which usually applies to SQL warnings generated by the Type
4 driver.
INFO
provides informational messages, typically about connection pooling, statement pooling, and
resource usage. This information can help in tuning application performance.
CONFIG
provides static configuration messages that can include property values and other Type 4 driver
configuration information.
FINE
provides tracing information from the Type 4 driver methods described in the Type 4 driver
API. The level of tracing is equivalent to the level of tracing provided when calling the
setLogWriter() method of the DriverManager class or the DataSource class.
FINER
indicates a detailed tracing message for which internal Type 4 driver methods provide messages.
These messages can be useful in debugging the Type 4 driver.
FINEST
indicates a highly detailed tracing message. The driver provides detailed internal data messages
that can be useful in debugging the Type 4 driver.
ALL
logs all messages.
For example, to enable tracing, use the t4sqlmx.T4LogLevel property specified in the command
line:
-Dt4sqlmx.T4LogLevel=FINE
T4LogLevel Considerations
• If a security manager is defined by your application using an AppServer,
LoggingPermission must be granted in the java.policy file as follows:
permission java.util.logging.LoggingPermission "control","";
• The Type 4 driver is not designed to inherit the java.util.logging.FileHandler.level
settings at program startup.
• Server-side tracing and logging through MXCS is managed by NSM/web. For more information
about server side-tracing (logging), see the NSM/web online help.
Type 4 Driver Property Descriptions 49