使用 mybatis 时，websocket 连接出错。

开源版问题专区
1

【TDengine 使用环境】
开发环境

【TDengine 版本】

3.3.6.9 开源版

【操作系统以及版本】

Ubuntu 2.4.04

【部署方式】容器/非容器部署

非容器部署

【集群节点数】

1

【集群副本数】

1

【描述业务影响】

使用 mybatis 开发时，将原生数据库连接迁移到 websocket 时，提示错误

原生数据库连接

          driver-class-name: com.taosdata.jdbc.TSDBDriver
          url: jdbc:TAOS://127.0.0.1:6030/smart_sleep_iot_tdengine?user=ss_iot_user&password=Asdf@1234!&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8&lowercaseOutputs=true

webscoket 数据库连接

          driver-class-name: com.taosdata.jdbc.ws.WebSocketDriver
          url: jdbc:TAOS-WS://127.0.0.1:6041/smart_sleep_iot_tdengine?user=ss_iot_user&password=Asdf@1234!&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8&lowercaseOutputs=true

【问题复现路径/shan】做过哪些操作出现的问题

【遇到的问题：问题现象及影响】

【资源配置】

【报错完整截图】（不要大段的粘贴报错代码，论坛直接看报错代码不直观）

026-04-22 19:28:30.153 [http-nio-9090-exec-3] DEBUG c.s.m.t.m.TdEngineMapper.createSuperTableAndColumn:137 - ==> Preparing: create stable if not exists smart_sleep_iot_tdengine.ss_iot_sm4vsvpkrila6jnlnjj_event ( ts TIMESTAMP , event_type VARCHAR (?) COMPOSITE KEY , event_time TIMESTAMP , event_state INT , event_values VARCHAR (?) , event_tsls VARCHAR (?) ) tags ( device_identification BINARY (64) )
2026-04-22 19:28:30.231 [http-nio-9090-exec-3] ERROR o.jeecg.common.exception.JeecgBootExceptionHandler:78 -

Error updating database. Cause: java.sql.SQLException: (0x2600):syntax error near

The error may exist in URL [jar:file:/data/smart_sleep/iot/smartsleep-system-start-3.6.3.jar!/BOOT-INF/lib/smartsleep-module-tdengine-3.6.3.jar!/com/smartsleep/modules/tdengine/mapper/xml/TdEngineMapper.xml]

The error may involve com.smartsleep.modules.tdengine.mapper.TdEngineMapper.createSuperTableAndColumn

The error occurred while executing an update

SQL: create stable if not exists smart_sleep_iot_tdengine.ss_iot_sm4vsvpkrila6jnlnjj_event ( ts TIMESTAMP , event_type VARCHAR (?) COMPOSITE KEY , event_time TIMESTAMP , event_state INT , event_values VARCHAR (?) , event_tsls VARCHAR (?) ) tags ( device_identification BINARY (64) )

Cause: java.sql.SQLException: (0x2600):syntax error near

; uncategorized SQLException; SQL state [null]; error code [0]; (0x2600):syntax error near; nested exception is java.sql.SQLException: (0x2600):syntax error near
org.springframework.jdbc.UncategorizedSQLException:

Error updating database. Cause: java.sql.SQLException: (0x2600):syntax error near

The error may exist in URL [jar:file:/data/smart_sleep/iot/smartsleep-system-start-3.6.3.jar!/BOOT-INF/lib/smartsleep-module-tdengine-3.6.3.jar!/com/smartsleep/modules/tdengine/mapper/xml/TdEngineMapper.xml]

The error may involve com.smartsleep.modules.tdengine.mapper.TdEngineMapper.createSuperTableAndColumn

The error occurred while executing an update

SQL: create stable if not exists smart_sleep_iot_tdengine.ss_iot_sm4vsvpkrila6jnlnjj_event ( ts TIMESTAMP , event_type VARCHAR (?) COMPOSITE KEY , event_time TIMESTAMP , event_state INT , event_values VARCHAR (?) , event_tsls VARCHAR (?) ) tags ( device_identification BINARY (64) )

Cause: java.sql.SQLException: (0x2600):syntax error near