druid，log4j记录sql，发现会执行三次，

Question

2014-10-27 16:51:30,146 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} created. select count(id) from User>
2014-10-27 16:51:30,146 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} created. select count(id) from User>
2014-10-27 16:51:30,146 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} created. select count(id) from User>
2014-10-27 16:51:30,147 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} Parameters : []>
2014-10-27 16:51:30,147 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} Parameters : []>
2014-10-27 16:51:30,147 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} Parameters : []>
2014-10-27 16:51:30,147 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} Types : []>
2014-10-27 16:51:30,147 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} Types : []>
2014-10-27 16:51:30,147 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} Types : []>
2014-10-27 16:51:30,148 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} executed. select count(id) from User>
2014-10-27 16:51:30,148 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} executed. select count(id) from User>
2014-10-27 16:51:30,148 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} executed. select count(id) from User>
2014-10-27 16:51:30,148 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} executed. 1.089623 millis. select count(id) from User>
2014-10-27 16:51:30,148 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} executed. 1.089623 millis. select count(id) from User>
2014-10-27 16:51:30,148 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} executed. 1.089623 millis. select count(id) from User>
2014-10-27 16:51:30,148 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} closed>
2014-10-27 16:51:30,148 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} closed>
2014-10-27 16:51:30,148 DEBUG [druid.sql.Statement] - <{conn-10002, pstmt-20001} closed>

我访问了一次，从日志看，执行三次sql语句，怎么回事？

Answer 1

把log4j里面的配置删除，spring里面配置的filter有log类型就可以了，还有就是sql不是执行了3次，而是打印了3遍

Answer 2

先把log中druid的配置去了试试

Answer 3

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} created. select logconfig0_.id as id22_, logconfig0_.create_date as create2_22_, logconfig0_.modify_date as modify3_22_, logconfig0_.action_class_name as action4_22_, logconfig0_.action_method_name as action5_22_, logconfig0_.description as descript6_22_, logconfig0_.operation_name as operation7_22_ from cf_log_config logconfig0_ order by logconfig0_.create_date desc

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} created. select logconfig0_.id as id22_, logconfig0_.create_date as create2_22_, logconfig0_.modify_date as modify3_22_, logconfig0_.action_class_name as action4_22_, logconfig0_.action_method_name as action5_22_, logconfig0_.description as descript6_22_, logconfig0_.operation_name as operation7_22_ from cf_log_config logconfig0_ order by logconfig0_.create_date desc

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} created. select logconfig0_.id as id22_, logconfig0_.create_date as create2_22_, logconfig0_.modify_date as modify3_22_, logconfig0_.action_class_name as action4_22_, logconfig0_.action_method_name as action5_22_, logconfig0_.description as descript6_22_, logconfig0_.operation_name as operation7_22_ from cf_log_config logconfig0_ order by logconfig0_.create_date desc

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} Parameters : []

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} Parameters : []

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} Parameters : []

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} Types : []

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} Types : []

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} Types : []

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002, rs-50002} query executed. 3.397767 millis. select logconfig0_.id as id22_, logconfig0_.create_date as create2_22_, logconfig0_.modify_date as modify3_22_, logconfig0_.action_class_name as action4_22_, logconfig0_.action_method_name as action5_22_, logconfig0_.description as descript6_22_, logconfig0_.operation_name as operation7_22_ from cf_log_config logconfig0_ order by logconfig0_.create_date desc

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002, rs-50002} query executed. 3.397767 millis. select logconfig0_.id as id22_, logconfig0_.create_date as create2_22_, logconfig0_.modify_date as modify3_22_, logconfig0_.action_class_name as action4_22_, logconfig0_.action_method_name as action5_22_, logconfig0_.description as descript6_22_, logconfig0_.operation_name as operation7_22_ from cf_log_config logconfig0_ order by logconfig0_.create_date desc

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002, rs-50002} query executed. 3.397767 millis. select logconfig0_.id as id22_, logconfig0_.create_date as create2_22_, logconfig0_.modify_date as modify3_22_, logconfig0_.action_class_name as action4_22_, logconfig0_.action_method_name as action5_22_, logconfig0_.description as descript6_22_, logconfig0_.operation_name as operation7_22_ from cf_log_config logconfig0_ order by logconfig0_.create_date desc

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} clearParameters. 

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} clearParameters. 

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} clearParameters. 

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} closed

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} closed

<2015-04-14 10:46:08> <DEBUG> [druid.sql.Statement] - {conn-10001, pstmt-20002} closed

同求解决办法

Answer 4

我是在spring里使用的druid，您说的配置是指？？

Answer 5

要druid配置

Answer 6

引用来自“echard”的评论

把配置以发出来

Answer 7

把配置以发出来

Answer 8

只配置了proxyFilters，没有filters

Answer 9

是不是同时配置了filter和proxyFilters

#过滤   如果同时配置了filters和proxyFilters，是组合关系，并非替换关系
#filters:config

建议在properties就配置个filters:config,用来加密数据库连接密码。然后在datasource里配置

<!-- 配置监控统计拦截的filters -->
<property name="proxyFilters">
<list>
<ref bean="stat-filter" />
<ref bean="wall-filter" />
<ref bean="log-filter" />
</list>
</property>

Answer 10

引用来自“lgscofield”的评论

应该是log4j配置的问题吧

Answer 11

应该是log4j配置的问题吧

Answer 12

解决没有啊？求分享一下，