Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
0683p000009MEgg.png
Labels (4)
2 Replies
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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