Support Questions
Find answers, ask questions, and share your expertise

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 

View solution in original post

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 

View solution in original post