MyCATApache/Mycat-Server

java.lang.RuntimeException: java.sql.SQLException: Can't call commit when autocommit=true

Open

#2,859 opened on Sep 29, 2021

View on GitHub
 (7 comments) (0 reactions) (0 assignees)Java (3,886 forks)batch import
help wanted

Repository metrics

Stars
 (9,451 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

描述： 在mycat的server.xml配置里配置strictTxIsolation参数为true，后端springboot服务无法启动。请问如何解决（改为false服务即可启动，但是会导致执行其他事务不一致） 使用版本： Mycat-server-1.6.7.6-release-20210908145008-linux.tar.gz Mycat报错截图如下： image

Contributor guide

Research direction
Investigate the conflict between strictTxIsolation=true and autocommit. Trace the code path in Mycat's server.xml parsing and transaction management to identify where the RuntimeException is thrown.
Tech stack
java
Domain
backenddatabase
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Mostly clear
Prerequisites
JavaSQLMycat
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40