- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] Is there a way to check the adapter connected to the database or the SQL statement (query) issued to the repository DB?
Search via FAQ No.
NEW
[DataSpider Servista] Is there a way to check the adapter connected to the database or the SQL statement (query) issued to the repository DB?
Please tell me how to check the adapter connected to the database or the SQL statement (query) issued to the repository DB?
- Category :
Answer
■Specification
By setting the log level to DEBUG, SQL issued by DataSpiderServer can be output to the log.
▼SQL statement issued to repository DB and SQL statement issued from adapter
Change the server.log log level to DEBUG.
*For the change procedure, please check the following part of the online help
[Dslog] in [Properties Reference]-[Server Properties File]-[dslog.properties]
▼SQL statement issued by operation
Change the log level of XML log to DEBUG
Execute the test execution after setting the log level of the XML log to "DEBUG" in [Tool menu]-[Log] of the designer of Studio.
* For the change procedure, please check the following part of the online help
"Log" in [Designer]-[Menu]-[Tool Menu]
■Noted
If you set the log level to DEBUG, it is expected that the size of the log file will grow due to the increase in the large amount of log output.
Please execute after confirming the free space of the disk to which the execution log is output.
Reference information
- [Property Reference]-[Server Property File]-[dslog.properties]
https://www.hulft.com/help/en-us/DataSpider/dss42sp2/help/en/servista/properties_reference.html#server.log
- [Designer]-[Menu]-[Tool Menu]