Does the tOracleClose component perform a commit?

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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