[I] jdbc request always set autocommit=1 [jmeter]

[via GitHub]

liwei225 opened a new issue, #6090:
URL: https://github.com/apache/jmeter/issues/6090

   ### 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
   <img width="934" alt="image" 
src="https://github.com/apache/jmeter/assets/22341888/e5a4ff4d-ec3b-4b9d-983b-52e934ef587a";>
   
   <img width="728" alt="image" 
src="https://github.com/apache/jmeter/assets/22341888/c29f048c-673a-414a-9098-ac95ed150700";>
   
   <img width="681" alt="image" 
src="https://github.com/apache/jmeter/assets/22341888/296969a6-1a30-431c-aa67-52aac08682ef";>
   
   <img width="770" alt="image" 
src="https://github.com/apache/jmeter/assets/22341888/e108ca49-f7a2-430f-8e1a-5faf0fa20308";>
   
   
   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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@jmeter.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org