title: Joining multiple result set
body: <p>I am trying to develop a Java application which merges data from multiple data source basically RDBMS. The scenario is some thing like this.</p>
  
  <p>I have creates a connection to two data sources, lets say a MSSQL database and other Oracle. Also on each connection a user can create a DataObject( a Java object) which contains a SQL query and a connection. The query is executed on the connection and result are displayed.</p>
  
  <p>Now what I want is that my user can join and filter result obtained from multiple DataObject.</p>
  
  <p>Currently I am looking on the following solution:
  <LI><B>JDO/Hibernate</B> - I will create a object from the ResultSet obtained from the query execution and will use the multiple objects with filter and joining condition.
  <LI><B>Java RowSet</B> - I will create a RowSet object over result sets and user JoinRowSet and FilteredRowSet to join multiple result set.</p>
  
  <p>Please advice me on my choice. Also please can other solution be looked into.</p>