为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:windows 10
【CPU】:
【问题描述】*:mybatis-plus连接达梦数据库,使用saveBatch进行批量保存时报错
org.springframework.jdbc.UncategorizedSQLException:
### Error flushing statements. Cause: java.sql.SQLException: Error
### Cause: java.sql.SQLException: Error
; uncategorized SQLException; SQL state [null]; error code [0]; Error; nested exception is java.sql.SQLException: Error
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
... 143 more
Caused by: java.sql.SQLException: Error
at com.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1758)
at com.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:133)
at com.alibaba.druid.pool.DruidPooledStatement.checkException(DruidPooledStatement.java:82)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:569)
... 143 more
Caused by: java.lang.RuntimeException: index out of range
at dm.jdbc.util.Buffer.readBytes(Buffer.java:679)
at dm.jdbc.util.Buffer.readBytes(Buffer.java:663)
... 143 more
<dependency>
<groupId>com.dameng</groupId>
<artifactId>Dm8JdbcDriver18</artifactId>
<version>8.1.1.49</version>
</dependency>
更换驱动包试下:
https://eco.dameng.com/community/article/343bf7655e41d1cb996f401399f548d2
驱动包获取可以参考上面老师的回复
请问解决了吗?
<dependency>
<groupId>com.dameng</groupId>
<artifactId>DmJdbcDriver18</artifactId>
<version>8.1.2.79</version>
</dependency>
8.1.2.79版本以上可以解决这个bug,官网下载最新的替换可以解决
https://eco.dameng.com/download/
建议下载最新的数据库安装包,解压后
…\source\drivers\jdbc下存在DmJdbcDriver18.jar,替换你原有的jar包