cant see sql parameters (in jboss , log4j.xml)

avihaimar77 · **Joined:** Wed May 02, 2007 2:42 pm **Posts:** 101

Hey,

I am using Jboss server.
I add to jboss.lo4j the following categories:

Code:

   <category name="org.hibernate">
      <priority value="DEBUG"/>
      <appender-ref ref="APPLICATIONNAME_FILE" />
   </category>
   
   <!-- Log SQL statements-->
   <category name="org.hibernate.SQL">
      <priority value="DEBUG"/>
      <appender-ref ref="APPLICATIONNAME_FILE" />
   </category>
    
   <!-- Log the values assigned to the SQL parameters and results -->
   <category name="org.hibernate.type">
      <priority value="DEBUG"/>
      <appender-ref ref="APPLICATIONNAME_FILE" />
   </category>

It prints the sql and other stuff , but it dosnt print the parameters.

Can you please help?

Thank you

avihaimar77 · **Joined:** Wed May 02, 2007 2:42 pm **Posts:** 101

Does any one try to debud with log4j.xml?

cbredesen · **Posted:** Tue Jul 17, 2007 4:33 pm

I have heard stories of this happening before -- specifically inside JBAS. I haven't found an explanation or a fix for it yet.

-Chris

cbredesen · **Posted:** Tue Jul 24, 2007 11:44 am

It turns out that org.hibernate.type.NullableType caches the "isTraceEnabled" value as a performance fix. This means that if you did not start your JBAS with org.hibernate.type=DEBUG it will never log at the DEBUG level. The code is commented as such:

http://anonsvn.jboss.org/repos/hibernat ... eType.java

Start your server with this setting already in log4j.xml and you should see the parameter bindings.

-Chris

avihaimar77 · **Joined:** Wed May 02, 2007 2:42 pm **Posts:** 101

Thank you for your answer.

But, this dosnt sove the problem.

it print the sql but without the binding params.

cbredesen · **Posted:** Tue Sep 11, 2007 1:47 pm

Look in your JMX console and find the logging level for that category. It will tell you the REAL log level at runtime. It should be DEBUG. Are you sure you're looking at the right log file? Do your SQL's have "Hibernate:" in front of them? If so, you're seeing the old system.out SQL printing, not the one from Log4J.

-Chris

christian · **Posted:** Tue Sep 11, 2007 1:52 pm

Folks, just put your log level for that category in TRACE. And drop that crap default jboss-log4j.xml file and replace it with this:

Code:

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="false">

    <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
        <errorHandler class="org.jboss.logging.util.OnlyOnceErrorHandler"/>
        <param name="Target" value="System.out"/>
        <layout class="org.apache.log4j.PatternLayout">
            <!-- The default pattern: Date Priority [Category] Message\n -->
            <param name="ConversionPattern" value="(%thread) %d{ABSOLUTE} %-5p [%c{1}] %m%n"/>
        </layout>
    </appender>

    <category name="org.hibernate">
        <priority value="INFO"/>
    </category>
    <category name="org.hibernate.SQL">
        <priority value="TRACE"/>
    </category>
    <category name="org.hibernate.type">
        <priority value="TRACE"/>
    </category>

    <root>
        <priority value="INFO"/>
        <appender-ref ref="CONSOLE"/>
    </root>

</log4j:configuration>

n2 · **Posted:** Thu Sep 20, 2007 11:36 am

@christian:

Thanks for your help.I used your log4j.xml without success: Still the same: sql is logged but no parameters.
I am using:
* Hibernate 3.1.3
* JBoss 4.0.5.GA
* Java 6
* Linux

Do you have any idea?

n2 · **Posted:** Thu Sep 20, 2007 11:58 am

Strange: I tried it with JBoss-4.0.2/Java-1.4 and it works! JBoss is the bad boy...

log4j.xml:

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="false">
   <!-- ================================= -->
   <!-- Preserve messages in a local file -->
   <!-- ================================= -->
   
   <!-- A time/date based rolling appender -->
   <appender name="FILE" class="org.jboss.logging.appender.DailyRollingFileAppender">
      <param name="File" value="${jboss.server.home.dir}/log/server.log"/>
      <param name="Append" value="false"/>
      <!-- Rollover at midnight each day -->
      <param name="DatePattern" value="'.'yyyy-MM-dd"/>
      <!-- Rollover at the top of each hour
      <param name="DatePattern" value="'.'yyyy-MM-dd-HH"/>
      -->
      <layout class="org.apache.log4j.PatternLayout">
         <!-- The default pattern: Date Priority [Category] Message\n -->
         <param name="ConversionPattern" value="%d %-5p [%c] %m%n"/>
         <!-- The full pattern: Date MS Priority [Category] (Thread:NDC) Message\n
         <param name="ConversionPattern" value="%d %-5r %-5p [%c] (%t:%x) %m%n"/>
         -->
      </layout>
   </appender>

   <!-- ============================== -->
   <!-- Append messages to the console -->
   <!-- ============================== -->
   
   <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
      <errorHandler class="org.jboss.logging.util.OnlyOnceErrorHandler"/>
      <param name="Target" value="System.out"/>
      <param name="Threshold" value="INFO"/>
      
      <layout class="org.apache.log4j.PatternLayout">
         <!-- The default pattern: Date Priority [Category] Message\n -->
         <param name="ConversionPattern" value="%d{ABSOLUTE} %-5p [%c{1}] %m%n"/>
      </layout>
   </appender>

   <!-- ================ -->
   <!-- Limit categories -->
   <!-- ================ -->
   
  <category name="org.hibernate.SQL">
    <priority value="DEBUG"/>
  </category>
  
  <category name="org.hibernate.type">
    <priority value="DEBUG"/>
  </category>
   <!-- ======================= -->
   <!-- Setup the Root category -->
   <!-- ======================= -->

   <root>
      <!-- Log levels: DEBUG, INFO, WARN, ERROR -->
      <priority value="WARN"/>
      <!-- Logger: FILE, DEPLOY, HIBERNATE, PERSISTENCE, CONSOLE -->
      <appender-ref ref="FILE"/>
   </root>

</log4j:configuration>