How can I watch SQL statement in a web application project. Set hibernate.show_sql property to true only work for Console application ?

Enable log4net and messages will be logged to a log file. Please read the documentation here:
http://www.hibernate.org/hib_docs/nhibe ... on-logging

Thank you.
I don't understand to which log file the messages are redirected. I think I can define it in the log4net section (in web.config), but I don't find how... Could you help me, please ?
But what about this file. I'll be modified each time a sql request is sent by nhibernate ? Wouldn't it be better to have those messages in the output window while debugging ?

I should have said "Enable log4net and messages will be logged to a destination of your choice". Either the ConsoleAppender or the TraceAppender will send the log messages to the output window (I forgot which one is which). See log4net's documentation here:
http://logging.apache.org/log4net/relea ... mples.html

I tried the ConsoleAppender, the OutputDebugStringAppender and the TraceAppender but none of them work.
Here is an extract of my config file :

<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
</configSections>

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

Do I forget something ?

Add this after the appender:

Sorry, but it doesn't chnage the problem. What more can I do ?

I assume you have read the documentation for log4net, haven't you? You can find it here:
http://logging.apache.org/log4net/relea ... ction.html

The section that is specific to configuration can be found here:
http://logging.apache.org/log4net/relea ... ation.html

I suspect you have not called the static method Configure() on one of the configuration classes; most typically the XmlConfigurator class. The \second link above should have all the information you need. Please have a read through it.

ok, it works. Thank you for your advices.
I'm surprised to see so many informations in the output window. Is there a way to just display the sql requests ? I read in you documentation that we can use filter. Which sort of filter you would use to reduce the number of informations display ? Which informations do you find usefull ?
For example, I get this :
NHibernate.Impl.SessionImpl: 2007-07-23 01:18:36,227 [11] DEBUG NHibernate.Impl.SessionImpl [(null)] - reading row
NHibernate.Type.Int32Type: 2007-07-23 01:18:36,227 [11] DEBUG NHibernate.Type.Int32Type [(null)] - returning '8' as column: Nutriment2_3_
NHibernate.Impl.SessionImpl: 2007-07-23 01:18:36,227 [11] DEBUG NHibernate.Impl.SessionImpl [(null)] - loading [Nutriment#8]
NHibernate.Impl.SessionImpl: 2007-07-23 01:18:36,227 [11] DEBUG NHibernate.Impl.SessionImpl [(null)] - attempting to resolve [Nutriment#8]
NHibernate.Impl.SessionImpl: 2007-07-23 01:18:36,227 [11] DEBUG NHibernate.Impl.SessionImpl [(null)] - resolved object in session cache [MyClassesTest.Nutriment#8]
Would you keep such informations ?

I am not familiar with log4net filters myself, so I don't have much advice to offer except to tell you to have a look at the docs; specifically here:
http://logging.apache.org/log4net/relea ... ml#filters