Purpose
These steps enable to have SQL traces either in the Dashboard browsing or in the log file depending on logger.output.buffer parameter.
Applicable in CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1x | |
| 8.0.x | |
| 7.3.x | |
| 7.2.x | |
| 7.0.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS2 | |
| CSS1 | |
Details
These steps enable to have more details about SQL trace in the Dashboard browsing.
Stop TOMCAT service
Modify the web.xml file of the application by changing the logger.level.SQL value from 2 to 0
<context-param> <param-name>logger.level.SQL</param-name> <param-value>0</param-value> <description>SQL log level</description> </context-param>
- Restart CAST application of Tomcat server
Notes/comments
Please note that you must also activate logger.output.buffer () and logger.level.ROWREADER () if you want to get a readable input on the dashboard.
