log4j JDBCAppender 消息中有单引号 BUG

最新推荐文章于 2021-12-20 00:07:14 发布

库伯

最新推荐文章于 2021-12-20 00:07:14 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： JAVA 文章标签： log4j JDBCAppender BUG SQLException JDBCAppender BUG

本文链接：https://blog.youkuaiyun.com/iKuboo/article/details/51602532

JAVA 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一种解决Log4j JDBCAppender在记录含有单引号的消息时出现SQL异常的方法。通过重写LoggingEvent类来实现对单引号的转义，确保消息能正确地被记录到数据库中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

用log4j的JDBCAppender 输出到数据库如果消息中有单引号，就会报SQLException。

解决办法就是重写JDBCAppender

1.新建类MyLoggingEvent

package com.ikuboo.custom;

import org.apache.log4j.Category;
import org.apache.log4j.Priority;
import org.apache.log4j.spi.LoggingEvent;

/**
 * @ClassName:MyLoggingEvent.java
 * @Description:重写，替换message 单引号为 转义符
 * @author:Yuan
 * @version:V1.0
 * @Date:2016年6月7日 上午10:51:38
 */

public class MyLoggingEvent extends LoggingEvent
{
	private static final long serialVersionUID = -1405129465403337629L;

	public MyLoggingEvent(String fqnOfCategoryClass, Category logger, Priority level, Object message, Throwable throwable)
	{
		super(fqnOfCategoryClass, logger, level, message, throwable);
	}
	@Override
	public String getThreadName()
	{
		String thrdName = super.getThreadName();
		if (thrdName.indexOf("'") != -1)
		{
			thrdName = thrdName.replaceAll("'", "''");
		}
		return thrdName;
	}
	@Override
	public String getRenderedMessage()
	{
		String msg = super.getRenderedMessage();
		if (msg.indexOf("'") != -1)
		{
			msg = msg.replaceAll("'", "''");
		}
		return msg;
	}

}

2.新建类MyJDBCAppender

package com.ikuboo.custom;

import org.apache.log4j.Category;
import org.apache.log4j.Priority;
import org.apache.log4j.spi.LoggingEvent;

/**
 * @ClassName:MyLoggingEvent.java
 * @Description:重写，替换message 单引号为 转义符
 * @author:Yuan
 * @version:V1.0
 * @Date:2016年6月7日 上午10:51:38
 */

public class MyLoggingEvent extends LoggingEvent
{
	private static final long serialVersionUID = -1405129465403337629L;

	public MyLoggingEvent(String fqnOfCategoryClass, Category logger, Priority level, Object message, Throwable throwable)
	{
		super(fqnOfCategoryClass, logger, level, message, throwable);
	}
	@Override
	public String getThreadName()
	{
		String thrdName = super.getThreadName();
		if (thrdName.indexOf("'") != -1)
		{
			thrdName = thrdName.replaceAll("'", "''");
		}
		return thrdName;
	}
	@Override
	public String getRenderedMessage()
	{
		String msg = super.getRenderedMessage();
		if (msg.indexOf("'") != -1)
		{
			msg = msg.replaceAll("'", "''");
		}
		return msg;
	}

}

3.修改log4j.properties

log4j.appender.db=com.ikuboo.custom.MyJDBCAppender