Logging Config File Samples

---

oracle_database_log.config

This will log all information to a custom Oracle database table. It uses the ADONetAppender Appender. It will log all information to the Log table. You should set the following parameters in the ConnectionString parameter:

• database
• user
• password

Keep in mind that this is a direct database connection - it does not use the Application (Clarify or fcCRM) encrypted password.
You will need to first create this custom database table - refer to the ADONetAppender Appender documentation for the database table definition.

Sample Configuration:

 <log4net>
     <appender name="ADONetAppender_Oracle" type="log4net.Appender.ADONetAppender" >
         <param name="ConnectionType" value="System.Data.OracleClient.OracleConnection, System.Data.OracleClient, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
         <param name="ConnectionString" value="data source=[mydatabase];User ID=[user];Password=[password]" />
         <param name="CommandText" value="INSERT INTO Log (Datetime,Thread,Log_Level,Logger,Message) VALUES (:log_date, :thread, :log_level, :logger, :message)" />
         <param name="BufferSize" value="128" />
         <param name="Parameter">
		     <param name="ParameterName" value=":log_date" />
		     <param name="DbType" value="DateTime" />
		     <param name="Layout" type="log4net.Layout.RawTimeStampLayout" />
         </param>
         <param name="Parameter">
		     <param name="ParameterName" value=":thread" />
		     <param name="DbType" value="String" />
		     <param name="Size" value="255" />
		     <param name="Layout" type="log4net.Layout.PatternLayout">
			     <param name="ConversionPattern" value="%t" />
		     </param>
         </param>
         <param name="Parameter">
		     <param name="ParameterName" value=":log_level" />
		     <param name="DbType" value="String" />
		     <param name="Size" value="50" />
		     <param name="Layout" type="log4net.Layout.PatternLayout">
			     <param name="ConversionPattern" value="%p" />
		     </param>
         </param>
         <param name="Parameter">
		     <param name="ParameterName" value=":logger" />
		     <param name="DbType" value="String" />
		     <param name="Size" value="255" />
		     <param name="Layout" type="log4net.Layout.PatternLayout">
			     <param name="ConversionPattern" value="%c" />
		     </param>
         </param>
         <param name="Parameter">
		     <param name="ParameterName" value=":message" />
		     <param name="DbType" value="String" />
		     <param name="Size" value="4000" />
		     <param name="Layout" type="log4net.Layout.PatternLayout">
			     <param name="ConversionPattern" value="%m" />
		     </param>
         </param>
     </appender>

   <root>
	   <level value="all" />			
	   <appender-ref ref="ADONetAppender_Oracle" />
   </root>
       
</log4net>
      

---

Additional Logging Samples

• 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