tsd3.3.6使用websoket链接报错
Open
Nobody has claimed this yet.
enhancement
- Dominant language
- C
- Stars
- 25.1k
- Forks
- 5k
- Avg merge
- 4d 59m
- Merged PRs (30d)
- 7
Description
使用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链接后,可正常写入
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the websocket write with TDengine 3.3.6 in Docker and the Java connector 3.6.3. Inspect the batchInsertDev call and the referenced DeviceStatushisTdEngineMapper.xml mapping, then compare it with the working RESTful path. Done means the insert using websocket completes without the Invalid operation error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- docker, java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100