[JDBC-64] Support multiple result sets? Created: 03/Jul/13 Updated: 02/Apr/14
|Reporter:||Sean Corfield||Assignee:||Sean Corfield|
Useful for stored procedure results:
Java code to handle multiple result sets:
|Comment by Sean Corfield [ 15/Sep/13 4:20 PM ]|
Post 0.3.0, ideally after adding stored proc support properly (see JDBC-48).
|Comment by Kyle Cordes [ 15/Sep/13 9:45 PM ]|
With or without SPs, this would be an excellent addition; with some RDBMSs, use of compound statement (or SPs) with multiple result sets is relatively common.
|Comment by Sean Corfield [ 02/Apr/14 6:07 PM ]|
Discussion with Pieter Laeremans:
Sean: My thinking is that I would add :multi-result? to execute! and query and then arrange for them to return sequences of result sets. Unraveling the calls so multi-result? can work cleanly inside those functions would be the hard part
Pieter: That sounds fine by me. But there's something a bit more subtle I guess,