cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Community Platform Discussions
Connect with fellow community members to discuss general topics related to the Databricks platform, industry trends, and best practices. Share experiences, ask questions, and foster collaboration within the community.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

JDBC Invalid SessionHandle with dbSQL Warehouse

pdiamond
New Contributor III

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?

2 REPLIES 2

david598scott
New Contributor II

@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
New Contributor III

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?

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group