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 <par0...@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....@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....@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 > > >
