1. Did you configure the Oracle JDBC Driver in DBCP connection pool /Database
driver name?
2. Does JDBC driver UrL have access to NIFI runAs user ?
Thanks,
Milan Das
> On Feb 1, 2019, at 2:18 AM, vishwa wrote:
>
> Hi,
>
> I'm trying to make a Oracle connection pool via controller service - DBCP
> Connection Pool module.
>
> Database Connection URL -- jdbc:oracle:thin:@TTTEST:1521:SID
> Database Driver Class Name -- oracle.jdbc.driver.OracleDriver
> Database User- Username
> Database User- Password
>
> I am not able to read the data getting below error.
>
> ".QueryDatabaseTable
> QueryDatabaseTable[id=a3a9501e-0168-1000-a5fc-4a85d8aa8cef] Unable to
> execute SQL select query SELECT * FROM emp due to
> org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException:
> Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver':
> org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException:
> Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
> org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException:
> Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'"
>
> Can someone help with this!
>
>
>
> --
> Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/