title: Spring - Hibernate will show DEBUG, won't show sql
body: <p>I'm using Spring 3.x and Hibernate 4.x on my web project.</p>
  
  <p>The problem is it will show DEBUG messages but sql statements that I need for debugging.</p>
  
  <p>Here are my settings.</p>
  
  <p>spring-servlet.xml</p>
  
  <pre><code>&lt;!-- Session Factory --&gt;
      &lt;bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"&gt;
          &lt;property name="dataSource"&gt;
              &lt;ref bean="dataSource"/&gt;
          &lt;/property&gt;
  
          &lt;property name="configLocation"&gt;
              &lt;value&gt;classpath:hibernate.cfg.xml&lt;/value&gt;
          &lt;/property&gt;
  
          &lt;property name="hibernateProperties"&gt;
          &lt;props&gt;
              &lt;prop key="hibernate.show_sql"&gt;true&lt;/prop&gt;
          &lt;/props&gt;
      &lt;/property&gt;
  
      &lt;/bean&gt;
  
      &lt;!-- Data Source --&gt;
      &lt;bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"&gt;
          &lt;property name="driverClass" value="com.tmax.tibero.jdbc.TbDriver"/&gt;
          &lt;property name="jdbcUrl" value="****"&gt;&lt;/property&gt;
          &lt;property name="user" value="****"&gt;&lt;/property&gt;
          &lt;property name="password" value="****"&gt;&lt;/property&gt;
          &lt;property name="initialPoolSize"&gt;&lt;value&gt;3&lt;/value&gt;&lt;/property&gt;
          &lt;property name="minPoolSize"&gt;&lt;value&gt;3&lt;/value&gt;&lt;/property&gt;
          &lt;property name="maxPoolSize"&gt;&lt;value&gt;50&lt;/value&gt;&lt;/property&gt;
      &lt;/bean&gt; 
  </code></pre>
  
  <p>hibernate.cfg.xml</p>
  
  <pre><code>&lt;property name="dialect"&gt;org.hibernate.dialect.SQLServerDialect&lt;/property&gt;
  &lt;!-- Disable the second-level cache --&gt;
           &lt;property name="cache.provider_class"&gt;org.hibernate.cache.NoCacheProvider&lt;/property&gt;
  
           &lt;!-- Echo all executed SQL to stdout --&gt;
           &lt;property name="show_sql"&gt;true&lt;/property&gt;
  </code></pre>