I know how to stream both character and binary data from the database through a
servlet to the browser, but this problem seems to be a slightly different case. This is not HTML or an image stored in the database--it needs to be a text file. No difference from the others in the database...I'll just store text in a CLOB.
But you know how if you have a file on your webserver and you someone clicks on a URL to it and the browser pops up with a file download box? How do you get the browser to do that if your servlet is pulling the text file out of the database?
I see that there are products on the market for stuff like this...is it a nontrivial solution? If there's a good way to trick the browser into thinking that I'm giving it an already constructed file, is there a way to also tell it what the file's name is, even though it's not actually a constructed file? I mean, if I have this String/bytes out of the database, I want the browser to think that the CSV file is named something.csv so that the user has a better understanding of what to do with it. Thanks...
[ December 23, 2004: Message edited by: Stephen Huey ]