1、修改db url,加上allowMultiQueries=true
db.url=jdbc:mysql://localhost:3306/springcloud_db01?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true
2、修改applicationContext.xml,增加proxyFilters配置,要在filters之前
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <property name="driverClassName" value="${db.driverClassName}" /> <property name="url" value="${db.url}" /> <property name="username" value="${db.username}" /> <property name="password" value="${db.password}" /> <property name="initialSize" value="3" /> <property name="minIdle" value="3" /> <property name="maxActive" value="20" /> <property name="maxWait" value="60000" /> <property name="proxyFilters"> <list> <ref bean="stat-filter"/> <ref bean="wall-filter"/> </list> </property> <property name="filters" value="stat,wall" /> </bean>
<bean id="wall-filter" class="com.alibaba.druid.wall.WallFilter"> <property name="dbType" value="mysql" /> <property name="config" ref="wall-config"/> </bean> <bean id="wall-config" class="com.alibaba.druid.wall.WallConfig"> <property name="multiStatementAllow" value="true"/> </bean>