Summary: | JDBC Connection Configuration : Transaction Isolation level not correctly set if constant used instead of numerical | ||
---|---|---|---|
Product: | JMeter - Now in Github | Reporter: | battulga <battulga_g> |
Component: | Main | Assignee: | JMeter issues mailing list <issues> |
Status: | RESOLVED FIXED | ||
Severity: | major | CC: | p.mouawad |
Priority: | P2 | ||
Version: | 2.13 | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Attachments: | jmeter result |
Description
battulga
2016-03-04 03:11:31 UTC
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 |