Question Re: Update Database tables through Java servlet using UI5 File Uploader in Technology Q&A

Update Database tables through Java servlet using UI5 File Uploader

sunil_khemchand2 — Wed, 09 Jan 2019 04:56:25 GMT

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

Re: Update Database tables through Java servlet using UI5 File Uploader

maheshpalavalli — Wed, 09 Jan 2019 05:14:47 GMT

Hi Sunil,

The documentation says otherwise:

uploadComplete

Event is fired as soon as the upload request is completed (either successful or unsuccessful). To see if the upload request was successful, check the 'state' parameter for a value 2xx. The uploads actual progress can be retrieved via the 'uploadProgress' Event. However this covers only the client side of the Upload process and does not give any success status from the server.

It seems that it is only for the client side upload.

If you are using the odata service, there are two events:

requestCompleted and batchRequestCompleted maybe use them and check your handler for those event gets called.

BR,

Mahesh

Re: Update Database tables through Java servlet using UI5 File Uploader

sunil_khemchand2 — Wed, 09 Jan 2019 05:34:34 GMT

Hi Mahesh,

I am uisng a Java Servlet, not Odata service.

Regards,

Sunil

Re: Update Database tables through Java servlet using UI5 File Uploader

mvaibhav — Wed, 09 Jan 2019 09:16:39 GMT

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

Re: Update Database tables through Java servlet using UI5 File Uploader

maheshpalavalli — Wed, 09 Jan 2019 09:23:17 GMT

Then are you calling the java servlet manually to update the excel file to db?

Re: Update Database tables through Java servlet using UI5 File Uploader

sunil_khemchand2 — Wed, 09 Jan 2019 20:46:23 GMT

Hi Vaibhav,

Thanks for your response.

Yes, your understanding is correct. I am sending the excel to back-end for further processing. I was also thinking about the issue with temporary file, but don't see any other option. Will give that a try.

Thanks and Best Regards,

Sunil

Re: Update Database tables through Java servlet using UI5 File Uploader

sunil_khemchand2 — Wed, 09 Jan 2019 20:52:06 GMT

Hi Mahesh, I am calling the servlet from the upload button itself

Re: Update Database tables through Java servlet using UI5 File Uploader

maheshpalavalli — Thu, 10 Jan 2019 07:49:03 GMT

Then if you call the servlet will it return any response function call when it is successful(for asynchronous)? If synchronous, then immediatly after that call the servlet again to fetch the db log data.

BR,

Mahesh