JBossAS 7/Wildfly 8/EAP 6 JPA, Transactions, JDBC tracing logging

jboss-wildfly-trasactions-logging.md

• JPA and JTA tarcing

<logger category="com.arjuna.ats.jta">
  <level name="TRACE"/>
</logger>
<logger category="org.jboss.as.jpa">
  <level name="DEBUG"/>
</logger>

• JDBC tracing:

<datasource jndi-name="java:jboss/datasources/..." pool-name="..." enabled="true" spy="true">
<logger category="jboss.jdbc.spy">
  <level name="TRACE"/>
</logger>

• Hibernate Tracing:

<logger category="org.hibernate.SQL">
  <level name="TRACE" />
</logger>

<logger category="org.hibernate">
  <level name="TRACE" />
</logger>
<logger category="org.infinispan">
  <level name="TRACE" />
</logger>

Reference:

• Wildfly JPA guide: https://docs.jboss.org/author/display/WFLY8/JPA+Reference+Guide#JPAReferenceGuide-Troubleshooting