drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Givre <cgi...@gmail.com>
Subject Re: ODBC driver status?
Date Thu, 22 Oct 2020 12:56:26 GMT
HI Prabhakar, 
I'd strongly recommend you post a JIRA for this as well.  The email forums are too easily
lost. If someone else is having this issue, you're much more likely to get a response via
JIRA.  
Thanks,
--C

> On Oct 22, 2020, at 8:22 AM, Prabhakar Bhosaale <bhosale.p.v@gmail.com> wrote:
> 
> Hi Charles,
> 
> I had asked this issue on our this forum on 15th May 2020 but did not get .
> Below was the error that I had reported. If you advise I will raise the
> issue again with the details below. thx
> 
> "Hi Team,
> I am trying to use Apache drill driver 1.16.0 in java servlet on
> tomcat 7.70.  When i run the web application and try to use
> Class.forName("org.apache.drill.jdbc.Driver");
> 
> It gave the error java.lang.ClassNotFoundException:
> org.apache.drill.jdbc.Driver
> 
> The driver file is copied to WebContent\WEB-INF\lib folder.
> 
> But if I try to use the same code from java standalone application then it
> works perfectly.  So any suggestions on how to resolve this issue?"
> 
> On Thu, Oct 22, 2020 at 5:19 PM Charles Givre <cgivre@gmail.com> wrote:
> 
>> Hi Prabhakar,
>> Thanks for sending this.  Would you mind documenting these issues with the
>> JDBC driver in JIRA (issues.apache.org <http://issues.apache.org/>)?
>> Thanks!
>> -- C
>> 
>>> On Oct 22, 2020, at 2:16 AM, Prabhakar Bhosaale <bhosale.p.v@gmail.com>
>> wrote:
>>> 
>>> Hi,
>>> 
>>> Just some additional information on JDBC driver based on my experience.
>>> 
>>> If you are planning to use JDBC driver with tomcat server then the driver
>>> which comes with the drill binary will not work as it has not implemented
>>> certain classes and packages as required by tomcat. So I ended up using
>>> "Simba drill JDBC driver". I guess it is an extension of MapR driver
>> though
>>> I am not sure.
>>> 
>>> Thanks and Regards
>>> Prabhakar
>>> 
>>> 
>>> On Thu, Oct 22, 2020 at 3:09 AM Rafael Jaimes III <rafjaimes@gmail.com>
>>> wrote:
>>> 
>>>> The ODBC driver hasn't seen an update for Drill since version 1.15.
>>>> It was working fine with Drill 1.16 but since Drill 1.17, some minor
>> errors
>>>> have arisen.
>>>> 
>>>> I would switch to JDBC driver where possible, not the MapR one, but the
>> one
>>>> that comes updated with the Drill binary.
>>>> 
>>>> You can also use the REST API which is getting better recently which
>>>> requires no driver at all, but JDBC is going to offer the best
>> performance.
>>>> 
>>>> Best,
>>>> Rafael
>>>> 
>>>> 
>>>> On Wed, Oct 21, 2020 at 5:10 PM Gareth Western <
>> gareth@garethwestern.com>
>>>> wrote:
>>>> 
>>>>> Hi, Is the ODBC driver still maintained / usable? The download location
>>>>> documented on the website[1] looks like it hasn’t been updated since
>>>> 2018.
>>>>> 
>>>>> 
>>>>> 
>>>>> 1.  http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/
>>>>> 
>>>> 
>> 
>> 


Mime
View raw message