ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: DTD problem with new release 2.2 - handling multiple ResultSet
Date Thu, 19 Apr 2007 16:50:34 GMT
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} <manjeet.bhatnagar1@pepsi.com> 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
>
>

Mime
View raw message