title: Implementing ResultSet interface from a generic SOAP request
body: <p>I need to create with an object implementing the Java ResultSet interface getting the data from a generic SOAP request(i need to work on an higher level with both these SOAP result sets and with JDBC result sets).</p>
  
  <p>As i wrote in the title, the SOAP request can be generic: it depends on the parameters passed and can consume different web services, so I know only at runtime the wsdl and the structure the SOAP service is going to deliver me.</p>
  
  <p>I've been trying to figure out in the last few days how to do this, I've come out with few ideas:</p>
  
  <p>1- converting the SOAP body into an xml WebRowSet document, that can be unmarshalled to a WebRowSetImpl class, that implements a WebRowSet interface (interface extending ResultSet).
  In this case, I'd have to make customs XSLT on the fly, starting from the WSDL and SOAP response documents.</p>
  
  <p>2- Create Java objects from SOAP response, and then trying to map and fill a generic stub JDBC result set with the data within the java objects</p>
  
  <p>3- Storing all the data from SOAP response into a (normalized or not normalized) database, and then read from the database with any JDBC driver. </p>
  
  <p>Which do you think is best overall the way to go?
  And which the simplest way to go?</p>