注册

执行sql提示数据类型不匹配

default 2021/06/16 2318 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM Database Server 64 V8//DB Version: 0x7000b
【操作系统】:centos7 x86
【CPU】: x86
【问题描述】*:将varchar的列改为text类型,发现查询时报错
提示数据类型不匹配:
Caused by: dm.jdbc.driver.DMException: 第1 行附近出现错误:
数据类型不匹配
at dm.jdbc.driver.DBError.throwException(DBError.java:635)
at dm.jdbc.c.b.n.R(MSG.java:222)
at dm.jdbc.c.b.n.O(MSG.java:182)
at dm.jdbc.c.b.n.N(MSG.java:162)
at dm.jdbc.c.a.a(DBAccess.java:892)
at dm.jdbc.c.a.a(DBAccess.java:319)
at dm.jdbc.driver.DmdbPreparedStatement.prepareSql(DmdbPreparedStatement.java:141)
at dm.jdbc.driver.DmdbPreparedStatement.<init>(DmdbPreparedStatement.java:120)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:717)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:703)
at dm.jdbc.driver.DmdbConnection.prepareStatement(DmdbConnection.java:1303)
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:316)
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.EncryptPreparedStatement$EncryptPreparedStatementGenerator.createPreparedStatement(EncryptPreparedStatement.java:264)
at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.EncryptPreparedStatement$EncryptPreparedStatementGenerator.access$000(EncryptPreparedStatement.java:233)
at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.EncryptPreparedStatement.executeQuery(EncryptPreparedStatement.java:107)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
… 144 more

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