为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: 8.1
【操作系统】:linux
【CPU】: x86_64
【问题描述】*:批量插入用户数据时出现序列号无效的错误,但是单挑插入正常
错误报错的日志文本为:
Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: dm.jdbc.driver.DMException: 序列号无效
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:55)
at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:87)
... 86 common frames omitted
Caused by: dm.jdbc.driver.DMException: 序列号无效
at dm.jdbc.driver.DBError.throwException(DBError.java:710)
at dm.jdbc.driver.DmdbPreparedStatement.prepareBindInParam(DmdbPreparedStatement.java:608)
at dm.jdbc.driver.DmdbPreparedStatement.do_setString(DmdbPreparedStatement.java:770)
at dm.jdbc.filter.FilterChain.PreparedStatement_setString(FilterChain.java:5365)
at dm.jdbc.filter.log.LogFilter.PreparedStatement_setString(LogFilter.java:8592)
at dm.jdbc.filter.FilterChain.PreparedStatement_setString(FilterChain.java:5361)
at dm.jdbc.driver.DmdbPreparedStatement.setString(DmdbPreparedStatement.java:1669)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.setString(DruidPooledPreparedStatement.java:366)
at org.apache.ibatis.type.StringTypeHandler.setNonNullParameter(StringTypeHandler.java:31)
at org.apache.ibatis.type.StringTypeHandler.setNonNullParameter(StringTypeHandler.java:26)
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:53)
... 87 common frames omitted
数据库执行语句为:
检查一下是不是这种情况吧