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/24 04:31:46 UTC
Websphere JDBC data source - Class not found exception
Hi All,
we have apache drill version 1.16 and we are trying to create JDBC data
source on websphere application server. But it gives error "Class not found
org.apache.drill.jdbc.Driver" when i try to test the connection.
I followed all the instructions that are available on different sites and
on Drill site but with no success.
The only pre-requisite which is not matching is JDK version. As per listed
prerequisites it needs JDK 8 where as the websphere is running on JDK7.
is this JDK version causing the error? Any pointers to resolve this will
help. Thanks
Regards
Prabhakar
Re: Websphere JDBC data source - Class not found exception
Posted by Prabhakar Bhosaale <bh...@gmail.com>.
Hi Paul,
Thanks for your reply. we resolved this error but as mentioned in my other
email, we have java7 on this server while drill JDBC needs java8. So we are
getting error "exception: java.sql.SQLException:
java.lang.UnsupportedClassVersionError: JVMCFRE003 bad major version;
class=org/apache/drill/jdbc/Driver, offset=6". I guess it is because of
java version. So my question is where can i get JDBC driver compiled for
JAva7.
We are using drill 1.16.0 version. thx
Regards
Prabhakar
On Tue, Feb 25, 2020 at 12:33 PM Paul Rogers <pa...@yahoo.com.invalid>
wrote:
> Hi Prabhakar,
>
> While it is a bit difficult to debug class path issues via e-mail, here
> are some suggestions.
>
> First, verify that the Drill JDBC driver is indeed on your class path.
> Given that you are using an app server, it is important that the jar be
> visible to the class loader that is calling it.
>
> Second, app servers tend to formalize things like the JDBC registry. Might
> there be some config needed to ensure that the Drill driver is registered?
> Check what you did for, say, MySQL and try that.
>
> Third, some apps need to force the Drill driver class to be loaded and
> visible. See the last section of [1].
>
> Thanks,
> - Paul
>
> [1]
> http://drill.apache.org/docs/using-the-jdbc-driver/#example-of-connecting-to-drill-programmatically
>
>
>
>
> On Monday, February 24, 2020, 7:24:41 PM PST, Prabhakar Bhosaale <
> bhosale.p.v@gmail.com> wrote:
>
> Hi Team,
>
> Please help with any pointers on below issue mentioned. Thanks in advance.
>
>
> Regards
> Prabhakar
>
>
> On Mon, Feb 24, 2020 at 10:01 AM Prabhakar Bhosaale <bhosale.p.v@gmail.com
> >
> wrote:
>
> > Hi All,
> > we have apache drill version 1.16 and we are trying to create JDBC data
> > source on websphere application server. But it gives error "Class not
> found
> > org.apache.drill.jdbc.Driver" when i try to test the connection.
> >
> > I followed all the instructions that are available on different sites and
> > on Drill site but with no success.
> >
> > The only pre-requisite which is not matching is JDK version. As per
> listed
> > prerequisites it needs JDK 8 where as the websphere is running on JDK7.
> >
> > is this JDK version causing the error? Any pointers to resolve this will
> > help. Thanks
> >
> > Regards
> > Prabhakar
> >
>
Re: Websphere JDBC data source - Class not found exception
Posted by Paul Rogers <pa...@yahoo.com.INVALID>.
Hi Prabhakar,
While it is a bit difficult to debug class path issues via e-mail, here are some suggestions.
First, verify that the Drill JDBC driver is indeed on your class path. Given that you are using an app server, it is important that the jar be visible to the class loader that is calling it.
Second, app servers tend to formalize things like the JDBC registry. Might there be some config needed to ensure that the Drill driver is registered? Check what you did for, say, MySQL and try that.
Third, some apps need to force the Drill driver class to be loaded and visible. See the last section of [1].
Thanks,
- Paul
[1] http://drill.apache.org/docs/using-the-jdbc-driver/#example-of-connecting-to-drill-programmatically
On Monday, February 24, 2020, 7:24:41 PM PST, Prabhakar Bhosaale <bh...@gmail.com> wrote:
Hi Team,
Please help with any pointers on below issue mentioned. Thanks in advance.
Regards
Prabhakar
On Mon, Feb 24, 2020 at 10:01 AM Prabhakar Bhosaale <bh...@gmail.com>
wrote:
> Hi All,
> we have apache drill version 1.16 and we are trying to create JDBC data
> source on websphere application server. But it gives error "Class not found
> org.apache.drill.jdbc.Driver" when i try to test the connection.
>
> I followed all the instructions that are available on different sites and
> on Drill site but with no success.
>
> The only pre-requisite which is not matching is JDK version. As per listed
> prerequisites it needs JDK 8 where as the websphere is running on JDK7.
>
> is this JDK version causing the error? Any pointers to resolve this will
> help. Thanks
>
> Regards
> Prabhakar
>
Re: Websphere JDBC data source - Class not found exception
Posted by Prabhakar Bhosaale <bh...@gmail.com>.
Hi Team,
Please help with any pointers on below issue mentioned. Thanks in advance.
Regards
Prabhakar
On Mon, Feb 24, 2020 at 10:01 AM Prabhakar Bhosaale <bh...@gmail.com>
wrote:
> Hi All,
> we have apache drill version 1.16 and we are trying to create JDBC data
> source on websphere application server. But it gives error "Class not found
> org.apache.drill.jdbc.Driver" when i try to test the connection.
>
> I followed all the instructions that are available on different sites and
> on Drill site but with no success.
>
> The only pre-requisite which is not matching is JDK version. As per listed
> prerequisites it needs JDK 8 where as the websphere is running on JDK7.
>
> is this JDK version causing the error? Any pointers to resolve this will
> help. Thanks
>
> Regards
> Prabhakar
>