You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
异常信息:
Caused by: java.sql.SQLException: (0x2600):syntax error near "? (ts timestamp,int_v int,float_v float,double_v double,bool_v bool,binary_v binary(1024),extend_json nchar(4000)) tags (device_uuid binary(1024))"
at com.taosdata.jdbc.ws.TSWSPreparedStatement.executeUpdate(TSWSPreparedStatement.java:224)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3201)
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1091)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3199)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:194)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:256)
at org.springframework.jdbc.core.JdbcTemplate.lambda$update$0(JdbcTemplate.java:867)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
... 44 more
The text was updated successfully, but these errors were encountered:
使用官方示例WSParameterBindingFullDemo
针对动态参数表名创建超级表 目前 异常报错 (0x22a):Stmt API usage error
danielclow
changed the title
添加batchfetch=true创建超级表失败,取消后正常
supertable creation fails with batchfetch=true but succeeds without this parameter
May 4, 2024
使用JdbcTemplate创建超级表。
代码片段:
PreparedStatementSetter preparedStatementSetter = ps ->{
ps.setString(1,superTableName);
};
jdbcTemplate.update(sql.toString(), preparedStatementSetter);
预编译sql:
CREATE STABLE IF NOT EXISTS ? (ts timestamp,int_v int,float_v float,double_v double,bool_v bool,binary_v binary(1024),extend_json nchar(4000)) tags (device_uuid binary(1024))
版本信息:
服务版本:[tdengine/tdengine:3.2.3.0]
驱动版本:taos-jdbcdriver 3.2.10
异常信息:
Caused by: java.sql.SQLException: (0x2600):syntax error near "? (ts timestamp,int_v int,float_v float,double_v double,bool_v bool,binary_v binary(1024),extend_json nchar(4000)) tags (device_uuid binary(1024))"
at com.taosdata.jdbc.ws.TSWSPreparedStatement.executeUpdate(TSWSPreparedStatement.java:224)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3201)
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1091)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3199)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:194)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:256)
at org.springframework.jdbc.core.JdbcTemplate.lambda$update$0(JdbcTemplate.java:867)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
... 44 more
The text was updated successfully, but these errors were encountered: