TDengine icon indicating copy to clipboard operation
TDengine copied to clipboard

java用restfull调用td数据插入,当字段数据类型FLOAT,且是负数时,报异常,直接执行sql无问题

Open leirane opened this issue 1 year ago • 4 comments

###报错信息

org.springframework.jdbc.UncategorizedSQLException: 
### Error updating database.  Cause: java.sql.SQLException: TDengine ERROR (0x216): sql: insert into
        dev_data_1724592907199438848_1724607543802060800_sl_swj_1788169822267092992
        using
        s_dev_data_1724592907199438848_1724607543802060800_sl_swj
         (  
            prodId
         , 
            dev_id
         , 
            dev_code
         , 
            dev_name
         , 
            tenant_id
         , 
            project_id
         ) 
        tags
         (  
            'sl_swj'
         , 
            '1788169822267092992'
         , 
            'qglhz_zhsw'
         , 
            '闸后水位'
         , 
            '1724592907199438848'
         , 
            '1724607543802060800'
         ) 
        (ts,
          
            sw
         , 
            record_time
         , 
            del_flag
         
        )
        values(
         
                1717744559178
             
        ,
          
            -0.2
         , 
            1717744559120
         , 
            0
         
        ), desc: syntax error near '1717744559178
             
        ,
          
            -0' (invalid timestamp) 

##数据表创建语句

  CREATE STABLE `s_dev_real_data_1724592907199438848_1724607543802060800_sl_swj` (`ts` TIMESTAMP, `sw` FLOAT, `record_time` TIMESTAMP, `del_flag` TINYINT) TAGS (`dev_id` VARCHAR(40), `dev_code` VARCHAR(60), `dev_name` VARCHAR(100), `prodid` VARCHAR(64), `project_id` VARCHAR(40), `tenant_id` VARCHAR(40))

leirane avatar Jun 07 '24 09:06 leirane

请问驱动和数据库版本是?

yu285 avatar Jun 17 '24 02:06 yu285

请问驱动和数据库版本是?

数据库版本:3.2.3.0,驱动版本:3.2.11

leirane avatar Jun 17 '24 02:06 leirane

请问驱动和数据库版本是?

数据库版本:3.2.3.0,驱动版本:3.2.11

leirane avatar Jun 17 '24 02:06 leirane

我应该有您微信吧,您可以和我说句话,a15652223354。

yu285 avatar Jun 26 '24 03:06 yu285

联系上用户后再做reopen

yu285 avatar Aug 18 '24 11:08 yu285