drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Herman Tan <her...@redcubesg.com>
Subject Re: JDBC datasource on Websphere server 8.5.5.9
Date Mon, 30 Mar 2020 05:58:03 GMT
Sorry, please ignore.


On Mon, Mar 30, 2020 at 1:55 PM Herman Tan <herman@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.igs@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 <cgivre@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.p.v@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>
>> >
>> >
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message