{"action":"closed","issue":{"url":"https://api.github.com/repos/implydata/plyql/issues/67","repository_url":"https://api.github.com/repos/implydata/plyql","labels_url":"https://api.github.com/repos/implydata/plyql/issues/67/labels{/name}","comments_url":"https://api.github.com/repos/implydata/plyql/issues/67/comments","events_url":"https://api.github.com/repos/implydata/plyql/issues/67/events","html_url":"https://github.com/implydata/plyql/issues/67","id":187298559,"number":67,"title":"not able to make connection using java code","user":{"login":"justgig8","id":1078717,"avatar_url":"https://avatars.githubusercontent.com/u/1078717?v=3","gravatar_id":"","url":"https://api.github.com/users/justgig8","html_url":"https://github.com/justgig8","followers_url":"https://api.github.com/users/justgig8/followers","following_url":"https://api.github.com/users/justgig8/following{/other_user}","gists_url":"https://api.github.com/users/justgig8/gists{/gist_id}","starred_url":"https://api.github.com/users/justgig8/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/justgig8/subscriptions","organizations_url":"https://api.github.com/users/justgig8/orgs","repos_url":"https://api.github.com/users/justgig8/repos","events_url":"https://api.github.com/users/justgig8/events{/privacy}","received_events_url":"https://api.github.com/users/justgig8/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-11-04T10:24:48Z","updated_at":"2016-12-11T01:30:56Z","closed_at":"2016-12-11T01:30:56Z","body":"Below is the Plyql MySQL gateway log when I try to make a connection using com.mysql.jdbc.Driver through Java class:-\r\n\r\ngauravmacbookpro:bin gaurav$ ./plyql -h localhost:8082 -i P2Y/2020-01-01 --experimental-mysql-gateway 3307\r\nMySQL Gateway listening on port: 3307\r\nNew connection 1\r\n[1] Got SQL: /* 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'\r\n[1] Got SQL: SHOW COLLATION\r\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\nFailed to resolve query with Plywood.\r\nQuery:\r\nSHOW COLLATION\r\nIf you believe this query should work please create an issue on PlyQL and include this section\r\nIssue url: https://github.com/implydata/plyql/issues\r\nMessage:\r\nSQL parse error: Expected \"COLUMNS\", \"DATABASES\", \"FULL\", \"GLOBAL\", \"SCHEMAS\", \"SESSION\", \"TABLES\" or \"VARIABLES\" but \"C\" found. on 'SHOW COLLATION'\r\nStack:\r\nError: SQL parse error: Expected \"COLUMNS\", \"DATABASES\", \"FULL\", \"GLOBAL\", \"SCHEMAS\", \"SESSION\", \"TABLES\" or \"VARIABLES\" but \"C\" found. on 'SHOW COLLATION'\r\n    at Function.Expression.parseSQL (/Users/gaurav/imply-1.3.0/dist/pivot/node_modules/plywood/build/plywood.js:5985:23)\r\n    at /Users/gaurav/imply-1.3.0/dist/pivot/node_modules/plyql/build/plyql-mysql-gateway.js:43:53\r\n    at Promise.apply (/Users/gaurav/imply-1.3.0/dist/pivot/node_modules/q/q.js:1165:26)\r\n    at Promise.promise.promiseDispatch (/Users/gaurav/imply-1.3.0/dist/pivot/node_modules/q/q.js:788:41)\r\n    at /Users/gaurav/imply-1.3.0/dist/pivot/node_modules/q/q.js:1391:14\r\n    at runSingle (/Users/gaurav/imply-1.3.0/dist/pivot/node_modules/q/q.js:137:13)\r\n    at flush (/Users/gaurav/imply-1.3.0/dist/pivot/node_modules/q/q.js:125:13)\r\n    at nextTickCallbackWith0Args (node.js:433:9)\r\n    at process._tickCallback (node.js:362:13)\r\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\n[1] Error: Connection lost: The server closed the connection."}}
{"actor":{"display_login":"vogievetsky"}}