fcSDK Documentation Send comments on this topic.

Logging Config File Samples

Logging Config File Samples

sql_log.config

This configuration will log all SQL statements to a rolling log file. It uses the RollingFileAppender Appender. It will log all information from the FChoice.Common.Data namespace (which is responsible for generating SQL) to the file C:\TEMP\logs\fcflnet.log. The file written to will always be called fcflnet.log because the StaticLogFileName param is set to true. The file will be rolled based on a size constraint (RollingStyle). Up to 100 (MaxSizeRollBackups) old files of 1024 KB each (MaximumFileSize) will be kept. These rolled files will be named: fcflnet.log.1, fcflnet.log.2, fcflnet.log.3, etc...

The format of the output will be:
<timestamp> [user: <user_name>] [fcsessionid: <fcsession id>] [<level>] [<class file where error originated from>] <newline>
<tab><message><newline><newline>

Example Output:

2004-11-15 14:21:31,469 [user: joe] [fcsessionid: 1636fbda-6bbf-463d-afcc-d24a8f113da6] [INFO ] [FChoice.Common.Data.SqlHelper]
	Fill DataSet query (e592af81-14fb-48b3-ae19-0ae77b4ca457) took 0.0022 seconds.

Sample Configuration:

      <log4net>
         <appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender" >
            <param name="File" value="C:\TEMP\logs\fcflnet.log" />
            <param name="AppendToFile" value="true" />
            <param name="RollingStyle" value="Size" />
            <param name="MaxSizeRollBackups" value="100" />
            <param name="MaximumFileSize" value="1024KB" />
            <param name="StaticLogFileName" value="true" />
            
            <layout type="log4net.Layout.PatternLayout">
               <param name="ConversionPattern" value="%d [user: %X{user}] [fcsessionid: %X{session}] [%-5p] [%c]%n	%m%n%n" />
            </layout>
         
         </appender>

         <root>
            <level value="OFF" />			
         </root>

         <logger name="FChoice.Common.Data" additivity="false">
            <level value="info" />
            <appender-ref ref="RollingFileAppender" />
         </logger>
      
      </log4net>

Additional Logging Samples

log4net Reference

Please visit the Apache Logging Services: log4net Homepage for documentation on log4net. The most important links are the Manual, the FAQ, and the Configuration Examples