How do I set MySQL global or session variables for a connection?

One Star

How do I set MySQL global or session variables for a connection?

I am trying to set a session variable on mysql database query. My approach has been to use the following flow:
tMySqlConnection -> tMySqlInput -> tJavaRow -> tLogRow
I am calling the following in tMySqlInput:
SET SESSION =n;
SELECT 1 as success from dual;
Talend is blowing up saying there is a syntax error in the "SELECT 1 as success from dual;". However, this statement runs fine when I paste it in mysql workbench.
Any insights or approaches to solving this problem would be greatly appreciated!!
One Star

Re: How do I set MySQL global or session variables for a connection?

Nevermind, found better solution...use tMySqlRow.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads