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 <cgi...@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....@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 <rafjai...@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 < > gar...@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/ > >>> > >> > >