topic tDBOutput generates the correct SQL but data is not in DB in Talend Studio

tDBOutput generates the correct SQL but data is not in DB

quad4x — Fri, 15 Nov 2024 22:51:54 GMT

I'm trying to insert data into an MSSQL database using a delimited file to tDBOUtput.

Using a tJava, I'm printing the SQl generated using

System.out.println(((String)globalMap.get("tDBOutput_1_QUERY")));

Generated statement:

INSERT INTO [system] ([inactive],[name],[description],[risktracksystemid],[addeddate],[fusionid]) VALUES ('0','New Test App','testing','','06-02-2022','b001Y00000qOtst')

However, the data isn't getting inserted.

When I run the same SQL in MS SQL Server Management Studio, the insert works.

Re: tDBOutput generates the correct SQL but data is not in DB

quad4x — Thu, 02 Jun 2022 19:37:08 GMT

Found that this works when I add 'tDBCommit' after the output. Not use to needing to commit changes to MSSQL database

Re: tDBOutput generates the correct SQL but data is not in DB

gjeremy1617088143 — Fri, 03 Jun 2022 09:39:18 GMT

yes you have to use a tDBCommit component on subjob ok link and tDBRollBack component on subjob error link, or you can set auto commit in advance option of the tDBConnection component.