topic Re: sql query debug in Alfresco Archive

sql query debug

darminm — Mon, 18 Apr 2016 20:30:32 GMT

Does Alfresco allow for debugging all queries?I tried adding the following to Alfresco log4j.properties:log4j.logger.com.ibatis=DEBUGlog4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUGlog4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUGlog4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClient

Re: sql query debug

afaust — Tue, 19 Apr 2016 08:01:26 GMT

Full JDBC logging is only possible by using a special JDBC driver wrapper that enables you to capture every statement. This could be achieved by using <a href="https://p6spy.github.io/p6spy/2.0/install.html">P6Spy</a> which I regularly use for any low-level logging needs.

Re: sql query debug

darminm — Tue, 19 Apr 2016 21:20:24 GMT

I am trying to do that per https://wiki.alfresco.com/wiki/Driver-side_DB_Query_Profiling

however I get no log.

I am using:

Alfresco 5.0.2 enterprise
p6spy.jar (v2.2.0)
sqljdbc42.jar

### spy.properties in tomcat/shared/classes:

module.log=com.p6spy.engine.logging.P6LogFactory
realdriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
autoflush=true
excludecategories=
appender=com.p6spy.engine.logging.appender.FileLogger
logfile=D:\Alfresco\tomcat\logs\logsspy.log
deregisterdrivers=true

### alfresco-global.properties
#db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
db.driver=com.p6spy.engine.spy.P6SpyDriver

Alfresco starts up fine…

Re: sql query debug

afaust — Wed, 20 Apr 2016 09:17:09 GMT

The wiki page is outdated. Please refer to the actual P6Spy documentation that corresponds to your version of P6Spy. The contents for the configuration file have changed a lot since the wiki page was written.

Re: sql query debug

vincent-kali — Mon, 01 Jan 2018 16:25:06 GMT

I needed to modify both db.driver and db.url to get P6 log:

### database connection properties ###
#db.driver=org.postgresql.Driver
db.driver=com.p6spy.engine.spy.P6SpyDriver
db.username=alfresco
db.password=*****

db.name=alfresco
#db.url=jdbcostgresql://localhost:5432/${db.name}
db.url=jdbc6spyostgresql://localhost:5432/${db.name}

Re: sql query debug

douglascrp — Thu, 04 Jan 2018 17:07:20 GMT

The following is the most up to date blog post on the topic that I know about:

https://www.ziaconsulting.com/developer-help/setting-p6spy-alfresco/