URGENT!! Joinable Interface problem

A

abhi

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

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,769
Messages
2,569,582
Members
45,070
Latest member
BiogenixGummies

Latest Threads

Top