spring boot使用log4j2将日志写入mysql数据库
log4j2官方例子在spring boot中报错而且还是用的是org.apache.commons.dbcp包
我给改了一下使用org.apache.commons.dbcp2包
1.log4j2.xml如下:
<?xml version="1.0" encoding="UTF-8"?>
<Configuration status="error">
<Appenders>
<Console name="Console" target="SYSTEM_OUT">
<PatternLayout pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
</Console>
<JDBC name="DBLogger" tableName="MicroServiceLogHandle">
<ConnectionFactory class="com.malls.common.tool.LogConnectionFactory"
method="getDatabaseConnection" />
<Column name="RequestKey" pattern="${sd:RequestKey}" />
<Column name="LogType" pattern="${sd:LogType}" />
<Column name="RequestUrl" pattern="${sd:RequestUrl}" />
<Column name="UserName" pattern="${sd:UserName}" />
<Column name="OrderNo" pattern="${sd:OrderNo}" />
<Column name="Content" pattern="${sd:Content}" />
<Column name="Keyword" pattern="${sd:Keyword}" />
<Column name="ClientIP" pattern="${sd:ClientIP}" />
<Column name="TimeLong" pattern="${sd:TimeLong}" />
<Column name="LogTime" pattern="${sd:LogTime}" />
<Column name="DBCreateTime" literal="now()" />
<Column name="ServerDesc" pattern="${sd:ServerDesc}" />
<Column name="LogLevel" pattern="${sd:LogLevel}" />
<Column name="RequestServerIP" pattern="${sd:RequestServerIP}" />
<Column name="ServerIP" pattern="${sd:ServerIP}" />
<Column name="CurrentApiRequestKey" pattern="${sd:CurrentApiRequestKey}" />
</JDBC>
</Appenders>
<Loggers>
<AsyncLogger name="AsyncDBLogger" level="debug"
includeLocation="true">
<AppenderRef ref="DBLogger" />
</AsyncLogger>
<Root level="info">
<AppenderRef ref="Console" />
</Root>
</Loggers>
</Configuration>
AsyncLogger 表示是异步插入.需要在pom.xml中插入disruptor引用
<dependency>
<groupId>com.lmax</groupId>
<artifactId>disruptor</artifactId><!-- log4j异步插入用到 -->
<version>3.4.1</version>
</dependency>
2.创建LogConnectionFactory类:
package com.malls.common.tool;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.concurrent.locks.Lock;
import java.util.concurrent.locks.ReentrantLock;
import javax.sql.DataSource;
import org.apache.commons.dbcp2.ConnectionFactory;
import org.apache.commons.dbcp2.DriverManagerConnectionFactory;
import org.apache.commons.dbcp2.PoolableConnection;
import org.apache.commons.dbcp2.PoolableConnectionFactory;
import org.apache.commons.dbcp2.PoolingDataSource;
import org.apache.commons.pool2.ObjectPool;
import org.apache.commons.pool2.impl.GenericObjectPool;
import com.malls.common.model.DBConfig;
public class LogConnectionFactory {
private static interface Singleton {
final LogConnectionFactory INSTANCE = new LogConnectionFactory();
}
private DataSource dataSource;
private LogConnectionFactory() {
}
private void initDataSource() {
try {
//
// First, we'll create a ConnectionFactory that the
// pool will use to create Connections.
// We'll use the DriverManagerConnectionFactory,
// using the connect string passed in the command line
// arguments.
DBConfig dbConfig = ApplicationConfig.GetDbConfig("dblog");
ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(dbConfig.getUrl(),
dbConfig.getUserName(), dbConfig.getPassword());
//
// Next we'll create the PoolableConnectionFactory, which wraps
// the "real" Connections created by the ConnectionFactory with
// the classes that implement the pooling functionality.
//
PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory,
null);
//
// Now we'll need a ObjectPool that serves as the
// actual pool of connections.
//
// We'll use a GenericObjectPool instance, although
// any ObjectPool implementation will suffice.
//
ObjectPool<PoolableConnection> connectionPool = new GenericObjectPool<>(poolableConnectionFactory);
// Set the factory's pool property to the owning pool
poolableConnectionFactory.setPool(connectionPool);
//
// Finally, we create the PoolingDriver itself,
// passing in the object pool we created.
//
dataSource = new PoolingDataSource<>(connectionPool);
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
dataSource = null;
}
}
int i = 0;
private static Lock lock = new ReentrantLock();
public static Connection getDatabaseConnection() throws SQLException {
if (Singleton.INSTANCE.i == 0) {
//这儿如果第一次直接返回连接池的话会报错
//因为PoolableConnectionFactory也使用了log4j记录日志
//这儿是重点
Singleton.INSTANCE.i++;
DBConfig dbConfig = ApplicationConfig.GetDbConfig("dblog");
return DriverManager.getConnection(dbConfig.getUrl(), dbConfig.getUserName(), dbConfig.getPassword());
}
if (Singleton.INSTANCE.dataSource == null) {
lock.lock();
try {
if (Singleton.INSTANCE.dataSource == null) {
Singleton.INSTANCE.initDataSource();
}
} finally {
lock.unlock();
}
}
return Singleton.INSTANCE.dataSource.getConnection();
}
}
要注意注释的地方,第二次才返回连接池
3.创建DBLog类:
package com.malls.common.tool;
import java.time.Duration;
import java.time.LocalDateTime;
import java.util.UUID;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import org.apache.logging.log4j.message.StructuredDataMessage;
import org.springframework.web.context.request.RequestAttributes;
import org.springframework.web.context.request.RequestContextHolder;
import com.malls.common.model.RequestModel;
public class DBLog {
private static final Logger LOGGER = LogManager.getLogger("AsyncDBLogger");
public static void process(String logType, String content) {
process(logType, content, "");
}
public static void process(String logType, String content, String keyWord) {
StructuredDataMessage msg = getataMessage(logType, content, keyWord);
addMsg(msg, "logLevel", "Process");
LOGGER.info(msg);
}
public static void error(String logType, String content) {
error(logType, content, "");
}
public static void error(String logType, String content, String keyWord) {
StructuredDataMessage msg = getataMessage(logType, content, keyWord);
addMsg(msg, "logLevel", "Error");
LOGGER.error(msg);
}
public static void handle(String logType, String content) {
handle(logType, content, "");
}
public static void handle(String logType, String content, String keyWord) {
StructuredDataMessage msg = getataMessage(logType, content, keyWord);
addMsg(msg, "LogLevel", "Handle");
LOGGER.info(msg);
}
private static StructuredDataMessage getataMessage(String logType, String content, String keyWord) {
String confirm = UUID.randomUUID().toString().replace("-", "");
StructuredDataMessage msg = new StructuredDataMessage(confirm, "", "transfer");
RequestAttributes req = RequestContextHolder.currentRequestAttributes();
RequestModel requestModel = null;
if (req != null) {
requestModel = (RequestModel) req.getAttribute("RequestModel", RequestAttributes.SCOPE_REQUEST);
}
if (requestModel == null) {
requestModel = new RequestModel();
}
addMsg(msg, "RequestKey", requestModel.getRequestKey());
addMsg(msg, "RequestUrl", requestModel.getRequestUrl());
addMsg(msg, "UserName", String.valueOf(requestModel.getCurrentUserId()));
addMsg(msg, "OrderNo", requestModel.getOrderNo());
addMsg(msg, "LogType", logType);
addMsg(msg, "Content", content);
addMsg(msg, "Keyword", keyWord);
addMsg(msg, "ClientIP", requestModel.getClientIP());
long timeLong = Duration.between(requestModel.getBeginRequestTime(), LocalDateTime.now()).toMillis();
addMsg(msg, "TimeLong", String.valueOf(timeLong));
addMsg(msg, "ServerDesc", "777");
addMsg(msg, "RequestServerIP", requestModel.getRequestServerIP());
addMsg(msg, "ServerIP", requestModel.getServerIP());
addMsg(msg, "CurrentApiRequestKey", requestModel.getCurrentApiRequestKey());
addMsg(msg, "LogTime", LocalDateTime.now().toString());
return msg;
}
private static void addMsg(StructuredDataMessage msg, String key, String val) {
if (val == null) {
msg.put(key, "");
} else {
msg.put(key, val);
}
}
}
这样就可以了.
