Tuesday, October 4, 2011

Commenting GOTCHA that a Talend Novice should keep in mind

COMMENTING in QUERY components of Talend can be a pain as the error messages that you get due to commenting in SQL style will not be intuitive.

JAVA commenting style -
// For single line commenting
/* .... */ Multi line commenting

SQL commenting style-
-- For single line commenting.
/* .... */ Multi line commenting

The QUERY in a query component like MySqlInput is JAVA string behind the scenes. So commenting using the hiphens(--) in SQL style will result in an error. So it is wise to choose /* */ multi line JAVA/SQL style comments  to be safe than sorry.

Happy Talending!
-Praveena











No comments:

Post a Comment