These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 6 posts ] 
  Previous topic | Next topic 
Author Message
Raul
 Post subject: Logging Queries
PostPosted: Mon Dec 04, 2006 4:56 am 
Beginner
Beginner

Joined: Fri Dec 01, 2006 5:16 am
Posts: 23
Location: India
Hi,

I want to log queries that Nhibernate generates, each time it queries the backend.
I Tried using Log4net, however log4net logs all type of operations, since the data inside it does not have a specific format, it become difficult to extract the query from it.

Looking fwd for some interesting insights.

Regards,
Raul D'souza
Top
 Profile  
 
floda
 Post subject:
PostPosted: Mon Dec 04, 2006 5:55 am 
Newbie

Joined: Mon Mar 27, 2006 10:24 am
Posts: 8
Location: Malmoe, Sweden
I use this config and it reduces the log a little:

Code:
   <appender name="nHibernateAppender" type="log4net.Appender.RollingFileAppender">
      <file value="log\\nhibernate.log" />
      
      <appendToFile value="true" />
      <rollingStyle value="Size" />
      <maxSizeRollBackups value="10" />
      <maximumFileSize value="1MB" />

      <layout type="log4net.Layout.PatternLayout">
         <conversionPattern value="%date [%thread] %-5level  %logger - %message%newline" />   
      </layout>
   </appender>


Code:
   <logger name="NHibernate.Impl.BatcherImpl">
      <level value="DEBUG"/>
      <appender-ref ref="nHibernateAppender" />
   </logger>
Top
 Profile  
 
Raul
 Post subject: Re: Logging Queries
PostPosted: Mon Dec 04, 2006 7:14 am 
Beginner
Beginner

Joined: Fri Dec 01, 2006 5:16 am
Posts: 23
Location: India
Raul wrote:
Hi,

Hi,

This definetly reduces the log entries by 50 %, however the problem is still not solved.

Regards
Raul

I want to log queries that Nhibernate generates, each time it queries the backend.
I Tried using Log4net, however log4net logs all type of operations, since the data inside it does not have a specific format, it become difficult to extract the query from it.

Looking fwd for some interesting insights.

Regards,
Raul D'souza
Top
 Profile  
 
nokiola
 Post subject:
PostPosted: Mon Dec 04, 2006 9:11 am 
Beginner
Beginner

Joined: Sun Jun 19, 2005 2:21 pm
Posts: 21
I am using the following setup to filter out NHibernate logging. Maybe it can serve as startup for what you want to achieve.

Code:
   <appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">
      <param name="File" value="logs\file.log" />
      <param name="AppendToFile" value="false" />
      <param name="MaxSizeRollBackups" value="10" />
      <param name="MaximumFileSize" value="10000000" />
      <param name="RollingStyle" value="Size" />
      <param name="StaticLogFileName" value="true" />
      <layout type="log4net.Layout.PatternLayout">
        <param name="ConversionPattern" value="%d [%t] %-5p %-40c [%x] - %m%n" />
      </layout>
      <filter type="log4net.Filter.LoggerMatchFilter">
          <loggerToMatch value="NHibernate." />
          <acceptOnMatch value="false" />
      </filter>
      <filter type="log4net.Filter.LoggerMatchFilter">
          <loggerToMatch value="Nullables." />
          <acceptOnMatch value="false" />
      </filter>

    </appender>
   <root>
      <level value="ALL"/>
      <priority value="DEBUG" />
      <appender-ref ref="RollingFileAppender" />
   </root>
Top
 Profile  
 
Raul
 Post subject: Re:Logging Queries
PostPosted: Tue Dec 05, 2006 9:24 am 
Beginner
Beginner

Joined: Fri Dec 01, 2006 5:16 am
Posts: 23
Location: India
Nokialo i would like to thank you for yr help.It is very helpful, However i am still not getting the desired result? Is it possible to have filters on the message? Creating filter on the logger is not giving me the desired results
do u have any idea where can i get documentation on this?

Thanks & Regards,
Raul
Top
 Profile  
 
onevextchuck
 Post subject:
PostPosted: Tue Dec 05, 2006 12:36 pm 
Beginner
Beginner

Joined: Wed Nov 29, 2006 5:33 pm
Posts: 28
Location: Chicago, IL
Here is our Log4Net setup. The important part to note is that the logger name is set to "NHibernate.SQL".
Code:

   <log4net>
      <appender name="NHibernate.SQL" type="log4net.Appender.RollingFileAppender,log4net">
         <param name="File" value="Logs/NHibernate.Sql"/>
         <appendToFile value="true"/>
         <rollingStyle value="Composite"/>
         <maximumFileSize value="100KB"/>
         <maxSizeRollBackups value="2"/>
         <param name="DatePattern" value=".yyyy.MM.dd'.log'"/>
         <param name="StaticLogFileName" value="false"/>
         <layout type="log4net.Layout.PatternLayout,log4net">
            <conversionPattern value="%date [%thread] %-5level %logger [%ndc] - %message%newline"/>
         </layout>
      </appender>
      <logger name="NHibernate.SQL">
         <level value="Off"/>
         <appender-ref ref="NHibernate.SQL"/>
      </logger>
   </log4net>


Hope this helps.

Chuck

Edit: Oh and set the level of the logger to "Debug". We just have it turned off at the moment.
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 6 posts ] 

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.