Cannot connect to Mysql

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

bhavinultimate
Posts: 11
Joined: Mon Dec 23, 2013 6:28 am

Cannot connect to Mysql

Postby bhavinultimate » Wed Dec 26, 2018 8:46 pm

Hello,
i am using clover 4.0.7 version

I am not able to connect to Mysql Database
While creating connection

Below are the value i am using
Username- root
pwd--****
URl-jdbc:mysql://localhost:3306/test


Error I am getting is
Can't connect to DB: Could not create connection to database server.
Unexpected null value.


With same credentails i am able to work in Mysql database workbench version 8.0.

Screenshot attached
Capture.PNG
Capture.PNG (30.17 KiB) Viewed 1091 times

vazquezrosariop
Posts: 151
Joined: Mon Feb 29, 2016 5:33 pm

Re: Cannot connect to Mysql

Postby vazquezrosariop » Thu Jan 03, 2019 3:47 pm

Hi,

Unfortunately, the MySQL driver pre-installed in version 4.0 of CloverETL is not compatible with MySQL 8.0. If you are not able to upgrade to our newest version of Designer, you will have to download the newest MySQL driver and add it manually in the CloverETL Designer. If you look at the screenshot you provided you will notice a plus sign where all available drivers are available, that should allow you to add custom drivers to the already existing ones. Please let me know if you run into any issues.

Thanks,
---
Pedro X. Vazquez Rosario
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com


cron