Hi,
I am doing one project in Sevlet with
JSP. Oracle 9i is the database and I am using JRUN 4.0 Server in Windows 2000 Professional.
What I am trying to do is, uploading a text file(may be notepad or textpad) that contains the record. I have written the code in
servlet an jsp for reading the records in the flat file and do the validation and upload it in the database.
For Example I want to do the bulk upload of 10,000 - 25,000 records, at that time I am facing the problem.
I will give the example scenerio: I want to upload the below flat file:
UploadForCustomer.txt
----------------------
#FORMAT
#Customer ID | Customer Name | Customer Age | Customer Address
11111111111 | aaaaaaaaaaaaa | 12 | aaaaaaaaaaaaaaaa
11111111111 | aaaaaaaaaaaaa | 12 | aaaaaaaaaaaaaaaa
11111111111 | aaaaaaaaaaaaa | 12 | aaaaaaaaaaaaaaaa
.
.
.
.
Above is the example file I am trying to upload in the database thru' servlets and jsp.
If I am having more than 10,000 - 25,000, It's telling connection timed out, reacuire the connection. How to fine tune this problem.
Is there any way in
JAVA (Sevlet) to upload in an efficient way without having the connection problem.
Another question: For what MultiPartRequest is used.