While creating a Data Ingestion feed with Oracle datasource, the first time you input the table name you get a "Unable to connect to selected data source." and a log "java.lang.ClassNotFoundException: Unable to load class: oracle.jdbc.driver.OracleDriver", but you can overwrite the table name + table columns and it works.
Nifi doesn't have any issues with the DBCPConnectionPool or GetTableData processor.
More complete log:
ojdbc driver is copied to /opt/nifi/nifi-1.0.0/lib, with correct permissions.
You need to add it to the kylo-services classpath
Please copy the driver to the /opt/kylo/kylo-services/plugin folder and restart kylo-services
I've added the oracle jar at /opt/kylo/kylo-services/plugin.
I've configured the Datasource, and when I tryed to create a Data Ingestion feed, the table finder still fails due to:
java.lang.RuntimeException: Unable to list catalogs
Caused by: java.sql.SQLException: Failed to validate a newly established connection.
Please see the log here
Am I missing something in /opt/kylo/kylo-services/conf/application.properties, like datasource.validationQuery or something?
I have no issues in using the same datasource in Nifi with a GetTableData processor.
Issue solved with the patch. Thanks a lot!