Problem on multiple user of a page
Hi I am working on developing a JSP to generate a report in term of Excel sheet for my organization and the brief explanation to this tool and my problem is as follows.
I need to generate Excel sheet based on some inputs.
There are two table used by this tool , XYZ and ABC
Whenever a request is made for this JSP , all entries from table XYZ and ABC are deleted.
Inputs are supplied by an input form within this JSP which receives the input and inserts them into a table 'XYZ'.
Then I need to a execute a Stored Procedure which will get values form this XYZ table and do some calculation and execute query on another database and results are stored in the table 'ABC'.
I generate the Excel sheet fetching the values inserted in the second table 'ABC'.
Every thing runs well until there is only a single request for this JSP.
If one user sends a request and while this request is under processing (which takes around 2 min ) another user send another request for the same JSP. It deletes all the entries (generated by the first request )from the table ABC. That's y when the first request tries to generate the Excel sheet it founds no record from the ABC record or founds records inserted by the second request. That's y generates a faulty report.
So if any one of u have any idea how to overcome this problem it will help me a lot .
Thanking u in advance.
