【无标题】我的druid批量更新大坑

使用druid批量更新的大坑

大概提示是 multi-statement not allowed,然后查了一些文档,发现https://blog.csdn.net/sinat_23893027/article/details/101034094
这个里面的设置都设置过了,还是提示;
后面又找了
https://www.cnblogs.com/kelelipeng/p/11981999.html#:~:text=Cause%3A%20java.sql.SQLException%3A%20sql%20injection%20violation%2C%20multi-statement%20not,allow%20%E5%BC%82%E5%B8%B8%E3%80%82.%20%E5%AF%BC%E8%87%B4%E8%AF%A5%E5%BC%82%E5%B8%B8%E5%87%BA%E7%8E%B0%E6%98%AF%E5%9B%A0%E4%B8%BADruid%E7%9A%84multiStatementAllow%E9%BB%98%E8%AE%A4%E6%98%AFfalse%EF%BC%8C%E6%89%80%E4%BB%A5%E9%9C%80%E8%A6%81%E5%BC%80%E5%90%AF%EF%BC%8C%E8%AE%BE%E7%BD%AE%E6%88%90true%E3%80%82.%20%E4%B8%80%E3%80%81%E8%A7%A3%E5%86%B3%E6%96%B9%E6%B3%95.%20%E9%85%8D%E7%BD%AE%E6%95%B0%E6%8D%AE%E5%BA%93%E8%BF%9E%E6%8E%A5%EF%BC%8C%E6%B7%BB%E5%8A%A0allowMultiQueries%3Dtrue.%20%E9%85%8D%E7%BD%AE%E7%9B%91%E6%8E%A7%E7%BB%9F%E8%AE%A1%E6%8B%A6%E6%88%AA%E7%9A%84filters%EF%BC%8C%E5%8E%BB%E6%8E%89%E5%90%8E%E7%9B%91%E6%8E%A7%E7%95%8C%E9%9D%A2sql%E6%97%A0%E6%B3%95%E7%BB%9F%E8%AE%A1%EF%BC%8C%27wall%E2%80%99%E7%94%A8%E4%BA%8E%E9%98%B2%E7%81%AB%E5%A2%99%EF%BC%8C%E6%AD%A4%E5%A4%84%E5%8E%BB%E9%99%A4%E9%98%B2%E7%81%AB%E5%A2%99.%20spring.datasource.druid.filters%3Dconfig%2Cstat%2Cslf4j.%20%E9%85%8D%E7%BD%AE%E8%BF%87%E6%BB%A4%E5%99%A8wall%E7%9A%84%E5%8F%82%E6%95%B0.
按这个修改了yml文件,估计是之前配置的没配对,spring.datasource.druid.filter, 中间少了druid一级,所以导致没生效

上一篇:Linux常用操作命令之文件权限(二)


下一篇:C++虚继承