blocks|key|3301087|text|Configure+Log4Net+for+use+with+NHibernate可能会有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3301088|您需要拥有这两个记录器：|3301089|+<logger+name="NHibernate">
+++<level+value="ERROR"+/>
+</logger>

+<logger+name="NHibernate.SQL">
+++<level+value="ERROR"+/>
+</logger>|code-block|syntax|javascript|3301090|entityMap|0|LINK|mutability|MUTABLE|url|http://nhibernate.info/doc/howto/various/configure-log4net-for-use-with-nhibernate^0|0|15|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

<a href="http://nhibernate.info/doc/howto/various/configure-log4net-for-use-with-nhibernate" rel="noreferrer">Configure Log4Net for use with NHibernate</a> may be helpful.

You need to have both these loggers:

<pre><code> &lt;logger name="NHibernate"&gt;
 &lt;level value="ERROR" /&gt;
 &lt;/logger&gt;

 &lt;logger name="NHibernate.SQL"&gt;
 &lt;level value="ERROR" /&gt;
 &lt;/logger&gt;
</code></pre>

blocks|key|329431|text|是否要在NHibernate级别或Log4Net级别禁用日志记录？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|329432|我通过将"show_sql“变量设置为false来执行前一种操作。我现在正在用C#以编程的方式完成这项工作，但我假设这也可以很容易地放入XML配置文件中。|329433|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Do you want to disable the logging at the NHibernate level or the Log4Net level?

I'm doing the former by setting "show_sql" variable to false. I'm doing this programmatically in C# right now, but I assume this would be easy to put in an XML configuration file as well.

blocks|key|327983|text|您使用的是NUnit+2.4.6吗？我昨天读了this的博客文章，上面说这个版本的NUnit将log4net设置为使用调试级日志记录，这也会影响NHibernate。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|327984|如果不是NUnit，也不是你，我会检查你使用的是不是其他的第三方库。|327985|编辑|style|BOLD|327986|转念一想，我不认为输出与log4net有什么关系。该格式看起来更像是"show_sql“控制的输出。我会检查两件事:+1.如果正确的(带有show_sql=false的)+hibernate.config被复制到您的执行目录中。2.如果未在代码中手动重写show_sql配置属性。|327987|entityMap|0|LINK|mutability|MUTABLE|url|http://davybrion.com/blog/2009/06/avoid-using-nhibernate-with-nunit-2-4-6/^0|N|4|0|0|0|0|2|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|Y|8|@$A|Z|B|10|H|I]]|9|@]|C|$]]|$1|J|3|K|5|6|7|11|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]]]

Are you using NUnit 2.4.6? I read <a href="http://davybrion.com/blog/2009/06/avoid-using-nhibernate-with-nunit-2-4-6/" rel="nofollow noreferrer">this</a> blog post yesterday which says that this version of NUnit sets log4net to use DEBUG level logging, effecting NHibernate as well.

if it's not NUnit and it's not you, I would check if it's some other 3rd party library that you're using.

EDIT

On second thought, I don't think that the output has something to do with log4net. the format looks more like the "show_sql" controlled output. I would check two things:
1. If the correct (the one with the show_sql=false) hibernate.config is copied to your execution directory.
2. If the show_sql configuration property is not overridden manually in your code.

blocks|key|3088237|text|问题出在“我的代码”中的某个地方。我们手动构建NHibernate配置(将show_sql标志设置为true)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3088238|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The problem was somewhere in "my code". We build the NHibernate configuration manually (setting the show_sql flag to true).

blocks|key|327999|text|return+Fluently.Configure()
++++++++++++.Database(MsSqlConfiguration.MsSql2005.ConnectionString(
++++++++++++++++c+=>+c.FromConnectionStringWithKey("MyDB")).ShowSql())|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|328000|删除.ShowSql()对我来说很有效|unstyled|offset|length|style|CODE|328001|entityMap^0|0|2|A|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>return Fluently.Configure()
 .Database(MsSqlConfiguration.MsSql2005.ConnectionString(
 c =&gt; c.FromConnectionStringWithKey("MyDB")).ShowSql())
</code></pre>

Removing the <code>.ShowSql()</code> worked for me

blocks|key|330621|text|对我来说，这是NUnit的问题。在TeamCity中运行测试时发生了额外的日志记录，该测试必须使用不同版本的nunit|type|unstyled|depth|inlineStyleRanges|entityRanges|data|330622|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For me it was the NUnit problem. The extra logging was happening when running the tests in TeamCity which must have been using a different version of nunit

blocks|key|328012|text|NHibernate日志对我帮助不大...我更喜欢这些设置：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|328013|++++<logger+name="NHibernate">
++++++<level+value="OFF"+/>
++++</logger>

++++<logger+name="NHibernate.SQL">
++++++<level+value="OFF"+/>
++++</logger>|code-block|syntax|javascript|328014|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The NHibernate logs don't help me much... I like these settings better:

<pre><code> &lt;logger name="NHibernate"&gt;
 &lt;level value="OFF" /&gt;
 &lt;/logger&gt;

 &lt;logger name="NHibernate.SQL"&gt;
 &lt;level value="OFF" /&gt;
 &lt;/logger&gt;
</code></pre>

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

<pre><code>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 ...
</code></pre>

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?

Disable NHibernate logging

我有一个空的 app.config文件，但我仍然获得NHibernate调试日志NHibernate: SELECT this_.LogID as LogID71_0_, this_.Level as Level71_0_, this_.Message as Message71_0_, this_.EventTime ...

问禁用NHibernate日志记录
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问禁用NHibernate日志记录EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问禁用NHibernate日志记录
EN