https://bz.apache.org/bugzilla/show_bug.cgi?id=61259
Bug ID: 61259
Summary: When set the JDBC auto commit false, the transaction
behavior is different with JMeter 2.13 and rollback
STMT for each sample.
Product: JMeter
Version: 3.2
Hardware: PC
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: Main
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
When I want to test JDBC with transaction and disable auto commit in JDBC
Connection Configuration panel, Each JDBC sampler will be rollback.
This behavior is different with JMeter 2.13+excalibur package and the multiple
JDBC sampler transaction couldn't be tested on latest JMeter version.
JDBC Test Sampler
1. select * from testplan where CreatorId = 10001;
2. select count(1) from testplan;
3. commit
JMeter 2.13+excalibur
Wireshark.info from JDBC client side:
Statement [truncated]: /* mysql-connector-java-5.1.40 ( Revision:
402933ef52cad9aa82624e80acbea46e3a701ce6 ) */SELECT
@@session.auto_increment_increment AS auto_increment_increment,
@@character_set_client AS character_set_client, @@charac
Statement: SET NAMES utf8
Statement: SET character_set_results = NULL
Statement: SET autocommit=0
Statement: select * from testplan where CreatorId = 10001;
Statement: select count(1) from testplan;
Statement: commit
Statement: rollback
Command: Quit (1)
JMeter 3.2+commons-dbcp2
Wireshark.info from JDBC client side:
Statement [truncated]: /* mysql-connector-java-5.1.40 ( Revision:
402933ef52cad9aa82624e80acbea46e3a701ce6 ) */SELECT
@@session.auto_increment_increment AS auto_increment_increment,
@@character_set_client AS character_set_client, @@charac
Statement: SET NAMES utf8
Statement: SET character_set_results = NULL
Statement: SET autocommit=0
Statement: select * from testplan where CreatorId = 10001;
Statement: rollback
Statement: SET autocommit=1
Statement: SET autocommit=0
Statement: select count(1) from testplan;
Statement: rollback
Statement: SET autocommit=1
Statement: SET autocommit=0
Statement: commit
Statement: rollback
Statement: SET autocommit=1
Command: Quit (1)
--
You are receiving this mail because:
You are the assignee for the bug.
