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

Anonymous — Sat, 16 Nov 2024 12:05:18 GMT

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

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

Anonymous — Mon, 11 Mar 2013 19:06:36 GMT

Nevermind, found better solution...use tMySqlRow.

topic How do I set MySQL global or session variables for a connection? in Talend Studio

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

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