Member since
08-13-2019
11
Posts
1
Kudos Received
0
Solutions
08-29-2019
06:04 AM
1 Kudo
Hello . I am trying to read the mysql bin log data from mysql database and i am getting the error as "Could not connect to Distributed Map Cache server to get table information" when i added the Distributed Map Cache Client value in CaptureChangeMysql Aapache nifi processor . screenshots are attached for the reference OS :Ubuntu (AWS AC2) NIFI : 1.8.0 Mysql : 5.7.* i
... View more
Labels:
- Labels:
-
Apache NiFi
08-22-2019
03:01 AM
Hello @jsensharma Thanks for the Response I have tried with the Option2(added the driver name as"com.mysql.cj.jdbc.Driver") there are two scenarios : 1. Mysql driver location with "file://" Mysql Driver Location :"file:///Users/kiran/Downloads/mysql/mysql-connector-java-8.0.17.jar" Mysql Class Name: com.mysql.cj.jdbc.Driver i am getting the error "Failed to register JDBC driver. Ensure MySQL Driver Location(s) and MySQL Driver Class Name are configured correctly. org.apache.nifi.reporting.InitializationException: Can't load Database Driver" 2. Getting the error as "capture-changes-mysql-driver-location is validated against '/Users/kiran/Downloads/mysql/mysql-connector-java-8.0.17.jar' is invalid because not a valid url or file" When I mentioned the Mysql Driver Location as "/Users/kiran/Downloads/mysql/mysql-connector-java-8.0.17.jar"" I have attached the screenshot for the same .
... View more
08-22-2019
01:05 AM
Hello @jsensharma Thanks for the Response . I have tried both the steps which you have mentioned and looks both are working as expected . screenshots are attached for the reference .
... View more
08-21-2019
04:53 AM
Hello @alim Yes, the driver path is correct and attached the screenshot from the finder .
... View more
08-14-2019
06:59 AM
Hello @Andrew Lim Thanks for the Response . The Driver path is "/Users/kiran/Downloads/mysql/mysql-connector-java-8.0.17.jar" i have tried this as well but getting the error as this path is not a valid File or Url . attached the screenshot for your reference . I went through this documents as well (https://community.hortonworks.com/content/kbentry/113941/change-data-capture-cdc-with-apache-nifi-version-1-1.html)
... View more
08-13-2019
12:32 PM
I am using the CaptureChangesMysql processor to read the events data from mysql but 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
... View more
Labels:
- Labels:
-
Apache NiFi
08-13-2019
12:25 PM
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
... View more