ORG.APACHE.IBATIS.TRANSACTION.TRANSACTIONeXCEPTION:Error configuring AutoCommit,Your driver may not

最新推荐文章于 2024-05-20 10:45:42 发布

蜗牛君子

最新推荐文章于 2024-05-20 10:45:42 发布

阅读量2.8k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Mybatis 文章标签： mybatis

本文链接：https://blog.youkuaiyun.com/Moonlighting_/article/details/53538923

Mybatis 专栏收录该内容

1 篇文章

订阅专栏

本文介绍如何解决MyBatis中出现的TransactionException错误，该错误与数据库连接的AutoCommit配置有关。通过修改MyBatis配置文件，启用连接池的Ping机制来确保数据库连接的有效性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误信息：ORG.APACHE.IBATIS.TRANSACTION.TRANSACTIONeXCEPTION:Error configuring AutoCommit,Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 604,992,953 milliseconds ago.

修改mybatis配置文件：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>


<properties resource="db.properties" />


<environments default="development">
<environment id="development">
<transactionManager type="jdbc" />
<dataSource type="pooled">

<property name="driver" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${userid}" />
<property name="password" value="${passwd}" />
<property name="poolPingQuery" value="SELECT NOW()" />
<property name="poolPingEnabled" value="true" />
</dataSource>
</environment>
</environments>




<mappers>
<mapper class="cn.golfonline.sureface.sport.mapper.SportMapper" />
</mappers>

</configuration>