close a TFTPConnection

One Star

close a TFTPConnection

I have a DI job with the following flow:
tFTPConnection -> tFTPFileList -> tFTPGET -> tJava -> tFTPRename
I check the "Use an existing connection" checkbox for the subsequent tFTP components.
Everything works fine but, once we scheduled this job, it caused issues with the SFTP server we are connecting to since the connections were never closed. We wound up with multiple attempted connections.
I searched on this issue and found some forum posts from a few years ago. But I'm wondering if there's updated information on this topic. What's the best way for me to close the SFTP connection at the end of the job?
Seventeen Stars

Re: close a TFTPConnection

Actually this would be a good reason to build a component!
Add a tJava component to your job where you want to close the connection and add this code:
You have to apply your tFTPConnection number for the global map key.
This code works only for the SFTP connection.
com.jcraft.jsch.ChannelSftp c_tFTPConnection_1 = (com.jcraft.jsch.ChannelSftp) globalMap.get("conn_tFTPConnection_1");

In case of simple FTP use this code: ftp_tFTPConnection_1 = ( globalMap.get("conn_tFTPConnection_1");
Seventeen Stars

Re: close a TFTPConnection

Cloud Free Trial

Try Talend Cloud free for 30 days.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.