[#CONF-10268] Hibernate SQL logging does not show up on confluence 2.6.2 and 2.6.1

Confluence

Hibernate SQL logging does not show up on confluence 2.6.2 and 2.6.1

Created: 17/Dec/07 05:23 PM Updated: 17/Dec/07 07:28 PM

Component/s:

Database / Hibernate

Affects Version/s:

2.6.1, 2.6.2

Fix Version/s:

2.7.1

Time Tracking:

Not Specified

Environment:

« Hide

Confluence EAR/WAR and standalone
JDK 1.5

Issue Links:

Reference

This issue relates to:

~~CONF-10201~~ "org.apache.commons.logging.impl.Jdk14Logger does not implement Log" on Websphere due to commons-logging-1.0.jar

Participants:	Andrew Lynch [Atlassian], Paul Curren [Atlassian] and Roy Hartono
Since last comment:	36 weeks, 3 days ago
Resolution Date:	17/Dec/07 07:28 PM
Labels:

Description

« Hide

hibernate log statements/SQL queries fails to show when the parameter values in log4j.properties file are uncommented.

## log hibernate prepared statements/SQL queries (equivalent to setting 'hibernate.show_sql' to 'true')
log4j.logger.net.sf.hibernate.SQL=DEBUG, confluencelog
log4j.additivity.net.sf.hibernate.SQL=false

## log hibernate prepared statement parameter values
log4j.logger.net.sf.hibernate.type=DEBUG, confluencelog
log4j.additivity.net.sf.hibernate.type=false

This does not affect 2.7

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Andrew Lynch [Atlassian] added a comment - 17/Dec/07 06:16 PM

I believe this is caused by Commons Logging in Hibernate incorrectly using a Jdk14Logger, instead of Log4j. I assume any part of Confluence or other framework that uses Commons Logging will be broken.

[ Permlink | « Hide ]

Paul Curren [Atlassian] added a comment - 17/Dec/07 06:53 PM

The workaround for 2.6.x is to replace the commons-logging supplied with the latest version. This can be downloaded from -
http://www.ibiblio.org/maven/commons-logging/jars/commons-logging-1.0.4.jar

You should remove any other commons-logging-1.0.x.jar type file from <confluence install>/confluence/WEB-INF/lib and replace with this version.

[ Permlink | « Hide ]

Paul Curren [Atlassian] added a comment - 17/Dec/07 07:28 PM

The dependency has been fixed to commons-logging-1.0.4.jar for 2.7.1.