Is there any difference between FTP and SFTP regarding content cache mechanism

Question

We are using hxtt jdbc driver to load files from server

What is HXTT CSV driver : hxtt driver is used treat file as database tables allow user to fetch the data using SQL Queries

Example : Employee.csv file having following record

EmpID, EmpName

Suraj, 001

Pankaj, 002

Now, I can fetch this simple sql Query : select * from Employee;

We are using FTP and SFTP protocol to load files from remote server. connection is successful But we are facing strange issue.

Issue :

1. We have 2 columns in our file now I discover these columns in my product, its successfully discovered 2 columns
2. Now If I update file with new Column, and try to discover its not getting updated one column

Same scenarios works fine with FTP and SMB protocol

• Web-Server we are using : Apache Tomcat
• Java 8
• SFTP client is inside hxtt jar file
• We are using JSCH jar to connect to SFTP server

So, I was wondering is there anything from protocol itself that not allowing to get updates results from file ?