Disable NHibernate logging

nhibernate logging log4net
ripper234 picture ripper234 · Sep 23, 2009 · Viewed 19k times · Source

I have an empty app.config file, but I still get NHibernate debug logs

NHibernate: SELECT this_.LogID as LogID71_0_, this_.Level as Level71_0_, this_.Message as Message71_0_, this_.EventTime as EventTime71_0_, this_.Component as ...

I tried adding a log4net configuration with an ERROR log level, but no use. How can I stop these log messages?

The thing I'm puzzled about is why do these appear in the first place if I have an empty app.config to being with. It doesn't make sense to me that I have to configure it not to print these messaages - the default should be off. Could it be my code is setting them on programatically somehow? What should I look for?

Answer

kgiannakakis picture kgiannakakis · Sep 23, 2009

Configure Log4Net for use with NHibernate may be helpful.

You need to have both these loggers:

 <logger name="NHibernate">
   <level value="ERROR" />
 </logger>

 <logger name="NHibernate.SQL">
   <level value="ERROR" />
 </logger>

Related questions

How to log SQL calls with NHibernate to the console of Visual Studio?

I have the following configuration file for NHibernate: <?xml version="1.0" encoding="utf-8" ?> <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2"> <session-factory> <property name="connection.connection_string">Server=.\SQLEXPRESS;Database=mydb;Integrated Security=True;</property> &…

Read More
How to know query generated by Fluent NHibernate

I am using linq to Nhibernate to fire some select query to data base. My question is, how do I know, the query generated by Fluent NHibernate?

Read More
What are the First and Second Level caches in Hibernate?

Can anyone explain in simple words what First and Second Level caching in Hibernate are?

Read More