URGENT!! Joinable Interface problem

Discussion in 'Java' started by abhi, Apr 29, 2005.

  1. abhi

    abhi Guest

    I am facing a problem using the joinable interface's setMatchColumn
    method for specifying multiple columns for the join operation. It is
    simply taking the first column and performing the join operation.

    For e.g.

    ResultSet rs = stmt.executeQuery("select a,b,c from a1");
    CachedRowSet a1 = new CachedRowSetImpl();
    a1.populate(rs);
    String[] arr = {"a","b"};
    a1.setMatchColumn(arr);
    JoinRowSet jrs = new JoinRowSetImpl();
    jrs.addRowSet(a1);
    ResultSet rs1 = stmt.executeQuery("select a,b,d from a2");
    CachedRowSet a2 = new CachedRowSetImpl();
    a2.populate(rs1);
    a2.setMatchColumn(arr);
    jrs.addRowSet(a2);

    The above code just does a join on column "a" without considering
    column "b"... plz plz help...
     
    abhi, Apr 29, 2005
    #1
    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. Wildepiet
    Replies:
    0
    Views:
    1,869
    Wildepiet
    Jun 14, 2004
  2. cyberco
    Replies:
    8
    Views:
    501
    cyberco
    Feb 25, 2006
  3. Sachin Jagtap

    URGENT !! QUEUE STL PROBLEM URGENT!!

    Sachin Jagtap, Apr 28, 2005, in forum: C++
    Replies:
    4
    Views:
    1,055
    Mark Stijnman
    Apr 29, 2005
  4. Xah Lee
    Replies:
    15
    Views:
    600
    Sherm Pendley
    Mar 23, 2007
  5. Rob
    Replies:
    3
    Views:
    450
Loading...

Share This Page