topic Problem with import Fact MySQL in Talend Studio

Problem with import Fact MySQL

Anonymous — Fri, 29 Dec 2017 10:44:31 GMT

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

Re: Problem with import Fact MySQL

lojdr — Mon, 01 Jan 2018 22:57:05 GMT

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

Re: Problem with import Fact MySQL

Anonymous — Tue, 02 Jan 2018 07:04:17 GMT

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

Re: Problem with import Fact MySQL

Anonymous — Tue, 02 Jan 2018 10:05:47 GMT

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

Re: Problem with import Fact MySQL

lojdr — Tue, 02 Jan 2018 11:52:48 GMT

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

Re: Problem with import Fact MySQL

Anonymous — Wed, 03 Jan 2018 10:10:42 GMT

thanks you so muuch