Connector/J and multiple connections

connectorj_optimization.sql

Connect root@localhost on mydb

Query   /* mysql-connector-java-5.1.17 ( Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect'

Query   /* mysql-connector-java-5.1.17 ( Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increment_increment
Query   SHOW COLLATION
Query   SET NAMES latin1
Query   SET character_set_results = NULL
Query   SET autocommit=1
Query   SET sql_mode='STRICT_TRANS_TABLES'
Query   SET autocommit=1

Query   SELECT name FROM funding WHERE id IN (1,2,3) /* Actual Query */