[MDEV-22508] mariadb/CONNECT - no suitable driver found for apache drill jdbc Created: 2020-05-08  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: None
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Major
Reporter: herman Assignee: Olivier Bertrand
Resolution: Unresolved Votes: 0
Labels: None


 Description   

in relation to MDEV-10936

Hi All!

i am trying to set up Mariadb/CONNECT to federate towards Apache Drill

a working JDBC connector towards drill works via the following connection string

Database Driver:  org.apache.drill.jdbc.impl.DriverImpl  
Database URL: jdbc:drill:drillbit=127.0.0.1:31010  
Database Type:  drill

i'm using the apache drill jdbc driver
../apache-drill-1.17.0/jars/jdbc-driver/drill-jdbc-all-1.17.0.jar

however, when i want to create a table

create table jt1 engine=connect table_type=JDBC connection='jdbc:drill:drillbit=127.0.0.1:31010';

i get the following error

ERROR 1105 (HY000): Connecting: java.sql.SQLException: No suitable driver found for jdbc:drill:drillbit=127.0.0.1:31010 rc=-2

is there a way to specify the driver as "org.apache.drill.jdbc.impl.DriverImpl" as you would in a regular jdbc connection?

      // load the JDBC driver
      Class.forName("org.apache.drill.jdbc.impl.DriverImpl");

Thx in advance!

Herman



 Comments   
Comment by Olivier Bertrand [ 2020-06-23 ]

See in the MariaDB CONNECT plugin documentation: JDBC Table Type: Accessing Tables from Another DBMS: paragraphes Setting the Required Information

Generated at Thu Feb 08 09:15:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.