Support Questions

Find answers, ask questions, and share your expertise

Nifi Oracle JDBC Connection Issue

avatar
New Contributor

I am trying to create a DB connection to oracle.

When I create a DBConnection and try to connect to oracle with a executeSQL processor I get a class not found exception

org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class ' oracle.jdbc.driver.OracleDriver'

What am I doing wrong?

1 ACCEPTED SOLUTION

avatar
Rising Star

Did you copy the ojdbc jar to the nifi lib directory and restart nifi?

View solution in original post

1 REPLY 1

avatar
Rising Star

Did you copy the ojdbc jar to the nifi lib directory and restart nifi?