jdbc - Problem when connect from Nifi to Databricks - Stack Overflow

admin管理员组

文章数量:1410725

I am using NiFi (running on EKS) to connect to Databricks (using EC2 as compute) via JDBC. Here is the JDBC URL I am using: jdbc:databricks://server_hostname:443/default;transportMode=http;ssl=1;httpPath=my_httppath;AuthMech=3;UID=token;PWD=my_token. However, I encountered the following error:

No FlowFile to route to failure: .apache.nifi.processor.exception.ProcessException: java.sql.SQLException: Cannot create PoolableConnectionFactory ([Databricks]JDBCDriver Communication link failure. Failed to connect to server. Reason: java.SocketException: Connection reset.)
- Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory ([Databricks]JDBCDriver Communication link failure. Failed to connect to server. Reason: java.SocketException: Connection reset.)
- Caused by: java.sql.SQLException: [Databricks]JDBCDriver Communication link failure. Failed to connect to server. Reason: java.SocketException: Connection reset.
- Caused by: com.databricks.client.support.exceptions.ErrorException: [Databricks]JDBCDriver Communication link failure. Failed to connect to server. Reason: java.SocketException: Connection reset.
- Caused by: com.databricks.client.jdbc42.internal.apache.thrift.transport.TTransportException: java.SocketException: Connection reset
- Caused by: java.SocketException: Connection reset

Although the telnet from NiFi to Databricks was successful and the connection on Databricks for the NiFi IP range has been opened. And I can still successfully use the above JDBC information to connect from DBeaver to Databricks. Can anyone please explain why this issue is occurring and how I can resolve it?

本文标签： jdbcProblem when connect from Nifi to DatabricksStack Overflow