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 ****
    

    
!     
      

      
        
        

      
    

--- 61,79 ----
    

    
!     
!     
      

      
        
        

      
+
+     
+       
+     
+
    

If you want to log Hibernate SQL statements:

If you want to log everything Hibernate’s doing, including SQL statements, schema export, transactions, etc.: