Sorry, please ignore.
On Mon, Mar 30, 2020 at 1:55 PM Herman Tan <her...@redcubesg.com> wrote: > 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 <ihor.huzenko....@gmail.com> > 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 <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 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> >> > >> > >> >