JDBC Invalid SessionHandle with dbSQL Warehouse
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2025 01:05 PM
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?