Hi Team, I failed to create cratedb connection in nifi as the configuration connecting postgres, and I also checked the document
connecting-to-cratedb-from-apache-nifi, but I don’t find useful information for the issue I encounter. Thanks in advanced.
Hi, could you try adding
?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
to the connection string as in the tutorial?
After adding it, the error are as follows.
t-edi-nifi-003:8443 - Failed to establish Database Connection: java.sql.SQLException: Cannot create PoolableConnectionFactory (The server does not support SSL.)
I see, that CrateDB server is not configured for SSL then, that is ok, just revert to the old connection string you were using.
Is /data/nifi/jdbc_drivers/postgresql.jar the latest jar from Download | pgJDBC ?
Yes, the postgresql.jar just link to postgresql-42.7.1.jar.
[root@t-edi-nifi-003 jdbc_drivers]# ll postgresql.jar
lrwxrwxrwx. 1 root root 21 Dec 20 14:30 postgresql.jar -> postgresql-42.7.1.jar
Hi @hernanc, I have resolved the issue by specifying a validation query in NiFi. Hoping to help people encountering the same issue.
Successfully Verifying DB connection.
4 Likes