jdbc request always set autocommit=1
- Dominant language
- Java
- Stars
- 9.5k
- Forks
- 2.3k
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 5
Description
### Expected behavior
fix bug
### Actual behavior
jdbc request always set autocommit=1
### Steps to reproduce the problem
i wanna test transaction on mysql 8.0.20 .
however, after opening a transaction, the next jdbc request always sets autocommit=1
mysql general_log:
2023-10-20T08:02:11.701987Z 23 Query SET autocommit=0
after 5 sec ,i found next jdbc request[select_1] send [ set autocommit=1] before select statement
2023-10-20T08:02:16.721626Z 23 Query SET autocommit=1
2023-10-20T08:02:16.741564Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:16.744943Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:16.750466Z 23 Query select * from t1 limit 10
2023-10-20T08:02:21.770572Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:21.779301Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:21.782025Z 23 Query select * from t1 limit 10
2023-10-20T08:02:26.800593Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:26.811092Z 23 Query SELECT @@session.transaction_isolation
2023-10-20T08:02:26.829268Z 23 Quit
### JMeter Version
5.6.2
### Java Version
openjdk 17.0.2 2022-01-18
### OS Version
macos
Contributor guide
Assessment
This issue has not been assessed yet.