KB-1495 How to enable SQL query statements in WebLogic logs

Purpose

The purpose of this article is to explain how to enable SQL logging in WebLogic to troubleshoot issues related to running SQL queries in Appian.

Instructions

1. Open the Administration Console of WebLogic. This is normally located at <WEBLOGIC_SERVER_FQDN>:7001/console.
2. In the left pane of the Administration Console, click on Servers.
3. Select the server that is running the Appian application (for example: AdminServer).
4. Select the Debug tab.
5. Click the WebLogic dropdown.
6. Click the JDBC dropdown.
7. Click the SQL dropdown.
8. Check the Debug JDBCSQL checkbox.
9. Click the Enable button.
10. This enables SQL statements to be printed on the YOUR_SERVER_NAME.log file, located in <DOMAIN_HOME>/servers/<SERVER_NAME>/logs/.

Note: These steps are subject to change. Please consult Oracle directly for any further assistance.

Affected Versions

This article applies to all versions of Appian using WebLogic as the application server.

Last Reviewed: February 2018