JDBC Invalid SessionHandle with dbSQL Warehouse

[pdiamond]

Connecting Pentaho Ctools dashboards to Databricks using JDBC to a serverless dbSQL Warehouse, it works fine on the initial load, but then if we leave it idle for awhile and come back we get this error:

[Databricks][JDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 400, Error message: INVALID_STATE: Invalid SessionHandle: SessionHandle

It seems like maybe we need to set some sort of timeout configuration similar to what is suggested here except I cannot find any documentation about what that would be for dbSQL. Has anyone encountered this?

[david598scott]

---

@pdiamond wrote:

Connecting Pentaho Ctools dashboards to Databricks using JDBC to a serverless dbSQL Warehouse, it works fine on the initial load, but then if we leave it idle for awhile and come back we get this error:

[Databricks][JDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 400, Error message: INVALID_STATE: Invalid SessionHandle: SessionHandle

It seems like maybe we need to set some sort of timeout configuration similar to what is suggested here except I cannot find any documentation about what that would be for dbSQL. Has anyone encountered this?

---

Hello @pdiamond,
It sounds like you might need to configure a timeout setting for your JDBC connection to dbSQL Warehouse. While specific documentation for dbSQL isn't readily available, you can try adjusting the connection timeout settings in your JDBC URL or your application's connection pool configuration.

Best regards,
David Scott

[pdiamond]

I should have mentioned that we're using AuthMech=3 and in the JDBC docs (Databricks JDBC Driver Installation and Configuration Guide) I don't see any relevant timeout settings that would apply in that scenario. Am I missing something?