Reg: Apache Arrow flight Sql JDBC

1

Hi @balaji.ramaswamy , I am using java 1.8v, Dremio 23V with SSL. I am trying to establish connection with Dremio using Apache Arrow Flight JDBC Driver 10.0, but I am getting the below error. Can you please check this and correct me what might be missing from my side. Thank You.

cfjd.org.apache.arrow.flight.FlightRuntimeException: INTERNAL: There was an error servicing your request.

2

@VinodMerugu What is your JDBC client?

3

Apache Arrow Flight JDBC Driver 10.0 @balaji.ramaswamy

4

@VinodMerugu My question was more towards, is it Tableau or Dbeaver or any customer Java client application etc?

5

sorry @balaji.ramaswamy, I am checking from a java client application.
For your reference, the getting error is as below…

I am using the below snippet of code to get views from dremio.
jdbcTemplate.execute(“select * from INFORMATION_SCHEMA.VIEWS;”);

cfjd.org.apache.arrow.flight.FlightRuntimeException: INTERNAL: There was an error servicing your request.
at com.ovaledge.csp.dto.db.DremioDto.validateConnection(DremioDto.java:145)
at com.ovaledge.oasis.services.CrawlerServiceImpl.buildMap(CrawlerServiceImpl.java:388)
at com.ovaledge.oasis.services.CrawlerServiceImpl.validateConnectionV2(CrawlerServiceImpl.java:348)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.$Proxy215.validateConnectionV2(Unknown Source)
at com.ovaledge.oasis.controllers.CrawlerController.validateConnection(CrawlerController.java:149)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)

6

It seems to be an issue with the JDBC driver when using the default CA cert trust store without a password. I was running into the same error (DBeaver CE, Linux), and was able to solve it by either appending /?disableCertificateVerification=true (which isn’t great security practice) or adding /?trustStorePassword=changeit

1 Like