How to convert json into sql format through Nifi ?

[#1]

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

DBCPConnectionPool properties

Error

[#2]

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.

[#3]

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.

[#4]

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

[#5]

Thanks Matt Burgess

[#6]

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