jmeter-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 61259] JDBC Request : since JMeter 3.0, when JDBC auto-commit is false, a rollback statement happens each time a Request is executed
Date Fri, 21 Jul 2017 09:22:50 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=61259

Liu XP <liu_xp2003@sina.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #4 from Liu XP <liu_xp2003@sina.com> ---
Yes. I have verified it and it need to be fixed with the additional setting.
dataSource.setEnableAutoCommitOnReturn(false);

You can try to test with following three JDBC Sampler with current fix
soluction.

1. Prepare some records into AAAA table and truncate table BBBB.
2. Do following SQL with 3 JDBC Sampler in one thread.
insert into BBBB (select *  from AAAA)
select Name from BBBB
Query Type with Rollback

3. And then check the BBBB table at last.
If transaction worked normally, the BBBB table should be empty.But,you will
find the table BBBB is not empty.

-- 
You are receiving this mail because:
You are the assignee for the bug.
Mime
View raw message