Print

---

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'



########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1