can not connect to Oracle Database

Alisalem59 — Wed, 27 Nov 2019 13:32:22 GMT

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 .

Re: can not connect to Oracle Database

Alisalem59 — Thu, 28 Nov 2019 12:29:17 GMT

i fix the problem .

i changed the Ojdbc8.jar to Ojdbc7.jar

thanks