Hi
Java Experts
This is my first java experience, I am developing an application to review data using Microsoft SQL and Spring framework, one of stored procedures return multiple result sets. I want to read all the result set data in java side. I try to fix this last 48 hours but I am fail. Can anybody help me?
private SimpleJdbcCall jdbcCall;
public List<Instrument> execute(Instrument instrument) {
Map<
String, Object> inputs = new HashMap<String, Object>();
inputs.put("source", null);
inputs.put("date", null);
inputs.put("time", null);
inputs.put("name_id", null);
Map<String, Object> result = jdbcCall.execute(inputs);
List<Instrument> iList = (List<Instrument>)result.get("DMapper");
return iList;
}
After execute the Map<String, Object> result = jdbcCall.execute(inputs);
It displays 3 result sets
{#result-set-8=[], #result-set-9=[], #result-set-10=[]}, I want to read all the result-sets and want to my List<Instrument> iList
How can I do this?