topic Re: Check File Exists in Remote Server in Talend Studio

Check File Exists in Remote Server

WSyahirah21 — Fri, 15 Nov 2024 23:16:07 GMT

I am currently trying to check if a file is exists in my remote dev server or not. For job execution, I set the Target Exe to my dev server already, instead of localhost. My task should be:

checkFileExists:

if not exist --> create file

if exists--> do something

I know I can use component tFTPFileExist in TOS to check the file in dev server. However, i need to bypass the ProxyJump first before can access the dev server, saying:

ProxyJump IP: 1.1.1.2 port 2000

dev server ip : 1.1.1.3 port 2000

Im so confused if I can use

tFTPFileExist to complete this task and which IP should I use to do so. Ive tried using dev server Ip however it returns the following error.

java.net.ConnectException: Connection refused (Connection refused)

I also tried to use the existing connection setting for tFTPFileExist as the TOS ald connected to dev server so I assume it can directly use the connection, however the component list is empty so Im unable to do so.

Re: Check File Exists in Remote Server

Anonymous — Thu, 27 Jan 2022 09:32:40 GMT

Hello,

The tFTPFileExists component works with directories since V 7.0.1.

Here is an external Java article about: Java FTP Check if a directory or file exists on server

Let us know if that helps for your use case.

https://www.codejava.net/java-se/ftp/determine-if-a-directory-or-file-exists-on-ftp-server

Best regards

Sabrina

Re: Check File Exists in Remote Server

WSyahirah21 — Fri, 28 Jan 2022 01:40:26 GMT

Hi Sabrina. thanks, does it works with proxyHost? I need to use the proxyHost first before setting it up to Hostname of server. However, now I received this error -> tFTPFileExist_1 - Can't create connection: Reply from SOCKS server has bad version.

Is there any articles or documentation that refers to the connection of tFTPFileExists to proxyHost?