Hello,
I have a workbench which includes Databrick JDBC Connection. It was working fine with FME 2024.0.3.0. However, after upgrading to FME 2024.1.2.1, it starts throwing error “java.sql.SQLException: iDatabricks]iDatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager.”
Feels like something is missing with the upgrade. Has anybody seen the same problem? Could Safe support team please check? thank you.
Full error attached below.
java.sql.SQLException: pDatabricks]bDatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager.
at com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source)
at com.databricks.client.hivecommon.api.HS2Client.<init>(Unknown Source)
at com.databricks.client.spark.jdbc.DowloadableFetchClient.<init>(Unknown Source)
at com.databricks.client.spark.jdbc.DownloadableFetchClientFactory.createClient(Unknown Source)
at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.connectToServer(Unknown Source)
at com.databricks.client.spark.core.SparkJDBCConnection.connectToServer(Unknown Source)
at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.establishConnection(Unknown Source)
at com.databricks.client.spark.core.SparkJDBCConnection.establishConnection(Unknown Source)
at com.databricks.client.jdbc.core.LoginTimeoutConnection.connect(Unknown Source)
at com.databricks.client.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
at com.databricks.client.jdbc.common.AbstractDriver.connect(Unknown Source)
at COM.safe.fme.jdbc.JdbcCommon.openConnection(JdbcCommon.java:590)
at COM.safe.fme.jdbc.JdbcReader.openHelper(JdbcReader.java:198)
Caused by: com.databricks.client.support.exceptions.GeneralException: pDatabricks]bDatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager.
... 13 more
Caused by: java.lang.IllegalStateException: Connection not obtained from this manager
at com.databricks.client.jdbc42.internal.apache.http.util.Asserts.check(Asserts.java:34)
at com.databricks.client.jdbc42.internal.apache.http.impl.conn.BasicHttpClientConnectionManager.releaseConnection(BasicHttpClientConnectionManager.java:260)
at com.databricks.client.jdbc42.internal.apache.http.impl.execchain.ConnectionHolder.abortConnection(ConnectionHolder.java:135)
at com.databricks.client.jdbc42.internal.apache.http.impl.execchain.ConnectionHolder.cancel(ConnectionHolder.java:146)
at com.databricks.client.jdbc42.internal.apache.http.client.methods.AbstractExecutionAwareRequest.reset(AbstractExecutionAwareRequest.java:144)
at com.databricks.client.jdbc42.internal.apache.http.client.methods.HttpRequestBase.releaseConnection(HttpRequestBase.java:119)
at com.databricks.client.hivecommon.api.TETHttpClient.flushUsingHttpClient(Unknown Source)
at com.databricks.client.hivecommon.api.TETHttpClient.flush(Unknown Source)
at com.databricks.client.jdbc42.internal.apache.thrift.TServiceClient.sendBase(TServiceClient.java:73)
at com.databricks.client.jdbc42.internal.apache.thrift.TServiceClient.sendBase(TServiceClient.java:62)
at com.databricks.client.jdbc42.internal.apache.hive.service.rpc.thrift.TCLIService$Client.send_OpenSession(TCLIService.java:147)
at com.databricks.client.hivecommon.api.HS2ClientWrapper.send_OpenSession(Unknown Source)
at com.databricks.client.jdbc42.internal.apache.hive.service.rpc.thrift.TCLIService$Client.OpenSession(TCLIService.java:139)
at com.databricks.client.hivecommon.api.HS2ClientWrapper.callOpenSession(Unknown Source)
at com.databricks.client.hivecommon.api.HS2ClientWrapper.access$1700(Unknown Source)
at com.databricks.client.hivecommon.api.HS2ClientWrapper$18.clientCall(Unknown Source)
at com.databricks.client.hivecommon.api.HS2ClientWrapper$18.clientCall(Unknown Source)
at com.databricks.client.hivecommon.api.HS2ClientWrapper.executeWithRetry(Unknown Source)
at com.databricks.client.hivecommon.api.HS2ClientWrapper.OpenSession(Unknown Source)
at com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source)
at com.databricks.client.hivecommon.api.HS2Client.<init>(Unknown Source)
at com.databricks.client.spark.jdbc.DowloadableFetchClient.<init>(Unknown Source)
at com.databricks.client.spark.jdbc.DownloadableFetchClientFactory.createClient(Unknown Source)
at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.connectToServer(Unknown Source)
at com.databricks.client.spark.core.SparkJDBCConnection.connectToServer(Unknown Source)
at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.establishConnection(Unknown Source)
at com.databricks.client.spark.core.SparkJDBCConnection.establishConnection(Unknown Source)
at com.databricks.client.jdbc.core.LoginTimeoutConnection.connect(Unknown Source)
at com.databricks.client.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
at com.databricks.client.jdbc.common.AbstractDriver.connect(Unknown Source)
at COM.safe.fme.jdbc.JdbcCommon.openConnection(JdbcCommon.java:590)
at COM.safe.fme.jdbc.JdbcReader.openHelper(JdbcReader.java:198)
at COM.safe.fme.jdbc.JdbcReader.open(JdbcReader.java:167)