Hi,

My requirement is as follows:

Server: Websphere
Framework: Struts

A user will upload excel file. Excel file will have several rows. For
each row, I need to insert one row in oracle database table. And
finally success message is to be shown to the user.

I read the excel file in action class and call a oracle procedure to
insert the records to database.

The issue is that when the size of excel file is large (containing
several records), it is taking a long time to complete insertion and
it shows Internal Server 500 error on the browser. Passing small set
of records to procedure is also not helping.

I think since there is no response from the app server to the client,
this error is coming. Can anybody suggest how to solve this problem?

Thanks in advance,
Palak