The <sqlserver-settings> database configuration element

The <database> element in file database-config.xml contains, at most, a single occurrence of subelement <sqlserver-settings>. The use of the <sqlserver-settings> element is optional. Use this element to configure Microsoft JDBC driver logging.

The <sqlserver-settings> element has the following syntax.

<database>
  ...
  <sqlserver-settings jdbc-trace-file="string" jdbc-trace-level="string" 
         unicodecolumns="true|false"/>
  ...
</database>

The following list describes the attributes that you can configure on the <sqlserver-settings> element. All of these attributes are optional.

jdbc-trace-file

Specifies the name of the trace file. If you do not provide a file name, this value defaults to the following:

  C:\temp\msjdbctrace%u.log

PolicyCenter replaces the symbols in the file name at runtime with their meaning as listed at the following web site.

http://java.sun.com/j2se/1.5.0/docs/api/java/util/logging/FileHandler.html

Use the listed symbols to uniquely name the trace file.

jdbc-trace-level

Valid trace level as listed at the following web site:

http://msdn.microsoft.com/en-us/library/ms378517(SQL.90).aspx?ppud=4

unicodecolumns

Required if starting a new database that exclusively uses Unicode-capable column character data types (nvarchar, …). PolicyCenter ignores this attribute if the database does not support Unicode or if the attribute is not relevant to the new database. The default is false.

The <sqlserver-settings> element does not contain additional subelements.

See also