Data Ingestion of Oracle datasource fails at finding table name, but works after overwritting it

Description

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:

Environment

None

Activity

Show:
Claudiu Stanciu
July 3, 2017, 2:23 PM

ojdbc driver is copied to /opt/nifi/nifi-1.0.0/lib, with correct permissions.

Scott Reisdorf
July 3, 2017, 3:50 PM

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

Claudiu Stanciu
July 5, 2017, 1:06 PM
Edited

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
at com.thinkbiganalytics.schema.DBSchemaParser.listCatalogs(DBSchemaParser.java:89)
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.

Scott Reisdorf
July 5, 2017, 1:35 PM

You are hitting this bug (https://kylo-io.atlassian.net/browse/KYLO-738)
Please patch your kylo-services with the jar found in the

Claudiu Stanciu
July 5, 2017, 2:01 PM

Issue solved with the patch. Thanks a lot!

Assignee

Unassigned

Reporter

Claudiu Stanciu

Labels

None

Reviewer

None

Story point estimate

None

Fix versions

Affects versions

Priority

Medium
Configure