Log4j：配置JDBC应用者以使用数据源

本文是小编为大家收集整理的关于Log4j：配置JDBC应用者以使用数据源的处理/解决方法，可以参考本文帮助大家快速定位并解决问题，中文翻译不准确的可切换到English标签页查看源文。

中文
English

问题描述

我必须配置jdbc appender以使用数据源.

如果是这样，怎么样? 我现在的文件看起来像:

# 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

推荐答案

如果要使用数据源，则需要添加 apache Extras的Jar文件对于Apache log4j ¹并使用class org.apache.log4j.DBAppender org.apache.log4j.DBAppender ².例如:

# 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 在这里.
此appender使用数据库架构(不可自定义)，您可以找到它在这里.如果要使用其他表，则需要重写Appender.

本文地址：https://www.itbaoku.cn/post/1574931.html

百度翻译此文有道翻译此文

问题描述

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

推荐答案

If you want to use a datasource, you need to add the jar file of Apache Extras for Apache log4j¹ and use the class org.apache.log4j.DBAppender². 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

Notes

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配置（基于大小）不工作

下一篇：在春季框架下:警告:警告Logger(org.springframework.web.context.context.contextloader)，找不到附录