https://bz.apache.org/bugzilla/show_bug.cgi?id=60889
Liu XP <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #5 from Liu XP <[email protected]> --- Hi, This is result. I listed Request Query & Request Quit in Wireshark. The Query "SELECT USER()" could be found in each test case. 1) test while idle to false : No query Statement [truncated]: /* mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 ) */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 Command: Ping (14) -- test ping instead of validation query. Statement: select @@session.tx_read_only Statement: rollback Statement: SET autocommit=1 Command: Quit (1) Statement [truncated]: /* mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 ) */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() -- stubborn query. Statement: select Name from zabbixkey; -- test JDBC Request Statement: select @@session.tx_read_only Statement: rollback Statement: SET autocommit=1 Command: Quit (1) 2) test while idle == true + No Validation query => SELECT USER() is emitted Statement [truncated]: /* mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 ) */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 Command: Ping (14) -- test ping instead of validation query. Statement: select @@session.tx_read_only Statement: rollback Statement: SET autocommit=1 Command: Quit (1) Statement [truncated]: /* mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 ) */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() -- stubborn query. Statement: select Name from zabbixkey; -- test JDBC Request Statement: select @@session.tx_read_only Statement: rollback Statement: SET autocommit=1 Command: Quit (1) 3) test while idle == true + Validation query => validation query is emitted Statement [truncated]: /* mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 ) */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 -- Yes, this is my validation query. Statement: select @@session.tx_read_only Statement: rollback Statement: SET autocommit=1 Command: Quit (1) Statement [truncated]: /* mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 ) */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() -- stubborn query. Statement: select Name from zabbixkey; -- test JDBC Request 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.
