The Microsoft JDBC Driver Logging screen

The Server Tools Microsoft JDBC Driver Logging screen is available only if the database server is SQL Server. Use this screen to specify the following:

  • The logging level for the Microsoft JDBC driver. Be cautious setting the logging level, as detailed logging can slow the system significantly.
  • The logging format, either Simple, for a more readable format, or XML for XML output, usually parsed by another system.
  • The log file location, adding special components that PolicyCenter replaces at runtime. For example, use %u to append a unique number to each log to avoid conflicts.

If you have already enabled logging through database-config.xml or from previous use of this screen, use this screen to make additional changes to reset the logging level. After clicking Set Logging Level, PolicyCenter flushes and closes any existing logging files before beginning the new trace. If you choose OFF as the logging level, PolicyCenter disables any current logging as well as flushing and closing any existing logging files.

The ability to control logging of the Microsoft JDBC driver through PolicyCenter only works if using the internal connection pool, not if using an external JNDI data source connection pool.

Note: Using this screen is a better option if tracing a particular operation, in order to minimize system impact and size of the trace file.

See also