topic Re: tDBOutput1(Oracle) doesn't appear to commit in Talend Studio

tDBOutput1(Oracle) doesn't appear to commit

Anonymous — Sat, 16 Nov 2024 02:44:41 GMT

Hello everyone,

I'm new to Talend and looking for some help. I'm trying to commit changes from a CSV file to an Oracle table. Everything appears to run fine, and the first time it ran successfully I was able to see changes in the table albeit only partly. However, since the first time the rejects CSV file is getting created, but there are no changes in the table. After some research I think it's an issue with the commit. I'm not sure where to go from here.

Thanks!

Re: tDBOutput1(Oracle) doesn't appear to commit

Anonymous — Thu, 09 Apr 2020 02:07:56 GMT

Hi
What is the action on data selected on tOracleOutput? You run the job several time to read the same input data?

Regards
Shong

Re: tDBOutput1(Oracle) doesn't appear to commit

Anonymous — Thu, 09 Apr 2020 02:19:24 GMT

Hi Shong,

Yes. It is supposed to be a one time transaction for school purposes. The CSV data from columns are to be loaded to an oracle database table. I was able to remove the rows which were inserted to the table on the first try, but now when I run the job it just stays on Connected status.

Thanks again

Re: tDBOutput1(Oracle) doesn't appear to commit

Anonymous — Thu, 09 Apr 2020 02:37:51 GMT

It seems the DB connection hangs all the time and the job does not exit. How many columns on the schema? Which option selected in Action on data list on tOracleOutput?

Re: tDBOutput1(Oracle) doesn't appear to commit

Anonymous — Thu, 09 Apr 2020 03:04:54 GMT

9 columns in schema

Action on Table: Default

Action on Data: Insert

Re: tDBOutput1(Oracle) doesn't appear to commit

Anonymous — Thu, 09 Apr 2020 14:49:48 GMT

@shong The issue was with the commit. When I ran commit command in Oracle SQL Developer, and then ran the job in Talend, it started working fine every time. Is there a way to force commit within Talend? Thank your for the guidance.