Hi Charles, Thanks for the reply. The dril version is 1.16 and JDBC version is also same. The drill is installed on windows in standalone mode.
The challenge here is that, when we created the data provider and data source on WAS, we have not given any hostname or port details of drill server, so when test connection happens on WAS server, it is actually not connecting to drill. Please let me know if you need any additional information. Once again thanks for your help Regards Prabhakar On Tue, Mar 24, 2020 at 6:19 PM Charles Givre <cgi...@gmail.com> wrote: > HI Prabhakar, > Thanks for your interest in Drill. Can you share your config info as well > as the versions of Drill and JDBC Driver that you are using? > Thanks, > -- C > > > > On Mar 24, 2020, at 7:07 AM, Prabhakar Bhosaale <bhosale....@gmail.com> > wrote: > > > > Hi Team, > > > > we are trying to connect to apache drill from websphere 220.127.116.11. We > created the the Data provider and data source as per standard process of > WAS. But when we try to test the connection, it gives following error. > > > > "Test connection operation failed for data source retrievalds on server > ARCHIVE_SERVER at node ARCHIVALPROFILENode1 with the following exception: > java.lang.Exception: DSRA8101E: DataSource class cannot be used as > one-phase: ClassCastException: org.apache.drill.jdbc.Driver incompatible > with javax.sql.ConnectionPoolDataSource " > > > > We are using SDK version 1.8 > > Attaching the JVM log also for your reference. thx > > > > Any pointers or any documentation in this regards would be appreciated. > Please help. thx > > > > Regards > > Prabhakar > > <JVM_Error_Log.txt> > >