Update Database tables through Java servlet using UI5 File Uploader

[#1]

Hi,

I am trying to insert data into database tables using excel file, for which I am using UI5 File Uploader, and calling Java Servlet in the backend. My requirement is to capture all the logs(which DB entries were updated, which failed, etc), and display this on UI.

My issue is I am unable to read this information, because the UploadComplete event of file uploader is getting triggered even before the file processing is complete in the backend.

Do you know if there is any other way to handle this? Any help/suggestions highly appreciated.

Thanks

[mvaibhav]

Hi Sunil,

If i have understood properly, you are sending the excel file to the back-end, reading the data from the excel file in back-end and updating the database based on the excel data.

Upload collection is used for just sending the documents to the back-end and it will not wait for the system to process the file to send the response.

In order to achieve your requirement, you should read the data from the excel file on the client side and send the data to the back-end to get & display required response.

Other way round could be to store the response in a temporary table and make a separate call from the UI once the upload collection returns successfully to fetch the output and display. However second option might lead to issues if you back-end takes considerable time to update and populate the temporary table.

Thanks,

Vaibhav Maheshwari