 |
 |
Here is a test program I am using. It is similar to the one John sent before. The configuration options to the driver are hardcoded in the URL. It requires MySQL JDBC driver, which can be downloaded from here: http://dev.mysql.com/downloads/connector/j/ To compile and run: javac TestQserv.java java -cp .:mysql-connector-java-5.1.34/mysql-connector-java-5.1.34-bin.jar TestQserv The options to the driver are here: http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html Both URL formats "jdbc:mysql://address=(protocol=tcp)(host=lsst-db1.ipac.caltech.edu)(port=4040)(user=qsmaster)/LSST?dumpQueriesOnException=true" and "jdbc:mysql://lsst-db1.ipac.caltech.edu:4040/LSST?user=qsmaster&dumpQueriesOnException=true" produce the same error (Qserv error: 'ParseException:ANTLR parse error:unexpected token: /:') when getting the connection. Thank you very much for your help! Tatiana P.S. No problem executing this command with mysql command line client: >> mysql -h lsst-db1.ipac.caltech.edu -u qsmaster -P 4040 -D LSST --protocol tcp -e "/* mysql-connector-java-5.1.6 ( Revision: xxx ) */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'" +--------------------------+---------------------------------------------------------------+ | Variable_name | Value | +--------------------------+---------------------------------------------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_results | latin1 | | character_set_server | latin1 | | init_connect | | | interactive_timeout | 28800 | | language | /home/lsstadm/stack/Linux64/mysql/5.1.65/share/mysql/english/ | | lower_case_table_names | 0 | | max_allowed_packet | 1048576 | | net_buffer_length | 16384 | | net_write_timeout | 60 | | query_cache_size | 0 | | query_cache_type | ON | | sql_mode | | | system_time_zone | PST | | time_zone | SYSTEM | | tx_isolation | REPEATABLE-READ | | wait_timeout | 28800 | +--------------------------+---------------------------------------------------------------+ On Dec 3, 2014, at 10:07 AM, Serge Monkewitz <[log in to unmask]> wrote: > Monkewitz <[log in to unmask]> wrote: > >> Tatiana: forwarding to qserv-l, since I am taking today off to deal with family matters. I’ll take a look tomorrow if no-one else has any ideas. >> >> For context - connecting to qserv via JDBC still fails, even after Jacek’s show variables fix (and fix for the fix). >> >> Begin forwarded message: >> >>> From: Tatiana Goldina <[log in to unmask]> >>> Subject: Re: rebuilding QSERV >>> Date: December 2, 2014 at 4:02:08 PM PST >>> To: Serge Monkewitz <[log in to unmask]> >>> >>> I am out of clues. I am still getting the same error when connecting through the JDBC driver. >>> >>> jdbc:mysql://lsst-db1.ipac.caltech.edu:4040/LSST?user=qsmaster&dumpQueriesOnException=true&traceProtocol=true >>> >>> trace is attached. I don't know how to debug it further. >>> >> >> ######################################################################## 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