write « Resultset « Java Database Q&A





1. Writing resultset to file with sorted output    stackoverflow.com

I want to put "random" output from my result set (about 1.5 mil rows) in a file in a sorted manner. I know i can use sort by command in my ...

2. Fastest way to write huge data in text file Java    stackoverflow.com

I have to write huge data in text[csv] file. I used BufferedWriter to write the data and it took around 40 secs to write 174 mb of data. Is this the ...

3. Writing a large ResultSet to a File    stackoverflow.com

I'm tryin to write a large ResulSet (~1mm rows) to a single file. Is there a preferred/efficient way to do this in Java 1.6?

4. Writing a large resultset to an Excel file using POI    stackoverflow.com

This is sort of inline w/ Writing a large ResultSet to a File but the file in question is an Excel file. I'm using the Apache POI library to write an ...

5. Writing Resultset to File - best way?    coderanch.com

Hi, I am not an expert, but this is what I learnt in the past 2 weeks, which I think might help you a little bit. When you get the resultSet from a database, there is a default FetchSize. Everytime you do ResultSet.next(), it will first check whether there are records already fetched. If not, it will connect to the database ...

6. Writing File(Excel) in ResultSet    coderanch.com

hello friends, I want to write file i.e. FileOutputStram object like wb.write(fileout) in resultset so that while loop should be able to write file row by row, wb is the WorkBook for excel and write(fileout) is write method for writting excel file, actually i have mentioned already my code in "invalid cursor error topic", you can see that code and please ...

7. Writing the results of this ResultSet to File is VERY slow (SOLVED)    coderanch.com

Hi, I hope I'm posting in the right place. Since I can't tell whether my problem is in my use of ResultSet or with the OutputStream, I'm posting in general. This output of this code is running very slowly. There are about 10,000 records for the period in question that my ResultSet object is returning. It is then formatting and writing ...

9. Using a resultset to write to a .txt file    coderanch.com

Hello, I am new to Java and I am trying to write from a SQL resultset("SELECT RecordID,ARNumber,DateUpdated,REVCHANGES FROM Updates") is ther a way I can write the results stright to a database on the mainframe? If this is not possible then I will need to write the result set from resultset query toa text file. Is there any way to write ...