Hello,
I have some problems with connect from my webappliction to the database (postgres). I try to install log4jdbc (http://code.google.com/p/log4jdbc/) to show some detail information. But I didn't get it to run.
I followed the Instruction-Usage. I already have log4j integrated in my project and added the log4jdbc4-1.2alpha1.jar, the postgres driver will automatic load by log4jdbc, so I only changed the jdbc url from:
jdbc:postgresql://192.168.0.6:5432/myDatabase?autoReconnect=true
TO
log4jdbc:postgresql://192.168.0.6:5432/myDatabase?autoReconnect=true
I changed the log4j.properties to (copied by http://code.google.com/p/log4jdbc/source/browse/trunk/doc/log4j.properties):
log4j.debug=true
log4j.logger.jdbc.audit=DEBUG,jdbc
log4j.additivity.jdbc.audit=true
log4j.logger.jdbc.resultset=DEBUG,jdbc
log4j.additivity.jdbc.resultset=true
log4j.logger.jdbc.sqlonly=DEBUG,sql
log4j.additivity.jdbc.sqlonly=true
log4j.logger.jdbc.sqltiming=DEBUG,sqltiming
log4j.additivity.jdbc.sqltiming=true
log4j.logger.jdbc.connection=DEBUG,connection
log4j.additivity.jdbc.connection=true
log4j.appender.sql=org.apache.log4j.FileAppender
log4j.appender.sql.File=E:\\TEST\\sql.log
log4j.appender.sql.Append=true
log4j.appender.sql.layout=org.apache.log4j.PatternLayout
log4j.appender.sql.layout.ConversionPattern=-----> %d{yyyy-MM-dd HH:mm:ss.SSS} %m%n%n
log4j.appender.sqltiming=org.apache.log4j.FileAppender
log4j.appender.sqltiming.File=E:\\TEST\\sqltiming.log
log4j.appender.sql.Append=true
log4j.appender.sqltiming.layout=org.apache.log4j.PatternLayout
log4j.appender.sqltiming.layout.ConversionPattern=-----> %d{yyyy-MM-dd HH:mm:ss.SSS} %m%n%n
log4j.appender.jdbc=org.apache.log4j.FileAppender
log4j.appender.jdbc.File=E:\\TEST\\jdbc.log
log4j.appender.sql.Append=true
log4j.appender.jdbc.layout=org.apache.log4j.PatternLayout
log4j.appender.jdbc.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss.SSS} %m%n
! the appender used for the JDBC Connection open and close events
log4j.appender.connection=org.apache.log4j.FileAppender
log4j.appender.connection.File=E:\\TEST\\connection.log
log4j.appender.sql.Append=true
log4j.appender.connection.layout=org.apache.log4j.PatternLayout
log4j.appender.connection.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss.SSS} %m%n
If I run the application it works fine. The programm start and I get database information (so the jdbc url musst be correct).
The log files would be created but they are still empty. I tried some different changes in the log4j.properties but nothing works. I use Java 1.6, Struts 1.3.8, Tomcat 6.0.18, Postgres 8.1, log4j 1.2.5 and log4jdbc 1.2alpha.
Anybody experience with log4jdbc and web apps? Thanks for help