Logging
The adapter uses log4j to generate log files. The settings within the log4j configuration file are used by the adapter to determine the type of messages to log. The following categories can be specified:
• Error: Only error messages are logged.
• Info: Both Error and Info messages are logged.
• Debug: Error, Info, and Debug messages are logged.
The Other property of the adapter can be used to set Verbosity to specify the amount of detail to be included in the log file, that is:
Verbosity=4;
You can use Verbosity to specify the amount of detail to include in the log within a category. The following verbosity levels are mapped to the log4j categories:
• 0 = Error
• 1-2 = Info
• 3-5 = Debug
For example, if the log4j category is set to DEBUG, the Verbosity option can be set to 3 for the minimum amount of debug information or 5 for the maximum amount of debug information.
Note that the log4j settings override the Verbosity level specified. The adapter never logs at a Verbosity level greater than what is configured in the log4j properties. In addition, if Verbosity is set to a level less than the log4j category configured, Verbosity defaults to the minimum value for that particular category. For example, if Verbosity is set to a value less than 3 and the Debug category is specified, the Verbosity defaults to 3.
The following list is a breakdown of the Verbosity levels and the information that they log.
• 1 - Will log the query, the number of rows returned by it, the start of execution and the time taken, and any errors.
• 2 - Will log everything included in Verbosity 1 and HTTP headers.
• 3 - Will additionally log the body of the HTTP requests.
• 4 - Will additionally log transport-level communication with the data source. This includes SSL negotiation.
• 5 - Will additionally log communication with the data source and additional details that may be helpful in troubleshooting problems. This includes interface commands.