Error com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

[Sging]

Hello everyone,

I know this is a common error (after searching in the forum I saw some related posts), however I struggle to find a solution.

I have the job below, which has a big runtime. Sometimes it runs successfully sometimes, it returns the error

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed .

The failing component is a tDBInput one. (in red circle).Other answers similar to this one suggest to add on JDBC parameters "autoReconnect=true" ( using & on top of other parameters

"noDatetimeStringSync=true&allowMultiQueries=True&autoReconnect=True" )

. I did, inside the tDBConnection component, as shown below, but it again failed.

 

What else should I try?

Thanks in advance!

[Anonymous]

Hi

Make sure the 'close the DB connection' on tXXXOutput or txxxCommit component is not checked.

is this job executed independently? or it is called by other job or is running parallelly? Like the DB action part of job is triggered by iteration.

Regards

Shong