One Star

tJDBCRow with SQL Update Statement

Talend,
I'm trying to use tJDBCRow to run a SQL Update statement but whatever I do it will not run the SQL statement. I have simplified my job by having only three components (tJDBCConnection, tJava, and tJDBCRow). I connect to the DB with the first component, the tJava is used to output the context variables, and the tJDBCRow has the Update SQL along with the schema of the table it is updating. The SQL is not being executed and when I print out the SQL it is NULL.
Now this is just a simplified version as what I'm really doing in the job is reading a list of TAN (unique identifiers) and trying to run the update statement for each TAN or one time by using TAN IN instead of TAN = .
FYI...we actually use custom tJDBC components but they work exactly the same as the original.
Please help!
Thanks,
Brian
2 REPLIES
One Star

Re: tJDBCRow with SQL Update Statement

Ok, so now I am able to get the SQL to print out and it prints out the correct UPDATE statement for each iteration of TAN that I need, but it is NOT being executed.
One Star

Re: tJDBCRow with SQL Update Statement

I have solved the issue. I was not using tjdbcCommit.