Problem with import Fact MySQL

Highlighted
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch