I'm having a bad hair day or something, if some one can give me some clue,
I have servlet that is initiated at start up
I query the database and get a record set let say 500 rows 30 columns ID, Name, Number etc...
1. how do I get the column name let say getColumnName("ID"), getColumnName("Name"), etc.. I iterating through the record set..
2. I want to eventually write these to a file pipe delimeted to ftp to another app.
a. - Would it be OK to write directly print.out(getColumnName("ID"), getColumnName("Name"), etc.. )?
b. - Or should I look at storing the records in a vector and then writing the data?
3. Later on I get a response from the app I sent the file to to tell me if the records were successful or fail and then I update the status of the record in the database.
If some one can give me an idea what the best apprach to this is I will love you forever.