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.
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.
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?
@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.
