Thanks!
It looks like I can have the bcp batch file locally in the same machine as my webserver.
So the first part of the problem gets solved.I can use Runtime.exec() to execute it I guess.
However still thinking about the second part..should I start the batch process by spawning a new
thread so that when the Runtime.exec() method retirns back we could send back an email or somthing to the user.I would probably put this whole thing in the run method.This would get started from a pop-up servlet(that Thread.start() would be called from a pop up servlet) so that the user might close the pop-up window and do something else(or go for a beer!
).But the thread would keep running in the background and whenever the process is over the user gets an email notification.
Does this sound good?
Please comment..any other idea is also welcome.
Thanks,
Sunetra.