Appendix D

Logging of SQL Statements #

SICS reads and modifies database information using SQL statements via the JDBC standard interface.

For debugging and performance measurement purposes, it may be of interest to review all SQL statements issued by SICS against the database. To do so, one must activate SQL logging.

There are two options available:

• Global activation. This is done in the configuration file log4j2.xml (see Log Configuration above) and will affect all users running SICS from this installation location. Logging is active for the full timespan of each user’s SICS session.
• User controlled activation. This is done by an individual end user, from the Help, About menu. It will affect this end user only, and the timespan (within the current SICS session) is controlled by the end user. User controlled SQL logging will always end at the latest when the user’s SICS session ends. For details, please see next section.

User Controlled SQL Logging #

You must be logged in to SICS before using this way of logging SQL.

To activate and deactivate user controlled SQL logging, do as follows.

From any SICS window, select Help from the menu. Then select About SICS. Then click the System Info… button. Select the Logging tab.

Now enter the Log File Name and finally tick/check/select either Show SQL or Trace SQL.

To deactivate, untick/check/select the logging option.