How to connect Databricks Database with Springboot application using JPA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2024 03:31 AM
facing issue with integrating our Spring boot JPA supported application with Databricks.
Below are the steps and setting we did for the integration.
When we are starting the spring boot application we are getting a warning as :
HikariPool-1 - Driver does not support get/set network timeout for connections. ([Databricks][JDBC](10220) Driver does not support this optional feature.)
and the application gets started.
When interacting with DB for any CRUD operation we are getting exception : Caused by: java. SQL. SQL Feature Not Supported Exception: [Databricks][JDBC](10220) Driver does not support this optional feature.
Driver used: com. databricks .client. jdbc. Driver
Url: jdbc:databricks://************************ t:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/778046939806498/0307-074105-********;AuthMech=3;UID=token;PWD=*****************
Dialect : org. hibernate. dialect. My SQL Dialect
Below are other drivers that we tried as well suggested in databricks -jdbc-driver-install-and-configuration-guide:
com.databricks.client.jdbc.DataSource com.databricks.client.jdbc42.Driver com.databricks.client.jdbc42.DataSource
Also we would like to highlight that we are able to make single connection and able to perform CRUD operation with custom queries but not with Spring Data Jpa.