Error with mysql conecction, on execution time is off.

One Star

Error with mysql conecction, on execution time is off.

hi!.
i have designed threes subjobs for parallelize execution and two of three subjobs working fine but the first no i don´t know why?.
i have a problem with next error:
Communications link failure
The last packet successfully received from the server was 1.329.480 milliseconds ago. The last packet sent successfully to the server was 19.303 milliseconds ago.Exception in component talendStats_DB
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
i tried with additional parameters but don´t working!.
So what can i do? anbody can help me please?. Thanks Best Regards. i have attached a few images.
One Star

Re: Error with mysql conecction, on execution time is off.

Hi
The reason of this issue may be complex.
First, don't share a DB connection here.
Second, try to add Additional JDBC Parameters "autoReconnect=true".
If error still, try to modify mysql max connection time.
Best regards!
Pedro
One Star

Re: Error with mysql conecction, on execution time is off.

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.
connecting to socket on port 3879
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)
disconnected
Job JM_ADDR_STG ended at 12:09 03/01/2012.
Best Regards.
One Star

Re: Error with mysql conecction, on execution time is off.

sorry here are the images
One Star

Re: Error with mysql conecction, on execution time is off.

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