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!!
1 REPLY
One Star

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

Nevermind, found better solution...use tMySqlRow.