[resolved] Error on insertion in database with multithreading

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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