Sorry for not having given a background to the problem
Actually, we have some folks who are not on company network all the time.The are our sales guys.For them, there is this age old excel application, which they use to decide on the price etc based on various parameters.Access is the DB used for them
Now when they come back,we need to upload this data for management review and other decision making process. As the sales guys don't want any change to the way they go about doing their job(ie using excel), we have to give them a buton on their excel which will upload and download data from the centralised DB.
That is why use of XMLHttp was proposed and so we fetch the data from the access db, convert to xml and send it to my servlet
which in turn pushes it to the oraccle db.
Now this task can't take lot of time and after an analysis, we found that we need to update say around 4k records each time we do this synchronise thing.
We already are useing connection pooling at JBoss level.
If i use csv, how do i send it to the server?
(Not the cricket guy)