You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Prabhakar Bhosaale <bh...@gmail.com> on 2020/02/25 07:30:53 UTC
JDBC driver for Java 7 vesion
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
Re: JDBC driver for Java 7 vesion
Posted by Paul Rogers <pa...@yahoo.com.INVALID>.
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 <bh...@gmail.com> wrote:
Thanks Paul, that helps a lot.
Regards
Prabhakar
On Tue, Feb 25, 2020 at 1:30 PM Paul Rogers <pa...@yahoo.com.invalid>
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 <
> bhosale.p.v@gmail.com> 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
>
Re: JDBC driver for Java 7 vesion
Posted by Prabhakar Bhosaale <bh...@gmail.com>.
Thanks Paul, that helps a lot.
Regards
Prabhakar
On Tue, Feb 25, 2020 at 1:30 PM Paul Rogers <pa...@yahoo.com.invalid>
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 <
> bhosale.p.v@gmail.com> 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
>
Re: JDBC driver for Java 7 vesion
Posted by Paul Rogers <pa...@yahoo.com.INVALID>.
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 <bh...@gmail.com> 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