Joining ResultSet's

Discussion in 'Java' started by Jesper Sahner, Oct 20, 2004.

  1. Hi!

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

    Regards,
    Jesper
     
    Jesper Sahner, Oct 20, 2004
    #1
    1. Advertising

  2. Jesper Sahner wrote:

    > 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
     
    John C. Bollinger, Oct 20, 2004
    #2
    1. Advertising

  3. 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

    "John C. Bollinger" <> wrote in message news:<cl6i4g$9fk$>...
    > Jesper Sahner wrote:
    >
    > > 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
    >
     
    Nathan Zumwalt, Oct 21, 2004
    #3
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Awah Teh

    SubQuerying Vs Joining

    Awah Teh, Oct 29, 2003, in forum: ASP .Net
    Replies:
    2
    Views:
    801
    Rich Dillon
    Oct 30, 2003
  2. Stuart
    Replies:
    3
    Views:
    464
    Joe Smith
    Aug 19, 2004
  3. =?Utf-8?B?TWlrZSBNb29yZQ==?=

    joining tables or view

    =?Utf-8?B?TWlrZSBNb29yZQ==?=, Jul 7, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    361
    =?Utf-8?B?TWlrZSBNb29yZQ==?=
    Jul 7, 2005
  4. bluke
    Replies:
    3
    Views:
    395
    Tricia Bushnell
    Sep 4, 2003
  5. Brian J. Sayatovic

    Joining a dead thread

    Brian J. Sayatovic, Jan 21, 2004, in forum: Java
    Replies:
    1
    Views:
    1,774
    Steve Horsley
    Jan 21, 2004
Loading...

Share This Page