This content has been marked as final. Show 2 replies
Uncomment the following lines in your log4j.xml
<!-- Limit JBoss categories to INFO <category name="org.jboss"> <priority value="INFO"/> </category> --> <!-- Decrease the priority threshold for the org.jboss.varia category <category name="org.jboss.varia"> <priority value="DEBUG"/> </category> -->
Additionally also limit org.apache category to INFO. Make sure your appender (CONSOLE or FILE) has threshold set to DEBUG depending on where you want to log the SQL statements.
The 'org.jboss.varia' category should have been 'org.jboss.ejb.plugins.cmp'.