I use NiFi to get data from SalesForce using DBCPConnectionPool component. For this purpose I use CData JDBC driver that was successfully installed. Moreover, I copied jar file to the /lib folder of NiFi (together with .lic file (license)). I read that it is not a good practice to add the driver but I tried this way too. And I configured the DBCPConnectionPool the following way. Screenshot
But it doesn't work and the error is the same: 'Can't load database driver'
I think that something is wrong with the path to the driver but I tried different ways and the error remains. Also I tried to specify another folder but it didn't work.
Please help me how to specify the path to the file correctly if I am using Widnows.
question from:https://stackoverflow.com/questions/65921657/apache-nifi-dbcpconnectionpool-cannot-load-database-driver-salesforce
