[Building Sakai] How using Log4JDBC for sakai2.7.1?

[北條 雅慎]

Hi,
I was able to solve a problem by the following method.

1. edit sakai.properties
driverClassName at javax.sql.BaseDataSource=net.sf.log4jdbc.DriverSpy

url at javax.sql.BaseDataSource=jdbc:log4jdbc:mysql://localhost:3306/sakai?useUnicode=true&characterEncoding=UTF-8 

(jdbc:mysql:xx -> jdbc:log4jdbc:mysql:xx)

2. add follows to 
kernel/kernel-common/src/main/config/log4j.properties,and deploy kernel

### log4jdbc logging options ###
log4j.debug=false
log4j.logger.jdbc.sqltiming=INFO,sqltiming
log4j.additivity.jdbc.sqltiming=false
log4j.logger.jdbc.audit=ERROR
log4j.additivity.jdbc.audit=false
log4j.logger.jdbc.resultset=ERROR
log4j.additivity.jdbc.resultset=false
log4j.logger.jdbc.sqlonly=ERROR
log4j.additivity.jdbc.sqlonly=false
log4j.logger.jdbc.connection=FATAL
log4j.additivity.jdbc.connection=false

log4j.appender.sqltiming=org.apache.log4j.ConsoleAppender
log4j.appender.sqltiming.Target=System.out
log4j.appender.sqltiming.Append=false
log4j.appender.sqltiming.layout=org.apache.log4j.PatternLayout
log4j.appender.sqltiming.layout.ConversionPattern=%d{ISO8601} %5p %t %c 
- %m%n

3. copy the following jar files to $TOMCAT_HOME/common/lib
log4jdbc3-1.2beta2.jar
slf4j-log4j12-1.4.2.jar
slf4j-api-1.4.2.jar


(2011/02/18 13:46), Masami Hojo wrote:
> I want to use Log4JDBC in Sakai2.7.1.
> However, I was not able to find how I could use it if I set it.
>
> Would you teach whom or a procedure?
>
> How may it be settled?
> (By the way, tomcat starts in MySQL.)
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>