You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4net-user@logging.apache.org by rebelrajesh <ad...@gmail.com> on 2011/05/18 11:41:32 UTC
Log4Net adonet appender settings for oracle
<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.