This week's book giveaways are in the iOS and Features new in Java 8 forums.
We're giving away four copies each of Barcodes with iOS: Bringing together the digital and physical worlds and Core Java for the Impatient and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and Relational Databases and the fly likes copying the contents of Resultset object to another Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Barcodes with iOS this week in the iOS forum
or Core Java for the Impatient in the Java 8 forum!

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "copying the contents of Resultset object to another" Watch "copying the contents of Resultset object to another" New topic
Author

copying the contents of Resultset object to another

Prakash Rao Laknepalli
Greenhorn

Joined: Aug 01, 2006
Posts: 3
Hi,

Is there any way to copy the contents(fully/partially) one Resultset object to another say, like i want to copy 10th to 20th records of rs1 to rs2.
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Originally posted by Prakash Rao Laknepalli:
Hi,

Is there any way to copy the contents(fully/partially) one Resultset object to another say, like i want to copy 10th to 20th records of rs1 to rs2.


Not with standard JDBC. ResultSets are not copyable or clonable. It's remotely possible that a particular driver might have methods to allow this, but no driver I'm familiar with does, and there are lots of good technical reasons not to with many databases.

ResultSets should be thought of as a wrapper class around a network connection; in many implementaions, the results are fetched as needed over the network.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: copying the contents of Resultset object to another