drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Rogers <par0...@yahoo.com.INVALID>
Subject Re: JDBC datasource on Websphere server
Date Thu, 26 Mar 2020 05:22:01 GMT
Hi Prabhakar,

Drill is supported on Windows only in embedded mode; we have no scripts to run a server. Were
you able to create your own solution?

The exception appears to indicate that the Drill JDBC connection is being used inside a transaction,
perhaps with other data sources, so a two-phase commit is needed. However, Drill does not
support transactions as transactions don't make sense for data sources such as HDFS or S3.

Is there a way to configure WAS to use Drill just for read-only access without transactions?
See this link: [1]. To quote:

Non-transactional data source
Specifies that the application server does not enlist the connections from this data source
in global or local transactions. Applications must explicitly call setAutoCommit(false) on
the connection if they want to start a local transaction on the connection, and they must
commit or roll back the transaction that they started.

Can you run a test? Will SQLLine connect to your Drill server? If so, then you know that you
have the host name correct, that the ports are open, and that Drill runs well enough on Windows
for your needs.

By the way, the Apache mail agent does not support attachments. Can you post the log somewhere
else? Or, just past into an e-mail the lines around the failure.

- Paul

[1] https://www.ibm.com/support/knowledgecenter/en/SSAW57_8.5.5/com.ibm.websphere.nd.multiplatform.doc/ae/udat_jdbcdatasorprops.html


    On Wednesday, March 25, 2020, 8:53:31 PM PDT, Prabhakar Bhosaale <bhosale.p.v@gmail.com>
 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


On Tue, Mar 24, 2020 at 6:19 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  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>
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message