i connect to mysql database using jdbc configuration sample. custom transaction isolation level set on jdbc configuration. but jdbc sampler not set on jdbc configurtaion isolation level (set on mysql server side default isolation level). i simple test checked. add jdbc configuration and custom isolation. add jdbc sampler using jdbc connection pool query is (show variables like '%isolation%'; or show variables like '%isolation%';) then check result.
Hello, What does this sql show: SELECT @@GLOBAL.tx_isolation, @@tx_isolation; What MySQL Driver are you using ? Can you make a test with nightly build : https://builds.apache.org/job/JMeter-trunk/lastSuccessfulBuild/artifact/trunk/dist/
mysql jdbc driver: mysql-connector-java-5.1.38-bin.jar jmeter version: 2.13 r1665067 mysql server version: 5.6.27 default isolation level: READ-COMMITED
Created attachment 33640 [details] jmeter result https://builds.apache.org/job/JMeter-trunk/lastSuccessfulBuild/artifact/trunk/dist/ same result your r1733851 version same r1665067. result is read-commited as default isolation. must have read-uncommited.
https://builds.apache.org/job/JMeter-trunk/lastSuccessfulBuild/artifact/trunk/dist/ same result your r1733851 version same r1665067. result is read-commited as default isolation. must have read-uncommited.
Hello, Can you try the code use by JMeter using the same driver that you use in JMeter ? I am not sure this is a JMeter bug. Regards
I wrote servlet using jdbc(jndi resource lookup) connect to mysql. jdbc same driver, same database and isolation level set on jndi resource. this case no problem. working fine. I tried JMeter connect JSR sample. jdbc same driver and same database. this case same problem a jdbc sampler.
Author: pmouawad Date: Tue Aug 2 21:07:07 2016 New Revision: 1755003 URL: http://svn.apache.org/viewvc?rev=1755003&view=rev Log: Bug 59113 - JDBC Connection Configuration : Transaction Isolation level not correctly set if constant used instead of numerical Bugzilla Id: 59113 Modified: jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/config/DataSourceElementBeanInfo.java jmeter/trunk/xdocs/changes.xml
@battulga, thanks for report, I finally found the problem. Could you test nightly build tomorrow using this: http://jmeter.apache.org/nightly.html Thank you
This issue has been migrated to GitHub: https://github.com/apache/jmeter/issues/3879