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. Thanks, - 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 <[email protected]> wrote: 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 <[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> > >
