Joining ResultSet's

J

Jesper Sahner

Hi!

Is it possible jo join ResultSet's inside Java in the same manner that
you join database-tables using JDBC?

Regards,
Jesper
 
J

John C. Bollinger

Jesper said:
Is it possible jo join ResultSet's inside Java in the same manner that
you join database-tables using JDBC?

The JDBC API does not provide a built-in means to do what you ask. You
should instead have the database perform the join, producing only one
ResultSet in the first place.


John Bollinger
(e-mail address removed)
 
N

Nathan Zumwalt

Are you trying to join ResultSets from disparate databases? You'll
probably need to read the contents of the ResultSets into arrays of
data objects and do the join programmatically.

//Nathan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,764
Messages
2,569,567
Members
45,041
Latest member
RomeoFarnh

Latest Threads

Top