Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to convert json into sql format through Nifi ?

avatar
Rising Star

I'm using HDP 2.4. I try to convert json into sql format for this I use "ConvertJSONToSQL processor" but I got driver issue!, can anyone help me to resolve this issue

ConvertJSONToSQL processor properties

16037-screenshot-from-2017-06-06-152603.png

DBCPConnectionPool properties

16038-screenshot-from-2017-06-06-152652.png

Error

16036-screenshot-from-2017-06-06-151510.png

5 REPLIES 5

avatar
Master Guru

NiFi doesn't come with a PostgreSQL driver, you will need to get one and point to its location in the "Database Driver Jar Url" property in the DBCPConnectionPool configuration dialog above. If you already have one and have placed it in NiFi's lib/ directory, this can cause problems and is not recommended. Best practice is to put JDBC drivers in a separate location and refer to that location in the "Database Driver Jar Url" property.

avatar
Rising Star

Yes, I create a separate directory in local and import PostgreSQL driver jar into it. After that I point to its location into "Database Driver Jar URL" property, but still I got issue that I mention below.

16097-screenshot-from-2017-06-07-145015.png

16098-screenshot-from-2017-06-07-145109.png

avatar
Master Guru

That error is a bit different, can you share the associated stack trace from the log(s) (logs/nifi-app.log, e.g.)?

avatar
Rising Star

Thanks Matt Burgess

avatar
Master Guru

Try three slashes in the Database Driver Jar Url property: file:///post/postgresql-42.1.1.jar