- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
can not connect to Oracle Database
- Labels:
-
Apache NiFi
Created on
‎11-27-2019
04:38 AM
- last edited on
‎11-27-2019
05:32 AM
by
cjervis
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .
Created ‎11-28-2019 04:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Created ‎11-28-2019 04:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i fix the problem .
i changed the Ojdbc8.jar to Ojdbc7.jar
thanks
