hi pedro!

am so thanksfull, but that you say don´t working, i tried with the additional parameters and not works! and the connection to the DB it´s must be shared, and about the time execution i've modiffied the waiting time so the execution time and not works!, i have saw a possibles solutions and all says i have to create a new statistics table from talend "talendStats_DB" that is correct??

if yes how can modify that table or component??
it may be,  is an server error?? MySql
or a logical error??

i have talend version TDQ 4.1.3 , mysql version 5,  and honestly i have made another job like this and same error, the time execution each job between 20 and 40 minutes, but i have made another job that don´t generate that error! three diferent jobs execute datamigration from Informix  to Oracle and mysql catch the exectution statistics.

i have attached another images.

this all the information of error:

Starting job JM_ADDR_STG at 11:48 03/01/2012.

[statistics] connecting to socket on port 3879
[statistics] connected
OK
Communications link failure

The last packet successfully received from the server was 1.157.383 milliseconds ago.
The last packet sent successfully to the server was 22.614 milliseconds ago.Exception in component talendStats_DB
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
    at com.mysql.jdbc.Util.getInstance(Util.java:384)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
    at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:404)
    at com.mysql.jdbc.PreparedStatement.setTimestampInternal(PreparedStatement.java:4735)
    at com.mysql.jdbc.PreparedStatement.setTimestamp(PreparedStatement.java:4712)
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.talendStats_STATSProcess(JM_ADDR_STG.java:34397)
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.tInformixInput_2Process(JM_ADDR_STG.java:15811)
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG$3.run(JM_ADDR_STG.java:4846)
Exception in component tParallelize_1
java.lang.Exception: At least one of the subjobs in tParallelize fails
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.tParallelize_1Process(JM_ADDR_STG.java:4899)
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.tOracleRow_2Process(JM_ADDR_STG.java:4761)
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.tOracleConnection_2Process(JM_ADDR_STG.java:4636)
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.tMysqlConnection_1Process(JM_ADDR_STG.java:4348)
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG$15.run(JM_ADDR_STG.java:35853)
Exception in component talendStats_DB
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
    at com.mysql.jdbc.Util.getInstance(Util.java:384)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
    at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:404)
    at com.mysql.jdbc.PreparedStatement.setTimestampInternal(PreparedStatement.java:4735)
    at com.mysql.jdbc.PreparedStatement.setTimestamp(PreparedStatement.java:4712)
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.talendStats_STATSProcess(JM_ADDR_STG.java:34397)
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.runJobInTOS(JM_ADDR_STG.java:35913)
    at integracion3r3.jm_addr_stg_0_1.JM_ADDR_STG.main(JM_ADDR_STG.java:35403)
[statistics] disconnected
Job JM_ADDR_STG ended at 12:09 03/01/2012. [exit code=1]

Best Regards.

Sorry to hear that it still doesn't work.
In fact, when program java, this exception occurs occasionally. Sometimes DB statement closes too early.
But in Talend, the java code generate automatically, which can't be changed.

I am sure it's a java code logic error. Maybe you have to try other workarounds.

Best regards!
Pedro