SQL debugging

cancel
Showing results for 
Search instead for 
Did you mean: 
jeffreyman
Active Member II

SQL debugging

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

2 Replies
arjunmony
Active Member II

Re: SQL debugging

Hi Jeffrey,

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

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

jeffreyman
Active Member II

Re: SQL debugging

Yes, we have added it, but no log.