Edit the log4j.xml
in the conf
directory as shown below to turn on SQL debugging of the JDBC CMP plugin.
/apps/jboss/server/default/conf :->diff -c log4j.xml~ log4j.xml *** log4j.xml~ Mon Sep 30 18:09:27 2002 --- log4j.xml Tue Apr 4 20:41:18 2006 *************** *** 61,73 **** <!-- ============================== --> <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender"> ! <param name="Threshold" value="INFO"/> <param name="Target" value="System.out"/> <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> --- 61,79 ---- <!-- ============================== --> <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender"> ! <!--<param name="Threshold" value="INFO"/>--> ! <param name="Threshold" value="DEBUG"/> <param name="Target" value="System.out"/> <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> + + <category name="org.jboss.ejb.plugins.cmp.jdbc"> + <priority value="DEBUG"/> + </category> + </appender>
If you want to log Hibernate SQL statements:
<category name="org.hibernate.SQL"> <priority value="DEBUG"/> </category>
If you want to log everything Hibernate’s doing, including SQL statements, schema export, transactions, etc.:
<category name="org.hibernate.SQL"> <priority value="DEBUG"/> </category>
There’s no difference in the XML snippets for logging SQL and everything.