You are currently reviewing an older revision of this page.
In certain troubleshooting scenarios, it may be necessary to retrieve the details of database queries that are being performed by Appian. This article details how to enable Hibernate Tracing, which results in the queries made by Appian being logged to the JBoss or WebLogic server logs.
To enable Hibernate Tracing:
<APPIAN_HOME>/ear/suite.ear/resources
# Output SQL statements log4j.logger.org.hibernate.SQL=DEBUG # Output param values within SQL statements log4j.logger.org.hibernate.type=TRACE
DEBUG
TRACE
# Output SQL statements log4j.logger.org.hibernate.SQL=ERROR # Output param values within SQL statements log4j.logger.org.hibernate.type=ERROR
Some things to note after following these steps:
This article applies to all on-premise installations of Appian.
Last Reviewed: May 2016