topic SQL debugging in Alfresco Forum

SQL debugging

jeffreyman — Wed, 17 Mar 2021 08:12:04 GMT

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

Re: SQL debugging

arjunmony — Wed, 17 Mar 2021 17:22:21 GMT

Hi Jeffrey,

Hope you are updating the log4j.properties in the below path,

/opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-log4j.properties

Re: SQL debugging

jeffreyman — Thu, 18 Mar 2021 10:55:35 GMT

Yes, we have added it, but no log.