Guy´s, I'm using the NHibernate 1.0.2

I got a great problem, there is an error on the insert of an object and I need to see the sql command. But the NHibernate is logging only the select commands. I put it to log everything and it's not working with these commands. Could you help me?


This is the configuration of log4net on my web.config:


<log4net>
<appender name="Console" type="log4net.Appender.ConsoleAppender">
<!--direct the log messages to the console error stream-->
<target value="Console.Error" />
<layout type="log4net.Layout.PatternLayout">
<!-- Pattern to output the caller's file name and line number -->
<conversionPattern value="%5level [%thread] (%file:%line) - %message%newline" />
</layout>
</appender>

<appender name="AspNetTraceAppender" type="log4net.Appender.AspNetTraceAppender" >
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
</layout>
</appender>

<appender name="NHibernateFileLog" type="log4net.Appender.RollingFileAppender">
<file value="Logs/nhibernate.txt" />
<appendToFile value="true" />
<rollingStyle value="Size" />
<maxSizeRollBackups value="10" />
<maximumFileSize value="1000KB" />
<staticLogFileName value="true" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%d{HH:mm:ss.fff} [%t] %-5p %c - %m%n" />
<!--<conversionPattern value="%date %level %thread %logger - %message%newline"/>-->
</layout>
</appender>

<appender name="GeneralLog" type="log4net.Appender.RollingFileAppender">
<file value="Logs/general.txt" />
<appendToFile value="true" />
<maximumFileSize value="100KB" />
<rollingStyle value="Size" />
<maxSizeRollBackups value="5" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%d{HH:mm:ss.fff} [%t] %-5p %c - %m%n" />
</layout>
</appender>

<appender name="DataLog" type="log4net.Appender.RollingFileAppender">
<file value="Logs/data.txt" />
<appendToFile value="true" />
<maximumFileSize value="100KB" />
<rollingStyle value="Size" />
<maxSizeRollBackups value="5" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%d{HH:mm:ss.fff} [%t] %-5p %c - %m%n" />
</layout>
</appender>

<!--levels: DEBUG, INFO, WARN, ERROR, FATAL-->

<root>
<level value="ALL"/>
<appender-ref ref="GeneralLog" />
</root>

<logger name="NHibernate">
<level value="DEBUG"/>
<appender-ref ref="NHibernateFileLog"/>
</logger>
<logger name="NHibernate">
<level value="ERROR"/>
<appender-ref ref="NHibernateFileLog"/>
</logger>
<logger name="NHibernate">
<level value="INFO"/>
<appender-ref ref="NHibernateFileLog"/>
</logger>
<logger name="NHibernate.Loader.Loader">
<level value="INFO" />
</logger>

<logger name="Pushable.Data" additivity="false">
<level value="DEBUG"/>
<appender-ref ref="DataLog"/>
</logger>
</log4net>



Thanks

Look, a friend is making an application with the same configuration I'm using but on desktop(mine is web). The console shows him everything I wanted to see including the insert/update statements with their parameters.

Don't you know how to make the web application generate a console too? Or at least the txt logs show me the insert/update statements with their parameters?

Thanks

Configure log4net to output NHibernate.SQL to the ASP.Net Trace, and enable tracing.

How can I do it?

It will make the SQL to output on console?