CAST Engineering Dashboard - Information - Configuring Dashboard to SQL trace

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

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1x✅
8.0.x✅
7.3.x✅
7.2.x✅
7.0.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS2✅
CSS1✅

Details

These steps enable to have more details about SQL trace in the Dashboard browsing.

  1. Stop TOMCAT service

  2. Modify the web.xml file of the application by changing the logger.level.SQL value from 2 to 0

logger.level.SQL 0 SQL log level ``` 3. 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.