[
https://issues.apache.org/jira/browse/DRILL-3015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14548316#comment-14548316
]
Daniel Barclay (Drill) commented on DRILL-3015:
-----------------------------------------------
We've recently added, as an internal (unsupported) diagnostic feature, a proxy
JDBC driver that traces calls made through it to another JDBC driver.
Using it should show which JDBC calls SQuirrel is making and maybe why SQuirrel
is reporting
"Cannot open SQL connection". See the instructions comment in
https://issues.apache.org/jira/browse/DRILL-2343.
However, given the SQuirreL error message you report, it may be that SQuirreL
(and Java's DriverManager) isn't even finding the Drill JDBC driver. Note that
Drill's JDBC driver does not yet use Java's Service Provider Mechanism to make
itself known to JDBC's DriverManager (as specified by JDBC 4.0), so make sure
that you've configured SQuirreL to load the Drill JDBC driver. (The same
applies to the tracing proxy driver.)
> Can't connect to Squirrel using JDBC
> ------------------------------------
>
> Key: DRILL-3015
> URL: https://issues.apache.org/jira/browse/DRILL-3015
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
> Affects Versions: 0.9.0
> Reporter: Murtaza
> Assignee: Daniel Barclay (Drill)
> Priority: Blocker
>
> Please suggest me what jdbc url to use with Squirrel. I have installed Apache
> Drill 0.9 on standalone macbook. I had given all types of jdbc url like below
> jdbc:drill:zk=192.168.1.7:5181/drill/drillbits1;schema=dfs
> jdbc:drill:zk=192.168.1.7:2181/drill/drillbits1;schema=dfs
> jdbc:drill:zk=KWTLT01407.local:5181/drill/drillbits1;schema=dfs
> jdbc:drill:zk=KWTLT01407.local:2181/drill/drillbits1;schema=dfs
> All is giving me error in Squirrel stating "Cannot open SQL connection".
> Please suggest me how to use JDBC to connect to Apache Drill installed on
> standalone machines.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
