Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tMySQLClose

Talend Studio and Enterprise Data Integration Administration Center 5.5.1
We have a simple job to update MySQL tables every fifteen minutes.
At the end of the job, does Talend close the database connection by itself, or is it necessary that I include a tMySQLClose component to ensure the connection is closed?
Labels (3)
1 Reply
Anonymous
Not applicable
Author

If the connection is created on tMysqlOutput or tMysqlRow, the connection will be closed by automatically. If the connection is created on tMysqlConnection, you have to close it on tMysqlCommit/tMysqlRollback or using tMysqlClose. Take a look at this article:
https://help.talend.com/pages/viewpage.action?pageId=190513213

Best regards
Shong