SAP SDI - CamelJdbcAdapter - Cannot load JDBC driver class 'com.databricks.client.jdbc.Driver'

chathia2 — Tue, 02 Dec 2025 20:09:42 GMT

Hi Experts,

We are setting up the Databricks connectivity in SAP HANA - Smart Data Integration (SDI). As per SAP Help - Set up the Camel JDBC Adapter | SAP Help Portal, the CamelJdbcAdapter is setup.

The adapter is successfully registered and the remote source is created using both the UI and Code, and it gets created successfully.

CREATE REMOTE SOURCE "RS_DEV_DATABRICKS" ADAPTER "CamelJdbcAdapter" AT LOCATION AGENT "dpagent_MyAgent" CONFIGURATION '<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ConnectionProperties name="configuration"> <PropertyEntry name="dbtype" displayName="Database Type" isRequired="true">Other</PropertyEntry> <PropertyEntry name="driverClass" displayName="JDBC Driver Class" isRequired="false">com.databricks.client.jdbc.Driver</PropertyEntry> <PropertyEntry name="url" displayName="JDBC URL" isRequired="false">jdbc:databricks://adb-xxxxxxxxxx.3.azuredatabricks.net:443/default;transportMode=http;ssl=1;httpPath=/sql/1.0/warehouses/xxxxxxxxxxx;AuthMech=3;ConnCatalog=test_catalog1;ConnSchema=test_schema1;UID=token;IgnoreTransactions=1;</PropertyEntry> </ConnectionProperties> ' WITH CREDENTIAL TYPE 'PASSWORD' USING ' <CredentialEntry name="db_credential"> <user>token</user> <password>yyyyyyyyyyyyyyyyyy</password> </CredentialEntry>';

However, while expanding the Remote Source (or refresh) fails with the below message.

The DPA Logs are enabled, and as per the trace files the below error message is found:

2025-12-02 09:31:53,072 [ERROR] [7770fd98-b350-4636-afbb-1c919296bb0577185] JdbcMetadataBrowser | ExceptionUtil.newAdapterException [] - Failed to query schemas. org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.databricks.client.jdbc.Driver' at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429) at com.sap.hana.dp.camel.CamelDataSource.createConnectionFactory(CamelDataSource.java:65) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at com.sap.hana.dp.camel.JdbcMetadataBrowser.browseSchemas(JdbcMetadataBrowser.java:71) at com.sap.hana.dp.camel.JdbcMetadataBrowser.browseMetadata(JdbcMetadataBrowser.java:59) at com.sap.hana.dp.camel.MetadataProducer.process(MetadataProducer.java:54) at org.apache.camel.support.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:66) at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:172) at org.apache.camel.processor.errorhandler.RedeliveryErrorHandler$SimpleTask.run(RedeliveryErrorHandler.java:477) at org.apache.camel.impl.engine.DefaultReactiveExecutor$Worker.schedule(DefaultReactiveExecutor.java:193) at org.apache.camel.impl.engine.DefaultReactiveExecutor.scheduleMain(DefaultReactiveExecutor.java:64) at org.apache.camel.processor.Pipeline.process(Pipeline.java:185) at org.apache.camel.impl.engine.CamelInternalProcessor.process(CamelInternalProcessor.java:398)

The Databricks JDBC files are placed in both the locations as below, since few SAP notes suggested.

C:\usr\sap\dataprovagent\lib\jdbc\
<DPAgent_root>/camel/lib

Our DPA Agent version details below:

#Data Provisioning component versions dpagent.version=2.7.1.1 lcmsdk.version=2.8.6 repagent.syb.version=15.7.1SP210 repagent.sybfilter.version=15.7.1SP214 ms.vcredist.2015.version=14.36.32532.0 ocs.version=16.0.03.10 dataservices.engine.version=14.3.2.419 dpagent.build.version=2.7.1.1 build.time=2023-07-13T14:59:20-0700

Any pointers or suggestions to diagnose this error would be really helpful. Thank you!

Kind regards

Chathia

Re: SAP SDI - CamelJdbcAdapter - Cannot load JDBC driver...

xiaoming_wu — Thu, 26 Feb 2026 06:22:05 GMT

Check SAP note 3423054 - [CamelJdbcAdapter] Cannot load JDBC driver class 'org.apache.hive.jdbc.HiveDriver' Better upgrade DP agent to latest 2.8.2.1 verison

Question Re: SAP SDI - CamelJdbcAdapter - Cannot load JDBC driver... in Technology Q&A

SAP SDI - CamelJdbcAdapter - Cannot load JDBC driver class 'com.databricks.client.jdbc.Driver'

Re: SAP SDI - CamelJdbcAdapter - Cannot load JDBC driver...