drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prabhakar Bhosaale <bhosale....@gmail.com>
Subject Re: ODBC driver status?
Date Thu, 22 Oct 2020 12:22:03 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message