Re: JDBC driver compliance

2023-01-02 Thread James Turton
spec are optional and Drill only supports those of them that are relevant for it. Regards James On 1/2/23 08:59, Prabhakar Bhosale wrote: Dear Team, Does Apache drill JDBC driver comply with JDBC 4.0 specification? Regards Prabhakar

JDBC driver compliance

2023-01-01 Thread Prabhakar Bhosale
Dear Team, Does Apache drill JDBC driver comply with JDBC 4.0 specification? Regards Prabhakar

Re: Apache drill: how to build a custom ODBC/JDBC driver that performs rest api calls

2022-04-25 Thread James Turton
org; Damien Deom *Objet :* Re: Apache drill: how to build a custom ODBC/JDBC driver that performs rest api calls Hi Damien This is not quite the same thing but Drill does include a JDBC driver for its clients and it can query HTTP APIs (with a couple of caveats) through its HTTP storag

Re: Apache drill: how to build a custom ODBC/JDBC driver that performs rest api calls

2022-04-24 Thread Charles Givre
;mailto:user@drill.apache.org>; Damien Deom > mailto:damien.d...@energisme.com>> > Objet : Re: Apache drill: how to build a custom ODBC/JDBC driver that > performs rest api calls > > Hi Damien > > This is not quite the same thing but Drill does include a JDBC drive

RE: Apache drill: how to build a custom ODBC/JDBC driver that performs rest api calls

2022-04-22 Thread Damien Deom
<mailto:damien.d...@loamics.com> www.loamics.com<http://www.loamics.com/> De : James Turton Envoyé : mercredi 13 avril 2022 15:24 À : user@drill.apache.org; Damien Deom Objet : Re: Apache drill: how to build a custom ODBC/JDBC driver that performs rest api calls Hi Damien This

Re: Apache drill: how to build a custom ODBC/JDBC driver that performs rest api calls

2022-04-13 Thread James Turton
Hi Damien This is not quite the same thing but Drill does include a JDBC driver for its clients and it can query HTTP APIs (with a couple of caveats) through its HTTP storage plugin. The net effect is that without much legwork you can query data from an HTTP API by sending SQL statements

Apache drill: how to build a custom ODBC/JDBC driver that performs rest api calls

2022-04-13 Thread Damien Deom
Hi, I'd like to know if Apache Drill allows to easily build an ODBC/JDBC driver that performs RPC calls to api's we're developing in our company. Solutions like like Progress allows to do that : https://www.progress.com/tutorials/odbc/2-hour-tutorial-build-your-own-custom-odbc-driver

Re: Drill JDBC driver not working with Apache tomcat

2020-05-15 Thread Prabhakar Bhosaale
Hi Team, Please help or give any pointer on below issue. Your help is greatly appreciated...Thx Regards Prabhakar On Fri, May 15, 2020 at 1:35 PM Prabhakar Bhosaale wrote: > 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

Drill JDBC driver not working with Apache tomcat

2020-05-15 Thread Prabhakar Bhosaale
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 give error java.lang.ClassNotFoundException: org.apache.drill.jdbc.Driver The driver file is copied to

Re: java version for Drill JDBC driver

2020-04-12 Thread Charles Givre
t; -Original Message- > From: Charles Givre > Sent: Sunday, April 12, 2020 12:16 PM > To: user > Subject: Re: java version for Drill JDBC driver > > Hey Rafael, > Could you open a PR to fix this? Or If you're not comfortable, a JIRA will > do and tag me in it

RE: java version for Drill JDBC driver

2020-04-12 Thread Jaimes, Rafael - 0993 - MITLL
JIRA filed for now https://issues.apache.org/jira/browse/DRILL-7699 -Original Message- From: Charles Givre Sent: Sunday, April 12, 2020 12:16 PM To: user Subject: Re: java version for Drill JDBC driver Hey Rafael, Could you open a PR to fix this? Or If you're not comfortable, a JIRA

Re: java version for Drill JDBC driver

2020-04-12 Thread Charles Givre
> a version of javax.validation being called in about 7 years old (1.1.0.Final) > Replacing it with version 2.0.1.Final and rebuild of the JDBC driver jar > solved the problem. > > -Original Message- > From: Paul Rogers > Sent: Thursday, April 9, 2020 3:31 PM > To: user@

Re: java version for Drill JDBC driver

2020-04-09 Thread Paul Rogers
it with version 2.0.1.Final and rebuild of the JDBC driver jar solved the problem. -Original Message- From: Paul Rogers Sent: Thursday, April 9, 2020 3:31 PM To: user@drill.apache.org Subject: Re: java version for Drill JDBC driver Hi Rafael, Drill's Git-based tests run against all Java

RE: java version for Drill JDBC driver

2020-04-09 Thread Jaimes, Rafael - 0993 - MITLL
One of my coworkers looked at the pom.xml in /exec/jdbc and noticed there was a version of javax.validation being called in about 7 years old (1.1.0.Final) Replacing it with version 2.0.1.Final and rebuild of the JDBC driver jar solved the problem. -Original Message- From: Paul Rogers

Re: java version for Drill JDBC driver

2020-04-09 Thread Paul Rogers
is wrote: I use the JDBC driver via an RJDBC wrapper I wrote and the rJava it runs in is built with JDK 11, so it definitely is working in 11 for me. > On Apr 9, 2020, at 11:38, Jaimes, Rafael - 0993 - MITLL > wrote: > > On the topic of java versions, I am trying to load the

Re: java version for Drill JDBC driver

2020-04-09 Thread Bob Rudis
I use the JDBC driver via an RJDBC wrapper I wrote and the rJava it runs in is built with JDK 11, so it definitely is working in 11 for me. > On Apr 9, 2020, at 11:38, Jaimes, Rafael - 0993 - MITLL > wrote: > > On the topic of java versions, I am trying to load the Drill

java version for Drill JDBC driver

2020-04-09 Thread Jaimes, Rafael - 0993 - MITLL
On the topic of java versions, I am trying to load the Drill JDBC driver in a docker container running Presto and Java 11, I'm getting the following error: ERROR main io.prestosql.server.PrestoServer 'java.lang.String javax.validation.BootstrapConfiguration.getClockProviderClassName

Re: JDBC driver for Java 7 vesion

2020-02-25 Thread Paul Rogers
Hi Prabhakar, > > As it turns out, Drill is built for Java 8-13, but we've not built for > Java 7 in quite some time. (Java 7 reached end of life several years back.) > > That said, you can try to clone the project sources and do a build. > Unfortunately, the JDBC driver tends to use q

Re: JDBC driver for Java 7 vesion

2020-02-25 Thread Prabhakar Bhosaale
That said, you can try to clone the project sources and do a build. > Unfortunately, the JDBC driver tends to use quite a bit of Drill's > internals and so has a rather large footprint, some of which is likely to > depend on Java 8. > > Further, Drill depends on a large number of libr

Re: JDBC driver for Java 7 vesion

2020-02-25 Thread Paul Rogers
Hi Prabhakar, As it turns out, Drill is built for Java 8-13, but we've not built for Java 7 in quite some time. (Java 7 reached end of life several years back.) That said, you can try to clone the project sources and do a build. Unfortunately, the JDBC driver tends to use quite a bit

JDBC driver for Java 7 vesion

2020-02-24 Thread Prabhakar Bhosaale
Hi All, We are using drill 1.16.0 and we are trying to create JDBC datasource on WAS8.5 with java7. we are getting following error. "exception: java.sql.SQLException: java.lang.UnsupportedClassVersionError: JVMCFRE003 bad major version; class=org/apache/drill/jdbc/Driver, offset=6" So

Re: JDBC Driver

2018-04-02 Thread Arjun kr
erGuide/Appendix.Oracle.Options.SSL.html#Appendix.Oracle.Options.SSL.JDBC Thanks, Arjun From: Sorabh Hamirwasia <shamirwa...@mapr.com> Sent: Tuesday, April 3, 2018 12:21 AM To: user@drill.apache.org Subject: Re: JDBC Driver Hi Ravi, I just want to confirm that you are using

Re: JDBC Driver

2018-04-02 Thread Sorabh Hamirwasia
parameters for SSL configuration. But having said that, probably you can check the JDBC driver which you are using if it allows to pass these SSL parameters as key-value pair within URL or not. Also not sure what you mean by ODBC driver not having the option to enable this, since Drill doesn't

JDBC Driver

2018-03-30 Thread Ravi Venugopal (C)
Hi I am trying to POC drill for a customer and I am working on connecting the JDBC driver to RDS on Aws for Oracle. Here is the Certificate of security on the TNS names, I do not see a syntx / kvp for the json to add this cert path (Cert info hidden) (SECURITY = (SSL_SERVER_CERT_DN = "

Using Drill JDBC Driver on IBM JDK

2017-02-07 Thread Narendar Yalamanchilli
Hi,  I have Apache Drill 1.9 running in embedded mode on windows machine using Oracle JDK 1.8. I am trying to connect to Drill using the JDBC driver from an application that will need to use IBM JDK 1.8 because of some other compatibility issue. However, I am getting the following error from

drill jdbc driver for status of query

2016-10-26 Thread krishna mahadevan
it. For the same purpose i need to get the state of the query. is there a way to to get the state using drill jdbc driver? statement.executeQuery(query); should return RUNNING/FAILED/COMPLETED Thanks in Advance Krishna

Re: JDBC Driver - Possible regression

2016-01-20 Thread Abdel Hakim Deneche
://issues.apache.org/jira/browse/DRILL-2482 > > > > We are either doing something wrong or this or this is a regression. Has > > anyone else experienced not being able to get nested structures via the > > latest JDBC driver? > > > > (I'm going to pull the lastest

Re: Unable to use Drill JDBC Driver: NoClassDefFoundError ( sys/PStoreProvider ) on startup.

2015-11-03 Thread Martin Senne
alhost with drillbit=localhost > > See if that works for you. > > —Andries > > > On Nov 2, 2015, at 9:48 AM, Martin Senne <martin.se...@googlemail.com> > wrote: > > > > Hi all, > > > > Situation > > > > following t

Re: Unable to use Drill JDBC Driver: NoClassDefFoundError ( sys/PStoreProvider ) on startup.

2015-11-03 Thread Andries Engelbrecht
v 2, 2015, at 9:48 AM, Martin Senne <martin.se...@googlemail.com > > <mailto:martin.se...@googlemail.com>> wrote: > > > > Hi all, > > > > Situation > > > > following the details on > > https://drill.apache.org/docs/using-the-jdbc-driver/

Re: Unable to use Drill JDBC Driver: NoClassDefFoundError ( sys/PStoreProvider ) on startup.

2015-11-02 Thread Andries Engelbrecht
. —Andries > On Nov 2, 2015, at 9:48 AM, Martin Senne <martin.se...@googlemail.com> wrote: > > Hi all, > > Situation > > following the details on > https://drill.apache.org/docs/using-the-jdbc-driver/ > I'm trying to connect > > - with a simple J

Unable to use Drill JDBC Driver: NoClassDefFoundError ( sys/PStoreProvider ) on startup.

2015-11-02 Thread Martin Senne
Hi all, Situation following the details on https://drill.apache.org/docs/using-the-jdbc-driver/ I'm trying to connect - with a simple JDBC Client (based on the code on bottom of "using-the-jdbc-driver"-page) - using the Drill JDBC Driver( *./jars/jdbc-driver/drill-jdbc

Re: JDBC driver for MySQL - storage plugin config and push down ?

2015-10-07 Thread Neeraja Rentachintala
pdating the > > plugin ? > > > > reg//ulf > > > > > > reg//ulf > > > > > > Ulf Andreasson | Ericsson Global Alliance Solution Engineer, MapR.com | > +46 > > 72 700 2295 > > > > > > On Mon, Oct 5, 2015 at 5:10 P

Re: JDBC driver for MySQL - storage plugin config and push down ?

2015-10-07 Thread Andrew Selden
sult in a failure in creating/updating the > plugin ? > > reg//ulf > > > reg//ulf > > > Ulf Andreasson | Ericsson Global Alliance Solution Engineer, MapR.com | +46 > 72 700 2295 > > > On Mon, Oct 5, 2015 at 5:10 PM, Jacques Nadeau <jacq...@dremio.c

Re: Using Drill JDBC Driver alongside a recent Calcite library

2015-08-19 Thread Parth Chandra
Hi Piotr, You might have to wait till 1.2 comes out. There's a patch outstanding that needs to be updated and merged that should address this issue. Parth On Sun, Aug 16, 2015 at 8:06 AM, Piotr Sokólski p...@pyetras.com wrote: Hi. I’m using calcite-core 1.2 in my project. Importing the

Using Drill JDBC Driver alongside a recent Calcite library

2015-08-16 Thread Piotr Sokólski
Hi. I’m using calcite-core 1.2 in my project. Importing the Drill driver into the classpath seems to cause all kinds of problems, possibly due to different versions of Calcite from my package dependencies and the one imported from the driver jar. Is it possible to have the two of them working