I am trying to access IOracle from Nifi 1.6.0 but i am getting a driver not found exception.
1.) copied the ojdbc8.jar (also tried ojdbc6.jar and ojdbc7.jar) into the lib directory
2.) restarted nifi
3.) setup an Controller Service
- see attached screenshot
- i tried also without putting the database driver location to file:///Daten/Programme/NIFI/nifi-1.6.0/lib/ojdbc8.jar
-- with the database driver location set the controller service will not successfully enable. I get a Cant load Database driver exception and status is stuck at Enabling
-- with the database driver location not set, it will enable. but as soon as a processor (QueryDatabaseTable) tries to access the oracle connection I get a Cant load Database driver exception and status is stuck at Enabling
Trying for hours now, would really appreciate some help.
Your screenshot looks okay, your ojdbc* should match the version of the source database and you should copy it to the location of the nifi.nar.library.directory as shown below and if you have a multinode nifi cluster ensure all nodes have that ojdbc* file in that same location
Then after that, you should restart your Nifi.