question Re: DBCP connection pool Issue(Can't load Database Driver) in HDP 2.4 NiFi in Archives of Support Questions (Read Only)

DBCP connection pool Issue(Can't load Database Driver) in HDP 2.4 NiFi

narasimha_varma — Sun, 18 Aug 2019 04:18:05 GMT

I try to access a postgresql through Nifi for that first I try to get json from RestApi through GetHTTP processor, then I try to insert json into postgres through convertJSONToSQL processor in nifi. While initializing DBCP connection I got "DBCPConnectionPool[id=27273afd-ed82-48f4-aaae-d9f265d72769] Failed to invoke @OnEnabled method due to org.apache.nifi.reporting.InitializationException: Can't load Database Driver". I attach my DBCPconnectionpool configure controller service below.

Re: DBCP connection pool Issue(Can't load Database Driver) in HDP 2.4 NiFi

MattWho — Wed, 14 Jun 2017 19:39:24 GMT

@Narasimma varman

Try configuring the "Database Driver Jar Url" property with the absolute path to you "postgresql-42.1.1.jre7.jar" file.

for example:

c:/post/postgresql-42.1.1.jre7.jar

/post/postgresql-42.1.1.jre7.jar

Also check out the nifi-app.log for a full stack trace that may follow the above ERROR that may give more detail on why it can't load the file.

Thanks,

Matt

Re: DBCP connection pool Issue(Can't load Database Driver) in HDP 2.4 NiFi

mburgess — Wed, 14 Jun 2017 20:09:16 GMT

Or try adding an extra slash before your path (see here for explanation):

file:///post/postgresql-42.1.1.jre7.jar

Re: DBCP connection pool Issue(Can't load Database Driver) in HDP 2.4 NiFi

narasimha_varma — Thu, 15 Jun 2017 19:07:25 GMT

Thanks Matt Burgess

Re: DBCP connection pool Issue(Can't load Database Driver) in HDP 2.4 NiFi

narasimha_varma — Thu, 15 Jun 2017 19:08:02 GMT

Thanks Matt Clarke

Re: DBCP connection pool Issue(Can't load Database Driver) in HDP 2.4 NiFi

kmehta — Sun, 18 Aug 2019 04:17:57 GMT

Hi @Matt Burgess,

I am facing the same problem and the solution you suggested is not working for me. Can u provide with some alternative solution. Configuration and error is given below. Nor the solution by Matt Clarke is working for us.

Re: DBCP connection pool Issue(Can't load Database Driver) in HDP 2.4 NiFi

kiranps11 — Sun, 18 Aug 2019 04:17:44 GMT

Hello @Matt Burgess .

I am using the CaptureChangesMysql processor to read the events data from mysql but it it failing with the connection error as "org.apache.nifi.reporting.initializationexception can't load database driver"

screenshots are attached for the reference .

Mysql Driver path: file:////Users/kiran/Downloads/mysql/mysql-connector-java-8.0.17.jar

Environment :

Aapache nifi :1.7.0

Mysql 8.0.17

OS : MacOS 10.14.4