Hi,
I've been trying to use log4net to log the NHibernate generated SQL as
outlined in this article:
http://nhforge.org/wikis/howtonh/configure-log4net-for-use-with-nhibernate.aspx
I'm using the web.config file for the configuration parameters.
I am using:
Fluent NHibernate
ASP.Net
VS 2010 environement
.Net 4.0 Framework
The specifics of what I have set up are below.
Any help would be greatly appreciated.
Kim
---------------------------------------------------------------------------------------------------
I finally have log4net logging, but not the NHibernate info, by adding
<system.diagnostics>
<trace autoflush="true">
<listeners>
<add
name="textWriterTraceListener"
type="System.Diagnostics.TextWriterTraceListener"
initializeData="C:\temp\log.txt" />
</listeners>
</trace>
</system.diagnostics>
and this
<appSettings>
<add key="log4net.Internal.Debug" value="true" />
</appSettings>
in order to get a log file to be created.
----------------------------------------------------------
This is the log4net configuration section.
<log4net debug="false">
<!-- Define some output appenders -->
<appender name="trace" type="log4net.Appender.TraceAppender,
log4net">
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d{ABSOLUTE}
%-5p %c{1}:%L - %m%n" />
</layout>
</appender>
<appender name="console"
type="log4net.Appender.ConsoleAppender, log4net">
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d{ABSOLUTE}
%-5p %c{1}:%L - %m%n" />
</layout>
</appender>
<appender name="web"
type="log4net.Appender.AspNetTraceAppender, log4net">
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d{ABSOLUTE}
%-5p %c{1}:%L - %m%n" />
</layout>
</appender>
<appender name="rollingFile"
type="log4net.Appender.RollingFileAppender,log4net" >
<param name="File" value="C:\temp\log.txt" />
<param name="AppendToFile" value="true" />
<param name="RollingStyle" value="Date" />
<param name="DatePattern" value="yyyy.MM.dd" />
<param name="StaticLogFileName" value="true" />
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c
- %m%n" />
</layout>
<threshold value="ALL" />
</appender>
<!-- Setup the root category, add the appenders and set the
default priority -->
<root>
<priority value="ALL" />
<appender-ref ref="rollingFile" />
<!--<appender-ref ref="trace" />
<appender-ref ref="console" />-->
</root>
<logger name="NHibernate" additivity="false">
<level value="WARN" />
</logger>
<logger name="NHibernate.SQL">
<level value="ALL" />
<appender-ref ref="rollingFile" />
</logger>
</log4net>
---------------------
My assembly:
[assembly: log4net.Config.XmlConfigurator(Watch=true)]
--------------------------------------------------
Global.asax.cs / Application_Start
XmlConfigurator.Configure();
----------------------------------------------------
I have also tried using .ShowSql()
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
