You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@jmeter.apache.org by bu...@apache.org on 2016/03/04 04:11:31 UTC
[Bug 59113] New: can't set isolation level using jdbc connect to
mysql
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
Bug ID: 59113
Summary: can't set isolation level using jdbc connect to mysql
Product: JMeter
Version: 2.13
Hardware: PC
OS: Linux
Status: NEW
Severity: major
Priority: P2
Component: Main
Assignee: issues@jmeter.apache.org
Reporter: battulga_g@live.com
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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 59113] JDBC Connection Configuration : Transaction Isolation
level not correctly set if constant used instead of numerical
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
--- Comment #8 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
@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
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 59113] can't set isolation level using jdbc connect to mysql
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
--- Comment #6 from battulga <ba...@live.com> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 59113] JDBC Connection Configuration : Transaction Isolation
level not correctly set if constant used instead of numerical
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
Philippe Mouawad <p....@ubik-ingenierie.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |FIXED
--- Comment #7 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
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
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 59113] can't set isolation level using jdbc connect to mysql
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
Philippe Mouawad <p....@ubik-ingenierie.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |p.mouawad@ubik-ingenierie.c
| |om
Status|NEW |NEEDINFO
--- Comment #1 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
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/
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 59113] can't set isolation level using jdbc connect to mysql
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
--- Comment #2 from battulga <ba...@live.com> ---
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
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 59113] can't set isolation level using jdbc connect to mysql
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
--- Comment #5 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
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
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 59113] can't set isolation level using jdbc connect to mysql
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
battulga <ba...@live.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Hardware|PC |All
OS|Linux |All
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 59113] can't set isolation level using jdbc connect to mysql
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
--- Comment #4 from battulga <ba...@live.com> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 59113] can't set isolation level using jdbc connect to mysql
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
--- Comment #3 from battulga <ba...@live.com> ---
Created attachment 33640
--> https://bz.apache.org/bugzilla/attachment.cgi?id=33640&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 59113] JDBC Connection Configuration : Transaction Isolation
level not correctly set if constant used instead of numerical
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59113
Philippe Mouawad <p....@ubik-ingenierie.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|can't set isolation level |JDBC Connection
|using jdbc connect to mysql |Configuration : Transaction
| |Isolation level not
| |correctly set if constant
| |used instead of numerical
--
You are receiving this mail because:
You are the assignee for the bug.