注册

执行查询sql,值为中文时,报错:字符串截断

Exception 2023/11/01 738 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:Linux、x86
【CPU】:
【问题描述】*:执行查询sql时,报错:字符串截断

执行sql:
select xuhao as xuhao, id as id, name as name from d_dict_dim_test where ('深圳市' = 'null' or name = '深圳市')

报错信息:
java.sql.SQLException: 字符串截断
at dm.jdbc.dbaccess.DBError.throwSQLException(DBError.java:44)
at dm.jdbc.dbaccess.Request_Response.resp_checkErr(Request_Response.java:2474)
at dm.jdbc.dbaccess.Request_Response.resp_execute(Request_Response.java:1073)
at dm.jdbc.dbaccess.DmdbCSI.getDescAndResultSet(DmdbCSI.java:678)
at dm.jdbc.dbaccess.DmdbCSI.executePrepared(DmdbCSI.java:558)
at dm.jdbc.dbaccess.DmdbCSI.executePrepared(DmdbCSI.java:536)
at dm.jdbc.driver.DmdbPreparedStatement_bs.preparedExceute(DmdbPreparedStatement_bs.java:2366)
at dm.jdbc.driver.DmdbPreparedStatement_bs.executeInner(DmdbPreparedStatement_bs.java:2489)
at dm.jdbc.driver.DmdbPreparedStatement_bs.execute(DmdbPreparedStatement_bs.java:1632)
at dm.jdbc.driver.DmdbPreparedStatement.do_execute(DmdbPreparedStatement.java:1929)
at dm.jdbc.filter.FilterChain.PreparedStatement_execute(FilterChain.java:1446)
at dm.jdbc.driver.DmdbPreparedStatement.execute(DmdbPreparedStatement.java:663)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at org.apache.camel.component.jdbc.JdbcProducer.doCreateAndExecuteSqlStatementWithHeaders(JdbcProducer.java:362)

回答 0
暂无回答
扫一扫
联系客服