Help

SQL debugging

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jeffreyman
Active Member II
‎17 Mar 2021 8:12 AM

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

Labels
0 Kudos
2 Replies
arjunmony
Established Member
‎17 Mar 2021 5:22 PM

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

0 Kudos
jeffreyman
Active Member II
‎18 Mar 2021 10:55 AM

Re: SQL debugging

Yes, we have added it, but no log.

0 Kudos
Alfresco Content Services Forum

Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.

Related links:

Related Articles

Debug API call - sql statement

VS
VS Active Member II
0

We use cookies on this site to enhance your user experience

By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods).   If you are not ok with these terms, please do not use this website.