DRAFT KB-XXXX Enabling Sql Query Statement in Weblogic

Purpose

The purpose of this article is for troubleshooting queries (sql statements) in weblogic.

Instructions

1. Use your browser to go to the Administration console of Weblogic. This is normally located at localhost:7001/console
2. On the left pane in the administration console, click on Servers.
3. Click on the server that is running the Appian application. (for example AdminServer)
4. Click on the debug tab.
5. Click the Dropdown on the weblogic scope, then dropdown the jdbc scope, and then dropdown the sql scope.
6. Click the checkbox for Debug JDBCSQL
7. Click enable.
8. This enables sql statements to be printed on the YOUR_SERVER_NAME.log file..