Hello everyone,
I would like to have your input/advise/guidance on below described problem.
Problem description:
I have a Talend job with a tDBOutput connected to a SQL Server Database. Actions on this component are truncate/insert. This is causing open sessions to be left on the SQL SERVER database blocking any other jobs that are launched in the same DB. There are no links in between the jobs.
There is no shared connection used in my job. The tDBOutput connects directly to the database via context variables.
As soon as i put the tDBOutput in default/insert with a delete at the beginning, the problem of open sessions disappear.
I would like to know is someone ever came across this problem.
If yes, what are the solutions that have been tested by keeping the truncate option?
