使用tdengine3.3.6版本,docker部署
java连接器版本3.6.3
问题:
1、websocket链接方式,写入数据时报错:
Error updating database.Cause: java.sql.SQLException: (Ox200):Invalid operation### The error may exist in file [E: \wonkspace\be-track-v2\target\classes \mybatis\mapper\DevicStatushisTdEngineMapper.xml]ceStatusHis## The error may involve com.cmiot.track.mapper. DeviceStatushisTdEngineMapper.batchInsertDev:### The error occurred while executing an updateSTAGS ('93081350310')### SQL: insert intodevice_statushis_93081350310 USING device_statushi
Cause: java.sql.SQLException: (Ox200):Invalid operationuncategorized SQLException; SQL state Inull]; error code [0]; (ex200):Invalid operationtionTranslator.java:96)at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExcerava:347)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor. invoke (SqlSessionTemplate.at jdk.proxy2/jdk.proxy2.$Proxy99.insert(Unknown Source)at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate
2、切换至restful链接后,可正常写入
使用tdengine3.3.6版本,docker部署
java连接器版本3.6.3
问题:
1、websocket链接方式,写入数据时报错:
Error updating database.Cause: java.sql.SQLException: (Ox200):Invalid operation### The error may exist in file [E: \wonkspace\be-track-v2\target\classes \mybatis\mapper\DevicStatushisTdEngineMapper.xml]ceStatusHis## The error may involve com.cmiot.track.mapper. DeviceStatushisTdEngineMapper.batchInsertDev:### The error occurred while executing an updateSTAGS ('93081350310')### SQL: insert intodevice_statushis_93081350310 USING device_statushi
Cause: java.sql.SQLException: (Ox200):Invalid operationuncategorized SQLException; SQL state Inull]; error code [0]; (ex200):Invalid operationtionTranslator.java:96)at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExcerava:347)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor. invoke (SqlSessionTemplate.at jdk.proxy2/jdk.proxy2.$Proxy99.insert(Unknown Source)at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate
2、切换至restful链接后,可正常写入