topic Re: [resolved] Error on insertion in database with multithreading in Talend Studio

[resolved] Error on insertion in database with multithreading

Anonymous — Thu, 12 Jun 2014 14:21:14 GMT

Hi,
I developed a job that inserts data from xml files into a database using multithreading. There are 12 iterations on 12 XML files, and so 12 executions on the component connection to the database(I'm using tAS400Output).
The console shows the error at the end of the execution that are probalblement in conjunction with the number of simultaneous connections. what to do in this case
A screenshot below explain the job architecture
Error in the console :

 connecting to socket on port 3495
 connected
Communication link failure. (Software caused connection abort: recv failed) SQLSTATE= CODE
Communication link failure. (Software caused connection abort: recv failed) SQLSTATE= CODE
Communication link failure. (Software caused connection abort: recv failed) SQLSTATE= CODE
Communication link failure. (Software caused connection abort: recv failed) SQLSTATE= CODECommunication link failure. (Software caused connection abor

To see the whole post, download it here

Re: [resolved] Error on insertion in database with multithreading

Anonymous — Fri, 13 Jun 2014 04:41:29 GMT

Hi,
Have you tried to use TalendHelpCenter:tAccessRollback in your job design to avoid involuntary commitment of part of a transaction?
Best regards
Sabrina

Re: [resolved] Error on insertion in database with multithreading

Anonymous — Fri, 13 Jun 2014 14:12:26 GMT

Hi,
I modified the job design but the execution still blocked in the last component.
A screenshot below explain the job design and the execution problem

Re: [resolved] Error on insertion in database with multithreading

Anonymous — Fri, 13 Jun 2014 21:28:14 GMT

I think that it is because of the ability of the DBMS to process request simultaneously

Re: [resolved] Error on insertion in database with multithreading

Anonymous — Mon, 16 Jun 2014 10:38:50 GMT

Hi,
Have you tried other DB(oracle, my sql...) to see if this issue repro?
Best regards
Sabrina

Re: [resolved] Error on insertion in database with multithreading

Anonymous — Tue, 17 Jun 2014 02:16:26 GMT

Hi,
My colleague told me that he had the some problem with this DB installation. I am trying to solve this problem with the DB administrator.
Thanks

Re: [resolved] Error on insertion in database with multithreading

Anonymous — Tue, 17 Jun 2014 07:44:56 GMT

Hi,
It's welcome to share your solution on forum.
Best regards
Sabrina