topic Does the tOracleClose component perform a commit? in Data Quality

Does the tOracleClose component perform a commit?

Anonymous — Wed, 05 Jun 2013 16:54:28 GMT

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?

Re: Does the tOracleClose component perform a commit?

Anonymous — Thu, 06 Jun 2013 03:27:54 GMT

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

Re: Does the tOracleClose component perform a commit?

Anonymous — Thu, 06 Jun 2013 16:50:46 GMT

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?

Re: Does the tOracleClose component perform a commit?

Anonymous — Fri, 07 Jun 2013 10:22:10 GMT

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