topic Re: tMysqlInput - MariaDB - Enable Stream Error in Talend Studio

tMysqlInput - MariaDB - Enable Stream Error

_AnonymousUser — Sat, 16 Nov 2024 10:22:35 GMT

Hi - I am using TOS-DI 6.1.1. I'm trying to use a tMysqlInput component with DB Version set to MariaDB. When doing so, if I select "Enable Stream" under Advanced Settings, when I run the job, I get the following error from the component:
java.lang.ClassCastException: org.mariadb.jdbc.MySQLStatement cannot be cast to com.mysql.jdbc.Statement
If i unselect Enable Stream, the error does not occur. Also, if I change the DB Version to anything besides MariaDB, the error does not occur. The database I'm interacting with is a MariaDB (Amazon RDS), so I assume I should use DB Version = MariaDB.
Anyone have any thoughts on this issue? Functionally, things appear to work if I keep the DB Version set to MySQL5, but I'm not sure if not selecting MariaDB will cause me other issues?

Re: tMysqlInput - MariaDB - Enable Stream Error

Anonymous — Thu, 22 Sep 2016 09:00:23 GMT

Hi,
It looks like a bug. Have you tried to use V 6.2.1 to see if this issue repro?
Best regards
Sabrina

Re: tMysqlInput - MariaDB - Enable Stream Error

Anonymous — Tue, 17 Jan 2017 15:28:57 GMT

Hi all,
I've faced with the same issue. And in Talend Open Studio Version 6.3.0 it causes an error too: "Execution failed : Job compile errors. Detail Message: com.mysql cannot be resolved to a type".
Could anyone suggest some solution to avoid using "enable stream" whereas have a stream ?
Thank you beforehand.

Re: tMysqlInput - MariaDB - Enable Stream Error

_AnonymousUser — Tue, 17 Jan 2017 15:30:32 GMT

Only way I've been able to get around it, and still use the stream, is to set the DB Version to mysql5. That still works even if you are connecting to a MariaDB source.