Problem with import Fact MySQL

Six Stars

Problem with import Fact MySQL

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


Accepted Solutions
Eight Stars

Re: Problem with import Fact MySQL

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

Výstřižek.PNG

 

 

 

 

 

 

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


All Replies
Eight Stars

Re: Problem with import Fact MySQL

Hello Hicham29,

 

The same problem was solved here:
https://www.talendforge.org/forum/viewtopic.php?id=38628

 

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

 

Regards
lojdr

Moderator

Re: Problem with import Fact MySQL

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Problem with import Fact MySQL

Hi lojdr,

 

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

 

thanks you

Eight Stars

Re: Problem with import Fact MySQL

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

Výstřižek.PNG

 

 

 

 

 

 

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

Six Stars

Re: Problem with import Fact MySQL

thanks you so muuch