• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Mysql won't save records after job is done.

#1 2011-10-17 10:39:28

tomer
Guest

Mysql won't save records after job is done.

I have the weirdest problem ever.
I have a loading process of some .csv(s) from a directory using tfiledelimted and its (supposedly) being saved into mysql table.
On the same job, after I am done loading all the .csv files I am using tmysqlinput to load the data from the "just" inserted table onto a new .csv file.
Except some encoding, the process works great.
However, for some reason the data on the table (mysql) is gonna after the process is finished - that is the table doesn't consist 0 rows (although the file was outputted from the job had rows (about 5000 rows)).

Any help is very welcome.

#2 2011-10-17 10:43:06

avdbrink
Member
Company: Conspect Consulting & ICT
Registered: 2010-11-08
Posts: 360
Website

Re: Mysql won't save records after job is done.

Hi!

Maybe you forgot to commit the data (tMysqlCommit) ?

Regards,
Arno

Offline

#3 2011-10-17 11:34:10

venkatesh
Member
Registered: 2011-06-23
Posts: 23

Re: Mysql won't save records after job is done.

Are you trying to do batch commit?

Please upload snap shot of your job

Last edited by venkatesh (2011-10-17 11:34:54)

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Mysql won't save records after job is done.

Board footer

Powered by FluxBB