Log4j:配置JDBC附加程序以使用数据源 [英] Log4j: configure JDBC appender to use Datasource
本文介绍了Log4j:配置JDBC附加程序以使用数据源的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我必须配置JDBC附加程序以使用数据源.可以吗?
I have to configure the JDBC appender to use a datasource..is it possible?
如果是这样,怎么办? 我当前的文件如下所示:
if so , how? My present file looks like so:
# Define the root logger with file appender
log4j.rootLogger = DEBUG, sql
# Define the file appender
log4j.appender.sql=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.sql.URL=jdbc:mysql://localhost/test
# Set Database Driver
log4j.appender.sql.driver=com.mysql.jdbc.Driver
# Set database user name and password
log4j.appender.sql.user=root
log4j.appender.sql.password=password
# Set the SQL statement to be executed.
log4j.appender.sql.sql=INSERT INTO LOGS VALUES ('%x', now() ,'%C','%p','%m')
# Define the xml layout for file appender
log4j.appender.sql.layout=org.apache.log4j.PatternLayout
推荐答案
如果要使用数据源,则需要添加 org.apache.log4j.DBAppender
2 .例如:
If you want to use a datasource, you need to add the jar file of Apache Extras for Apache log4j 1 and use the class org.apache.log4j.DBAppender
2. e.g.:
# Define the root logger with file appender
log4j.rootLogger = DEBUG, sql
# Define the database appender
log4j.appender.sql=org.apache.log4j.DBAppender
log4j.appender.sql.connectionSource=org.apache.log4j.receivers.db.JNDIConnectionSource
log4j.appender.sql.connectionSource.jndiLocation=java:/comp/env/jdbc/MySQLDS
注释
- 您可以下载文件
apache-log4j-extras-1.2.17.jar
此处. - 此附加程序使用数据库架构(不可自定义),您可以找到它
- You can download the file
apache-log4j-extras-1.2.17.jar
here. - This appender uses a database schema (not customizable) and you can find it here. If you want to use other tables, you'll need to rewrite the appender.
这篇关于Log4j:配置JDBC附加程序以使用数据源的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文