Log4Net adonet appender settings for oracle

[rebelrajesh]

 <log4net debug="true">
    <!--appender for DB logging-->
    <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
      <bufferSize value="1" />
      <connectionType
value="System.Data.OracleClient.OracleConnection,System.Data.OracleClient,
Version=2.0.0.0,Culture=neutral, PublicKeyToken=b77a5c561934e089" />
      <connectionString value="Data Source=localhost/ga;User
ID=re_3;Password=re_3" providerName="System.Data.OracleClient"/>
      <commandText value="INSERT INTO LOG4NET
(LOG_LEVEL,LOG_MESSAGE,LOG_DATE,LOGIN_ID, BROWSER_INFO,STACK_TRACE,
PAGE_URL,QUERY_STRING,IP_ADDRESS,EXP_SOURCE)
VALUES(:log_level,:log_message,to_timestamp(:log_date, 'dd-MM-yyyy
HH24:mi:ss.ff6'),:loginid,:browser_info,:stack_trace, :page_url,
:query_string, :ip_address,:exp_source)  " />

      <parameter>
        <parameterName value=":log_level" />
        <dbType value="String" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%level" />
        </layout>
      </parameter>

      <parameter>
        <parameterName value=":log_message" />
        <dbType value="String" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%m" />
        </layout>
      </parameter>
      
      <parameter>
        <parameterName value=":log_date" />
        <dbType value="String" />
        <layout type="log4net.Layout.PatternLayout"
value="%date{dd'-'MM'-'yyyy HH':'mm':'ss'.'ffffff}" />
      </parameter>
      
      <parameter>
        <parameterName value=":loginid" />
        <dbType value="string" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%property{LOGINID}" />
        </layout>
      </parameter>

      <parameter>
        <parameterName value=":browser_info" />
        <dbType value="string" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%property{Browser_Info}" />
        </layout>
      </parameter>

      <parameter>
        <parameterName value=":stack_trace" />
        <dbType value="String" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%property{STACK_TRACE}" />
        </layout>
      </parameter>

      <parameter>
        <parameterName value=":page_url" />
        <dbType value="string" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%property{Page_Url}" />
        </layout>
      </parameter>

      <parameter>
        <parameterName value=":query_string" />
        <dbType value="string" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%property{QUERY_STRING}" />
        </layout>
      </parameter>

      <parameter>
        <parameterName value=":ip_address" />
        <dbType value="string" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%property{IP_ADDRESS}" />
        </layout>
      </parameter>

      <parameter>
        <parameterName value=":exp_source" />
        <dbType value="string" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%property{EXP_SOURCE}" />
        </layout>
      </parameter>
    </appender>
    

    <root>
      <level value="debug"/>
      <appender-ref ref="AdoNetAppender"/>
    </root>

  </log4net>

---------------------------
Above log4net body is to be included in the web.config.
parameters which are specified with property in the conversion pattern like:
<conversionPattern value="%property{LOGINID}" /> are custom parameters.
Values for these parameters can be given using the below statements. They
are to be included in the appropriate .aspx.cs pages where we can get
values.

 log4net.GlobalContext.Properties["STACK_TRACE"] = ex.StackTrace.ToString();
log4net.GlobalContext.Properties["EXP_SOURCE"] = ex.TargetSite.ToString();

 log4net.GlobalContext.Properties["Page_Url"] =
System.Web.HttpContext.Current.Request.Url.AbsoluteUri;
                log4net.GlobalContext.Properties["QUERY_STRING"] =
System.Web.HttpContext.Current.Request.QueryString.ToString();

log4net.GlobalContext.Properties["LOGINID"] = user.Login;

 HttpBrowserCapabilities browser = Request.Browser;
                string browserInfo = "BrowserName:" + browser.Browser +
"<br>" + "BrowserType:" + browser.Type + "<br>" + " BrowserVersion:" +
browser.Version;
                log4net.GlobalContext.Properties["Browser_Info"] =
browserInfo;
                log4net.GlobalContext.Properties["IP_ADDRESS"] =
(string)System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];


-- 
View this message in context: 
http://old.nabble.com/Log4Net-adonet-appender-settings-for-oracle-tp31645352p31645352.html
Sent from the Log4net - Users mailing list archive at Nabble.com.