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-all-1.2.0.jar* ) in classpath - to a locally running embedded drill instance. ( started via ./bin/drill-embedded ) - with connection url:* jdbc:drill:schema=P3.public;zk=local* - Drill Storage P3 is of type "jdbc" and connects to a PostgreSQL DB. (Remark: Storage P3 is working properly and can be queried in embedded Drill shell as expected) Problem On startup of the simple JDBC Client, I encounter: 17:36:44 DEBUG FormatPluginConfigBase: Found 0 format plugin configuration classes: . 17:36:44 DEBUG DrillConfig: DrillConfig object initialized. [error] (run-main-0) java.lang.NoClassDefFoundError: oadd/org/apache/drill/exec/store/sys/PStoreProvider java.lang.NoClassDefFoundError: *oadd/org/apache/drill/exec/store/sys/PStoreProvider* at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:100) at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:66) at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69) at oadd.net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126) at org.apache.drill.jdbc.Driver.connect(Driver.java:72) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) Analysis - Opening drill-jdbc-all-1.2.0 .jar the path /oadd/org/apache/drill/exec/... is missing in the jar. - BTW: The same holds for a freshly built drill-1.3.0-snapshot Questions - Is it reasonable (and intented) to connect to an embedded drill instance via the JDBC client, like I do? If not, what are the alternatives? - Is it a bug (or maybe unintended), that within ./*exec/jdbc-all/pom.xml *in the <filter>-section of the shade plugin, "exec/store" (line 408) is filtered? <exclude>org/apache/drill/exec/store/**</exclude> Thx for help in advance, Martin
