Skip to content

JDBC Log

The JDBC Logs (which are a set of rotating files which you can configure from the JDBC Settings page) are simple space separated files, so they can be easily imported into database or spreadsheet applications. The log is called jdbc.log, the bottom part of the page tells you where you can locate this file on your hard drive.

The log file is formatted as follows:

Field Name Number Description
Date (Formatted) 1 The date on which this log entry was written.
Time (Formatted) 2 The time on which this log entry was written.
Date/Time (Milliseconds) 3 This is the millisecond time at which this request was started or finished (depending upon the Request Status.)
Version 4 Version number of this log entry.
Server Startup Time (ms) 5 Startup time of the application server in milliseconds (ms) since epoch.
Request ID 6 The FusionReactor Request ID.
Thread ID 7 The name of the thread responsible for responding to this request.
Client IP Address 8 The IP address of the person making the request.
Request Method 9 Specifies the HTTP method used during the request. This will usually be "GET" or "POST"
Request URL 10 This is the requested URL. The format of this column will change depending on URL Format setting which can be found on the Request Settings page.
Log Type 11 One of: "METRIC", "NOTIFICATION" or "REMINDER"
DB Start Time 12 The time (in milliseconds) at which the JDBC query began.
DB End Time 13 The time (in milliseconds) at which the DB finished with the query.
Total End Time 14 The time (in milliseconds) at which the query was completely finished (after results were transferred back etc.).
DB Time 15 The amount of time (in milliseconds) this JDBC query spent in the DB.
Total Time 16 The total amount of time (in milliseconds) it took to complete this query.
Row Count 17 The number of rows returned by this query.
Prepared Statement 18 This is a simple TRUE/FALSE value to tell you if this statement had already been prepared prior to its execution.
Row Limited 19 This is a simple TRUE/FALSE value to tell you if this query was row limited.
DataSource 20 If you have assigned a name to your data source wrapper then it will appear here. To find out how to name your data sources, please refer to page 14 of the JDBC Monitoring.
Statement 21 The actual statement which was run.
Stack Trace 22 This is the stack trace which was stored when the query was run. You can turn on or off this feature from the JDBC Settings page and alter the stack trace information from the Stack Trace Filter page.
Query String 23 This is the query string from the request running the JDBC statement.
Message 23 For Notifications and Reminders, this will contain the notification or reminder message.

Note

Depending on the type of log message, not all columns will have values.