drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3015) Can't connect to Squirrel using JDBC
Date Mon, 18 May 2015 17:17:00 GMT

    [ 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)

Mime
View raw message