Hi Prabhakar,
One more thought if you can't upgrade your app server to Java 8, and if
back-porting Drill to Java 7 is not practical. As it turns out, all versions of
Java are compatible with your network. So, perhaps you can use a network
connection to bridge the two.
If your queries are of modest complexity, then the REST API is an option. The
REST API returns the entire data set in a single response and so works for
result sizes up to, say, several thousand rows.
A more advanced option is to create a specialized micro-service that speaks
some Java 7 compatible format on one side (Thrift? Protobuf? REST?) and uses
Drill's JDBC or client API to talk to Drill on the other side. The
micro-service would be written in Java 8 so it can work with Drill. This works
if you have limited needs (run queries, get back results). It would be a bit
too much to ask to implement an entire JDBC shim (though Calcite Avatica is
supposed to provide most of it for you.)
Thanks,
- Paul
On Tuesday, February 25, 2020, 12:24:25 AM PST, Prabhakar Bhosaale
<[email protected]> wrote:
Thanks Paul, that helps a lot.
Regards
Prabhakar
On Tue, Feb 25, 2020 at 1:30 PM Paul Rogers <[email protected]>
wrote:
> 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 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 libraries, all of which have
> likely been upgraded to Java 8. You'd have to find old Java 7 versions, and
> then figure out how to change Drill code to work with those old versions.
>
> One might well ask, is it possible for you to upgrade to a supported Java
> version? Drill must not be the only library where you have the Java 8
> dependency problem.
>
>
> Thanks,
> - Paul
>
>
>
> On Monday, February 24, 2020, 11:31:15 PM PST, Prabhakar Bhosaale <
> [email protected]> wrote:
>
> 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 where can i get the JDBC driver compiled for java7? thx
>
> Regards
> Prabhakar
>
