Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

can not connect to Oracle Database

Solved Go to solution

can not connect to Oracle Database

New Contributor

 

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 .

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: can not connect to Oracle Database

New Contributor

i fix the problem .

i changed the Ojdbc8.jar to Ojdbc7.jar

thanks 

1 REPLY 1

Re: can not connect to Oracle Database

New Contributor

i fix the problem .

i changed the Ojdbc8.jar to Ojdbc7.jar

thanks 

Don't have an account?
Coming from Hortonworks? Activate your account here