Hello
i need to connect Nifi to Oracle DB but i faced a problem in the connection.
i copy Ojdbc.jar to lib directory
i choose QueryDatabaseTable processor ( i am not sure if it's correct )
- Database Connection URL : jdbc:oracle:thin:@//HostName:XXXX/XXXXXXX
- the Database Driver Class Name : oracle.jdbc.driver.OracleDriver
- Database Driver Location : C:\Users\d1156\Desktop\nifi-1.10.0\lib\ojdbc8.jar
after i start the processor this error appears :
unable to execute SQL select query - cannot create JDBC driver of class ' Oracle.jdbc.driver.oracleDriver'
Thank you .