Does the tOracleClose component perform a commit?

One Star

Does the tOracleClose component perform a commit?

It seems to me like the tOracleClose components in my jobs are performing commits even if I have "Autocommit" unchecked in the corresponding tOracleConnection component. Is this the case?
Moderator

Re: Does the tOracleClose component perform a commit?

Hi,
tOracleClose closes the transaction committed in the connected DB.
tOracleCommit validates the data processed through the job into the connected DB.
How do you design your work flow? Could you please upload your screenshots into forum.
Here is a related scenarios about DB component design https://help.talend.com/pages/viewpage.action?pageId=13798518#Raa91640 and https://help.talend.com/pages/viewpage.action?pageId=5671200
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Does the tOracleClose component perform a commit?

tOracleClose closes the transaction committed in the connected DB.

This statement is confusing because it contains the word "committed." Is it saying that it commits the transactions for the connected database?
Moderator

Re: Does the tOracleClose component perform a commit?

Hi,
The purpose of tOracleClose is just closing the transaction(connection) after the data is committed. So if close the connection, you cannot commit.
You can see the generated java code of tOracleClose from "Code" tab.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.