SQL debugging

[jeffreyman]

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

[arjunmony]

Hi Jeffrey,

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

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

[jeffreyman]

Yes, we have added it, but no log.