insert时0X530错误

[dskxvos]

【TDengine 版本】

DB：3.3.8.0 驱动：taos-jdbcdriver-3.8.3.jar
使用mybatisplus执行语句

SQL: INSERT INTO dev_log_340793693336240128_512 (ts, protocol) USING dev_log (device_id, msg_id) TAGS (?, ?) VALUES (?, ?)

Cause: java.sql.SQLException: (0x530):success

; uncategorized SQLException; SQL state [null]; error code [0]; (0x530):success
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:93)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
at jdk.proxy2/jdk.proxy2.$Proxy111.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at jdk.proxy2/jdk.proxy2.$Proxy112.insert(Unknown Source)
at com.jadecreo.dcgw.service.impl.DevLogService.lambda$writeLog$1(DevLogService.java:53)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.sql.SQLException: (0x530):success
at com.taosdata.jdbc.ws.WSRetryableStmt.executeWithRetry(WSRetryableStmt.java:139)
at com.taosdata.jdbc.ws.WSRetryableStmt.writeBlockWithRetrySync(WSRetryableStmt.java:76)
at com.taosdata.jdbc.ws.AbsWSPreparedStatement.executeInsertImpl(AbsWSPreparedStatement.java:1110)
at com.taosdata.jdbc.ws.AbsWSPreparedStatement.executeUpdate(AbsWSPreparedStatement.java:127)
at com.taosdata.jdbc.ws.AbsWSPreparedStatement.execute(AbsWSPreparedStatement.java:69)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
at jdk.proxy3/jdk.proxy3.$Proxy137.execute(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
... 10 common frames omitted

[qiang436]

TDengine 驱动返回了 (0x530):success，这是 TDengine 的成功码
但 MyBatis 的异常翻译器将这个成功码误判为异常，包装成了 SQLException
实际数据已经成功插入，可以查询 dev_log_340793693336240128_512 表验证

在业务代码中捕获这个特定的"成功异常"：

java
try {
devLogMapper.insert(devLog);
} catch (SQLException e) {
// 检查错误码是否为 0x530 (1328)
if (e.getErrorCode() == 0x530 || e.getMessage().contains("success")) {
// 实际插入成功，正常处理
log.debug("数据插入成功（驱动返回成功码）");
} else {
// 真正的异常
throw e;
}
}

[dskxvos]

TDengine 驱动返回了 （0x530）：success，这是 TDengine 的成功码 但 MyBatis 的异常翻译器将这个成功码误判为异常，包装成了 SQLException 实际数据已经成功插入，可以查询 dev_log_340793693336240128_512 表验证

在业务代码中捕获这个特定的"成功异常"：

java try { devLogMapper.insert（devLog）; } catch （SQLException e） { // 检查错误码是否为 0x530 （1328） if （e.getErrorCode（） == 0x530 || e.getMessage（）.contains（“success”）） { // 实际插入成功，正常处理 log.debug（“数据插入成功（驱动返回成功码）”）; } 否则 { // 真正的异常 throw e; } }

数据并没有写入进去