title: Enable Hibernate logging
body: <p>I'm trying to create a log of hibernate statements.
  I perform my sql statements using JPA where Hibernate 2.0 is the persistence provider (my application server is JBoss AS 6.0).
  I call my CRUD methods using the EntityManager interface provided by EJB 3.0.
  I read many posts about enabling hinernate logging but actually i can't see any log :-(
  I create a log4j.properties file and I put it in the root folder of my Netbeans project.
  I put also log4j library in the classpath of the project.
  My log4j.properties s the following:</p>
  
  <pre><code>### direct log messages to stdout ###
  log4j.appender.stdout=org.apache.log4j.ConsoleAppender
  log4j.appender.stdout.Target=System.out
  log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
  log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L – %m%n
  
  
  log4j.rootLogger=debug, stdout
  
  log4j.logger.org.hibernate=info
  
   ### log just the SQL
  log4j.logger.org.hibernate.SQL=debug
  
  ### log JDBC bind parameters ###
  log4j.logger.org.hibernate.type=info
  
  ### log schema export/update ###
  log4j.logger.org.hibernate.tool.hbm2ddl=info
  
  ### log HQL parse trees
  #log4j.logger.org.hibernate.hql=debug
  
  ### log cache activity ###
  log4j.logger.org.hibernate.cache=info
  
  ### log transaction activity
  #log4j.logger.org.hibernate.transaction=debug
  
  ### log JDBC resource acquisition
  #log4j.logger.org.hibernate.jdbc=debug
  </code></pre>
  
  <p>Why can't I see the log informations?
  I would like see values in sql where clauses or in insert statements (actually I see only some '?')
  Thanks in advance.</p>
  
  <p>For clarity I put below the folder structure of my project:</p>
  
  <pre><code>MyProject
  ¦   build.xml
  ¦   log4j.properties
  ¦
  +---build
  ¦   ¦   capitolo2-ejb.jar
  ¦   ¦   capitolo2-war.war
  ¦   ¦   JBoss4.dpf
  ¦   ¦
  ¦   +---lib
  ¦   ¦       log4j-1.2.15.jar
  ¦   ¦       slf4j-api.jar
  ¦   ¦       slf4j-jboss-logmanager.jar
  ¦   ¦
  ¦   +---META-INF
  ¦           chapter2-hornetq-jms.xml
  ¦           jboss-app.xml
  ¦           log4j.properties
  ¦           MANIFEST.MF
  ¦
  +---capitolo2-ejb
  ¦   ¦   build.xml
  ¦   ¦   
  ¦   ¦
  ¦   +---build
  ¦   ¦   +---classes
  ¦   ¦   ¦   ¦   .netbeans_automatic_build
  ¦   ¦   ¦   ¦   .netbeans_update_resources
  ¦   ¦   ¦   ¦
  ¦   ¦   ¦   +---ejb
  ¦   ¦   ¦   ¦   +---com
  ¦   ¦   ¦   ¦       +---ejb3inaction
  ¦   ¦   ¦   ¦           +---actionbazaar
  ¦   ¦   ¦   ¦               +---buslogic
  ¦   ¦   ¦   ¦               ¦       BillingException.class
  ¦   ¦   ¦   ¦               ¦       OrderBillingMDB.class
  ¦   ¦   ¦   ¦               ¦       PlaceBid.class
  ¦   ¦   ¦   ¦               ¦       PlaceBidBean.class
  ¦   ¦   ¦   ¦               ¦       PlaceOrder.class
  ¦   ¦   ¦   ¦               ¦       PlaceOrderBean.class
  ¦   ¦   ¦   ¦               ¦
  ¦   ¦   ¦   ¦               +---persistence
  ¦   ¦   ¦   ¦                       Bid.class
  ¦   ¦   ¦   ¦                       BillingInfo.class
  ¦   ¦   ¦   ¦                       Order.class
  ¦   ¦   ¦   ¦                       OrderStatus.class
  ¦   ¦   ¦   ¦                       ShippingInfo.class
  ¦   ¦   ¦   ¦
  ¦   ¦   ¦   +---META-INF
  ¦   ¦   ¦           beans.xml
  ¦   ¦   ¦           jboss.xml
  ¦   ¦   ¦           MANIFEST.MF
  ¦   ¦   ¦           persistence.xml
  ¦   ¦   ¦
  ¦   ¦   +---empty
  ¦   ¦   +---generated-sources
  ¦   ¦       +---ap-source-output
  ¦   +---dist
  ¦   ¦       capitolo2-ejb.jar
  ¦   ¦
  ¦   +---lib
  ¦   ¦       log4j-1.2.15.jar
  ¦   ¦
  ¦   +---nbproject
  ¦   ¦   ¦   ant-deploy.xml
  ¦   ¦   ¦   build-impl.xml
  ¦   ¦   ¦   genfiles.properties
  ¦   ¦   ¦   project.properties
  ¦   ¦   ¦   project.xml
  ¦   ¦   ¦
  ¦   ¦   +---private
  ¦   ¦           private.properties
  ¦   ¦           private.xml
  ¦   ¦
  ¦   +---setup
  ¦   ¦       jboss-ds.xml
  ¦   ¦
  ¦   +---src
  ¦       +---conf
  ¦       ¦       beans.xml
  ¦       ¦       jboss.xml
  ¦       ¦       MANIFEST.MF
  ¦       ¦       persistence.xml
  ¦       ¦
  ¦       +---java
  ¦           +---ejb
  ¦               +---com
  ¦                   +---ejb3inaction
  ¦                       +---actionbazaar
  ¦                           +---buslogic
  ¦                           ¦       BillingException.java
  ¦                           ¦       OrderBillingMDB.java
  ¦                           ¦       PlaceBid.java
  ¦                           ¦       PlaceBidBean.java
  ¦                           ¦       PlaceOrder.java
  ¦                           ¦       PlaceOrderBean.java
  ¦                           ¦
  ¦                           +---persistence
  ¦                                   Bid.java
  ¦                                   BillingInfo.java
  ¦                                   Order.java
  ¦                                   OrderStatus.java
  ¦                                   ShippingInfo.java
  ¦
  +---capitolo2-war
  ¦   ¦   build.xml
  ¦   ¦
  ¦   +---build
  ¦   ¦   +---empty
  ¦   ¦   +---generated-sources
  ¦   ¦   ¦   +---ap-source-output
  ¦   ¦   +---lib
  ¦   ¦   ¦       log4j-1.2.15.jar
  ¦   ¦   ¦       slf4j-api.jar
  ¦   ¦   ¦       slf4j-jboss-logmanager.jar
  ¦   ¦   ¦
  ¦   ¦   +---web
  ¦   ¦       ¦   index.jsp
  ¦   ¦       ¦
  ¦   ¦       +---META-INF
  ¦   ¦       ¦       MANIFEST.MF
  ¦   ¦       ¦
  ¦   ¦       +---WEB-INF
  ¦   ¦           ¦   beans.xml
  ¦   ¦           ¦   jboss-web.xml
  ¦   ¦           ¦
  ¦   ¦           +---classes
  ¦   ¦               ¦   .netbeans_automatic_build
  ¦   ¦               ¦   .netbeans_update_resources
  ¦   ¦               ¦
  ¦   ¦               +---it
  ¦   ¦                   +---myservlets
  ¦   ¦                           PlaceBidServlet.class
  ¦   ¦                           PlaceOrderServlet.class
  ¦   ¦
  ¦   +---dist
  ¦   ¦       capitolo2-war.war
  ¦   ¦
  ¦   +---nbproject
  ¦   ¦   ¦   ant-deploy.xml
  ¦   ¦   ¦   build-impl.xml
  ¦   ¦   ¦   genfiles.properties
  ¦   ¦   ¦   project.properties
  ¦   ¦   ¦   project.xml
  ¦   ¦   ¦
  ¦   ¦   +---private
  ¦   ¦           private.properties
  ¦   ¦           private.xml
  ¦   ¦
  ¦   +---setup
  ¦   ¦       jboss-ds.xml
  ¦   ¦
  ¦   +---src
  ¦   ¦   +---conf
  ¦   ¦   ¦       MANIFEST.MF
  ¦   ¦   ¦
  ¦   ¦   +---java
  ¦   ¦       +---it
  ¦   ¦           +---myservlets
  ¦   ¦                   PlaceBidServlet.java
  ¦   ¦                   PlaceOrderServlet.java
  ¦   ¦
  ¦   +---web
  ¦       ¦   index.jsp
  ¦       ¦
  ¦       +---WEB-INF
  ¦               beans.xml
  ¦               jboss-web.xml
  ¦
  +---dist
  ¦       capitolo2.ear
  ¦
  +---nbproject
  ¦   ¦   ant-deploy.xml
  ¦   ¦   build-impl.xml
  ¦   ¦   genfiles.properties
  ¦   ¦   project.properties
  ¦   ¦   project.xml
  ¦   ¦
  ¦   +---private
  ¦           private.properties
  ¦
  +---setup
  ¦       jboss-ds.xml
  ¦       jboss4-netbeans-destinations-service.xml
  ¦       log4j.properties
  ¦
  +---src
      +---conf
              chapter2-hornetq-jms.xml
              jboss-app.xml
              log4j.properties
              MANIFEST.MF
  </code></pre>