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!!