[Bug 60889] JMeter JDBC sample will call SELECT USER() when testing with MySQL JDBC

[bu...@apache.org]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60889

--- Comment #8 from Liu XP <li...@sina.com> ---
Hi Philippe,

This issue could be reproduced with MySQL JDBC 5.1.41. The following is my
patch info. It could depress the SELECT USER() Query.
------------------------------------------------
---
a/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/sampler/JDBCSampler.java
+++
b/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/sampler/JDBCSampler.java
@@ -80,7 +80,7 @@ public class JDBCSampler extends AbstractJDBCTestElement
implements Sampler, Tes
             } finally {
                 res.connectEnd();
             }
-            res.setResponseHeaders(conn.toString());
+            res.setResponseHeaders("DB Pool Name: " + getDataSource() +
";\nConnect Catalog: " + conn.getCatalog());
             res.setResponseData(execute(conn, res));
         } catch (SQLException ex) {
             final String errCode = Integer.toString(ex.getErrorCode());
------------------------------------------------

MySQL JDBC 5.1.41 Wireshark:
Statement [truncated]: /* mysql-connector-java-5.1.41 ( Revision:
83c6dc41b96809df81444362933043b20a1d49d5 ) */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=1
Statement: SET autocommit=0
Statement: Select 1
Statement: select @@session.tx_read_only
Statement: rollback
Statement: SET autocommit=1
Command: Quit (1)
Statement [truncated]: /* mysql-connector-java-5.1.41 ( Revision:
83c6dc41b96809df81444362933043b20a1d49d5 ) */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=1
Statement: SET autocommit=0
Statement: SELECT USER()
Statement: select Name from zabbixkey;
Statement: select @@session.tx_read_only
Statement: rollback
Statement: SET autocommit=1
Command: Quit (1)


Thanks,
LiuXP

-- 
You are receiving this mail because:
You are the assignee for the bug.