topic Re: JDBC Invalid SessionHandle with dbSQL Warehouse in Get Started Discussions

JDBC Invalid SessionHandle with dbSQL Warehouse

pdiamond — Wed, 22 Jan 2025 21:05:51 GMT

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?

Re: JDBC Invalid SessionHandle with dbSQL Warehouse

david598scott — Fri, 24 Jan 2025 06:08:27 GMT

@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

Re: JDBC Invalid SessionHandle with dbSQL Warehouse

pdiamond — Thu, 30 Jan 2025 13:26:58 GMT

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?