MySQL vs MariaDB In tDBConnection Component

jdope — Tue, 12 Jun 2018 19:13:18 GMT

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

Anonymous — Fri, 15 Jun 2018 10:34:35 GMT

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

topic Re: MySQL vs MariaDB In tDBConnection Component in Talend Studio

MySQL vs MariaDB In tDBConnection Component

Re: MySQL vs MariaDB In tDBConnection Component