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

 

 

 

 

Moderator

Re: MySQL vs MariaDB In tDBConnection Component

Hello,

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

Sabrina

 

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