Hopefully Kyle won't mind if I butt in.
I'm back from a night at 'the bar' (ugh), and I need something to do.
My own thoughts run like this:
1. Use the MultipartRequest object, and have those files nicely uploaded to the 'upload' directory.
2. Use java.io classes to open that file.
from the api: BufferedReader in = new BufferedReader(new FileReader("foo.in"));
I think the MultipartRequest can return you the file object itself? Failing that, I *know* you can get the filename, so you'd substitute that method call for the "foo.in" parameter.
3. Read it line by line (
String ln = in.readLine(); )
4. Parse the just-read line using a StringTokenizer (because it will be nicely tab/comma/colon delimited. The point is.. it's delimited)
StringTokenizer st = new StringTokenizer(ln, "/t");
5. Use the funky new
JDBC 2.0 BatchUpdate feature. Hopefully Oracle has a driver by now? It should all look something like:
Does that cover it? It's 3am.. I can't be sure.
[This message has been edited by Mike Curwen (edited November 03, 2001).]