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

Sging — Sat, 16 Nov 2024 00:36:37 GMT

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!

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

Anonymous — Thu, 04 Mar 2021 06:00:17 GMT

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

topic Re: Error com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. in Talend Studio

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

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