MySQL vs MariaDB In tDBConnection Component

Six Stars

MySQL vs MariaDB In tDBConnection Component

I have MySQL setup on my local machine.  When I try to connect to the DB server I see the following behavior and am wondering why (and does it matter)?


tDBConnection configured with "DB Version: Mysql 5"

Exception in component tDBConnection_1 (asdf)
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.


If I change "DB Version: " value to MariaDB it is connected successfully.  


MySQL version 8.0.11






Re: MySQL vs MariaDB In tDBConnection Component


Please have a look at this documentation:TalendHelpCenter: Supported systems, databases and business applications by Talend components

So far, MySQL 8.0 is not list on the supported databases table.

The JDBC driver we used in MySql 5 is not working with MySql 8.


Best regards



Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.