Skip to main content
Alisalem59
Gold ⭐️
November 27, 2019
Solved

can not connect to Oracle Database

 

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 .

 

Alisalem59
Gold ⭐️
November 28, 2019

i fix the problem .

i changed the Ojdbc8.jar to Ojdbc7.jar

thanks 

1 reply

Alisalem59
Alisalem59AuthorAnswer
Gold ⭐️
November 28, 2019

i fix the problem .

i changed the Ojdbc8.jar to Ojdbc7.jar

thanks 

Translate