Hi,
Thank you again for making QSERV work with JDBC. As I mentioned yesterday, I can connect to QSERV with mysql-connector-java-5.1.34, but not with the newer mysql-connector-java-5.1.6. The difference is in "SHOW COLLATION" command, which is not yet supported by QSERV.
With mysql-connector-java-5.1.6, the commands executed during the connection are
1. /* mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} ) */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'
2. SHOW COLLATION
3. SET NAMES latin1
4.SET character_set_results = NULL
5.SET autocommit=1
6. SET sql_mode='STRICT_TRANS_TABLES'
Tatiana
P.S. This is just FYI. It does not hold me in any way.
P.P.S. commands executed with mysql-connector-java-5.1.34:
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 = 'license' OR Variable_name = 'init_connect'
2. /* mysql-connector-java-5.1.34 ( Revision:
[log in to unmask]
<mailto:[log in to unmask]> )
*/SELECT @@session.auto_increment_increment
3. SET NAMES latin1
4. SET character_set_results = NULL
5. SET autocommit=1
6. SET sql_mode='STRICT_TRANS_TABLES'