Edit JBOSS_HOME\standalone\configuration\standalone.xml:
Add these lines under logging module;
<logger category=”org.hibernate.SQL”>
<level name=”DEBUG”/>
</logger>
<logger category=”org.hibernate.type”>
<level name=”TRACE”/>
</logger>
<logger category=”org.hibernate.hql.ast.AST”>
<level name=”INFO”/>
</logger>
<logger category=”org.hibernate.tool.hbm2ddl”>
<level name=”WARN”/>
</logger>
<logger category=”org.hibernate.hql”>
<level name=”DEBUG”/>
</logger>
<logger category=”org.hibernate.cache”>
<level name=”INFO”/>
</logger>
<logger category=”org.hibernate.jdbc”>
<level name=”DEBUG”/>
</logger>