druid 超时数据写入log4j日志~

druid 超时数据写入log4j日志~

log4j 配置

#print
log4j.appender.Task=org.apache.log4j.DailyRollingFileAppender
log4j.appender.Task.File=${catalina.base}/logs/task.log
log4j.appender.Task.layout=org.apache.log4j.PatternLayout
log4j.appender.Task.layout.ConversionPattern=%d - %m%n


 
# Druid  
log4j.logger.com.alibaba.druid=INFO,Task 

spring dataSource

 		
 	    <!-- 数据源配置, 使用 Druid 数据库连接池 -->
		<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> 
			
    		<property name="timeBetweenLogStatsMillis" value="60000" />
		<!-- 配置监控统计拦截的filters，去掉后监控界面sql无法统计 -->
	        <property name="filters" value="log4j" />
	        <property name="proxyFilters">
	            <list>
	                <ref bean="stat-filter" /> 
                	<ref bean="log-filter" />
	            </list>
	        </property>

		    
		</bean>
		
		<bean id="log-filter" class="com.alibaba.druid.filter.logging.Log4jFilter"> </bean>
		

	    <!-- 配置监控统计拦截的filters，去掉后监控界面sql无法统计 -->
		 <bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter">
		
		        <property name="mergeSql" value="true" />
		        <property name="slowSqlMillis" value="10000" />
		        <property name="logSlowSql" value="true" />
		    </bean>