Igor, You are a drill user? That's great! Our paths has crossed again.
Herman On Tue, Mar 24, 2020 at 9:28 PM Igor Guzenko <[email protected]> wrote: > Hello Prabhakar, > > Seems like there is a similar question on > > https://stackoverflow.com/questions/1677722/websphere-application-server-data-source > and > easiest path is to uncheck enable2Phase somewhere in WebSphere driver > settings. > Or harder way is that you can try to make a small project just to wrap > Drill driver with some of JDBC connection pools like HikariCP. > > Thanks, > Igor > > On Tue, Mar 24, 2020 at 2:49 PM Charles Givre <[email protected]> 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 <[email protected] > > > > wrote: > > > > > > Hi Team, > > > > > > we are trying to connect to apache drill from websphere 8.5.5.9. 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> > > > > >
