MYSQL connector issue

KNIME Analytics Platform
1

Hi All,

Im facing a problem from mysql connector connecting to MariaDB version 11.0.1 with the Database Dialect: MySQL and i tried with the driver name: MySQL 5, MySQL 8 or MySQL v8.0.29 but i have no luck to get it connect and system show the error message below:

ERROR MySQL Connector 3:255 Execute failed: Unknown system variable ‘transaction_isolation’

Is anyone facing the same issue ? or solution so far?

Thanks

2

Hello @poron1st,

and welcome to KNIME Community!

Seems you need to register your own JDBC driver. Take a look at this topic:

Br,
Ivan

2 Likes
3

Ipazin, Thanks for the info. Will test the two version of jdbc .jar file from the MariaDB website.

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.