Print

---

Tatiana

That is trivial to fix, I fixed it on the tip of the master.

All "SHOW" commands will now work.

Thanks,
Jacek




On 12/09/2014 03:11 PM, Tatiana Goldina wrote:
> 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]>
>> <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