log4j.xml中配置hibernate输出

在log4j.xml文件中加上，必须在<root>节点前！表示输出hibernate产生所有的信息
<!-- hibernate -->
<logger name="org.hibernate">
<level value="ALL" />
<appender-ref ref="console"/>
</logger>
参照表：
Category Function

org.hibernate.SQL Log all SQL DML statements as they are executed
org.hibernate.type Log all JDBC parameters
org.hibernate.tool.hbm2ddl Log all SQL DDL statements as they are executed
org.hibernate.pretty Log the state of all entities (max 20 entities) associated with the session at flush time
org.hibernate.cache Log all second-level cache activity
org.hibernate.transaction Log transaction related activity
org.hibernate.jdbc Log all JDBC resource acquisition
org.hibernate.hql.ast.AST Log HQL and SQL ASTs during query parsing
org.hibernate.secure Log all JAAS authorization requests
org.hibernate Log everything (a lot of information, but very useful for troubleshooting)
需要单独配置某个输出，不使用org.hibernate，eg：
<logger name="org.hibernate.sql" additivity="true">
<level value="DEBUG"/>
<appender-ref ref="console"/>
</logger>
表示debug级别输出DML产生的sql语句。参考老外地址http://stackoverflow.com/questions/436276/configuring-hibernate-logging-using-log4j-xml-config-file