Problem with import Fact MySQL

[Anonymous]

Hi how are you?

please i need help i hav this error : com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed

can some one help me

Thanks you

[lojdr]

Hello Hicham29,

The same problem was solved here:
https://community.talend.com/t5/Design-and-Development/Keeping-MySQL-DB-connection-alive/td-p/59801

Were you able to find a solution with the thread above?

Regards
lojdr

[Anonymous]

Hello,

For more information, please refer to:

http://razorsql.com/docs/help_mysql.html and https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html.

Best regards

Sabrina

[Anonymous]

Hi lojdr,

Thanks you for response, he give me another error can please help me i'm beginner in talend

thanks you

ice_screenshot_20180102-110356.png
ice_screenshot_20180102-110421.png

[lojdr · Accepted solution]

Hello Hicham29,

Do you use the "autoReconnect=true" in JDBC Parameters?

What is the value of the wait_timeout" MySQL server parameter? Can it be raised?

There are 2 parameters in Advanced settings: 

• Number of rows per insert
• Commit every

Try to play with these parameters (lower the "Commit every" and raise the "Number of rows...", but still use the Additional JDBC Parameters recommended previously).

Please be aware, that it may have an impact on performance.

It also can be an issue with the network, but please check the recommendation above first.

Regards

lojdr

[Anonymous]

thanks you so muuch