I followed this post (and the links therein)

http://nhibernate.sourceforge.net/forum ... ht=log4net

and have a few questions. First, I want to disable DEBUG for NHibernate only, since it is crippling the server. I need to output DEBUG for my class library logging code.

To accomplish this I have configured log4net in the web.config with 1 appender, ADONetAppender and 2 loggers:



How can I get NHibernate to USE the logger specified above and not the root? Also, how do I get MY logging to use the 2nd logger there?

I have not been able to see any examples of this yet online.

Here's a section of our config:

The NHibernate.Loader.Loader logs the SQL sent to the server. Otherwise, the only messages from NHibernate are errors or fatals.

HTH

I actually did something very similar, except I wasn't sure if it was going to work.

If I have a logger named NHibernate, how do I configure nhibernate to use that logger instead of root?

I have my code using a different logger, so I can set the level on that to DEBUG, so for right now it's working, but I'm not sure if NHibernate is using the root logger or the "NHibernate" logger.

NHibernate.Loader.Loader ? that will output only SQL statements?

The logger name is matched against the class name you use in

So, the NHibernate logger applies to all (full) class names that start with NHibernate - the whole NHibernate assembly.

In my example, the logs generated by the NHibernate.Loader.Loader(.*) class(es) are logged if their log level is INFO or higher. There are DEBUG logs sent out by that class, but I am ignoring them by specifying INFO.

That's exactly what I needed to know, thanks!