The XML you are using was never implemented - the top of the WIKI page you
pulled this from clearly says that the page is obsolete.
Multiple result sets are implemented by specifying a comma delimited list of
result maps...
<select id="fred" resultMap="rs1, rs2. rs3">
...
</select>
Jeff Butler
On 4/19/07, Bhatnagar, Manjeet {PBG} <[EMAIL PROTECTED]> wrote:
I am trying to use this new feature in new release 2.2 for handling
multiple result set returning from a stored procedure.
In my SqlMap when i am defining
<storedProcedureResultSets id="myResultSets">
<storedProcedureResultSet resultMap="custCount" />
<storedProcedureResultSet resultMap="custDetails" />
<storedProcedureResultSet resultMap="custGrpDetails" />
</storedProcedureResultSets>
I am geting an error :
XML Parser Error. Cause: org.xml.sax.SAXException: Error: URI=null
Line=75: Element type "storedProcedureResultSets" must be declared.
because the DTD i am using is :
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd";>
and the above element is not defined in this DTD.
Do we have a new DTD to support this multiple Resultset feature.
I appreciate , if someone can help me manage this problem of handling
multiple resultset using Ibatis. I don't want to go JDBC way.
Thanks
Manjeet Bhatnagar
(914) 767-6402
