SQL debugging

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2021 04:12 AM
How to debug database access (i.e. SQL)? I have added the following in log4j.properties, but no log.
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
Labels:
- Labels:
-
Alfresco Content Services
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2021 01:22 PM
Hi Jeffrey,
Hope you are updating the log4j.properties in the below path,
/opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-log4j.properties

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2021 06:55 AM
Yes, we have added it, but no log.
