Home › Support › Knowledge Base ›

Enabling Database Connection Pool Debugging

Knowledge Base: Academus 2.0, Academus 2.1
Submitted: December 20, 2007
How do I enable debugging options for the Academus database resource pool?

Academus 2.1

  • Edit $TOMCAT_HOME/webapps/portal/WEB-INF/classes/log4j.properties
    • Add the following line at the end of the file: log4j.logger.net.unicon.resource=DEBUG
  • Edit $TOMCAT_HOME/conf/Standalone/localhost/portal.xml
    • Set logLevel="10"
    • Set traceCallers="20"
  • Restart tomcat and monitor $TOMCAT_HOME/logs/portal.log (or whichever file log4j.properties specifies)
    • It will log clients that allocate connections and then what sql they use.


Academus 2.0

  • Edit $TOMCAT_HOME/webapps/portal/WEB-INF/classes/log4j.properties
    • Add the following line at the end of the file: log4j.logger.net.unicon.sdk.resource=DEBUG
  • Edit $TOMCAT_HOME/webapps/portal/WEB-INF/classes/properties/unicon-resource-pool.properties
    • Set DebugLevel=10
    • Set PortalDbDBTraceCallers=20
  • Restart tomcat and monitor $TOMCAT_HOME/logs/portal.log (or whichever file log4j.properties specifies)
    • It will log clients that allocate connections and then what sql they use.