ShardingSphere删除报错- java.lang.NullPointerException

---

一、场景

1、使用ShardingJDBC操作数据库

2、删除SQL执行报错，将sql复制到navicat中执行，执行也报错

---

二、报错SQL

DELETE TABLE t_mb_sessionmsg WHERE openId = ? AND sessionId != ? AND vdnId = ? AND isLeaveMsg = '1' AND agentId = 0

---

三、报错信息

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.lang.NullPointerException
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: DELETE TABLE t_mb_sessionmsg         WHERE openId = ?         AND sessionId != ?         AND vdnId = ?         AND isLeaveMsg = '1'         AND agentId = 0
### Cause: java.lang.NullPointerException

---

四、原因

SQL语句编写有误，不应是DELETE TABLE，而是DELETE FROM

---

五、解决

将DELETE TABLE，改为DELETE FROM