【详述】删除表分区数据: TRUNCATE TABLE ‘sjfx_zhun.t_bigwidth_merinfo’ PARTITION(p_yyf)
报错:Caused by: java.sql.SQLException: sql injection violation, dbType mysql, , druid-version 1.2.4, syntax error: syntax error, expect =, actual ) pos 60, line 1, column 60, token ) : TRUNCATE TABLE sjfx_zhun.t_bigwidth_merinfo PARTITION(p_yyf)
at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:849)
at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:292)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568)
at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:930)
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568)
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:341)
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:351)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:55)
使用mysql客户端没问题吧?确认下是不是druid连接器兼容性问题
应该是,我直接用jdbc的方式插入语句没有问题