Anyone? Please help..let me know if I am not clear enough or asking very
trivial question.
J R wrote:
>
> I am new to iBatis and having trouble with multiple resultMaps. I have one
> resultMap which has properties which are populated by making another
> select call. I am extending
> org.springframework.orm.ibatis.support.SqlMapClientDaoSupport and in DAO
> class I have call as below-
>
> getSqlMapClientTemplate().queryForList("getCategoryInfo", null);
>
> Also other requirement is to connect to 2 different databases before SQL
> is executed. So database source selection is done using some custom code
> and dao has correct database source reference.
>
> Problem I am seeing is that when getProductList or getAttributeList select
> is called, another database connection is made to default database source,
> whereas I was expecting it to use same database source as part of the dao.
>
> Probably I am missing something here which is causing iBatis to make new
> connection everytime. But if I add method to DAO like this it uses the
> selected datasource.
>
> getSqlMapClientTemplate().queryForList("getProductList", 10);
>
> Can anyone help me with this?
>
> <resultMap id="category" class="Category">
> <result property="cid" column="id" />
> <result property="cname" column="name" />
> <result property="listProduct" column="{key=cid}"
> select="getProductList"/>
> <result propertly="listAttribute" column="{key=cid}"
> select="getAttributeList"/>
> </resultMap>
>
> <select id="getCategoryInfo" resultMap="category" >
> select id, name
> from categories
> </select>
>
> <resultMap id="product" class="Product">
> <result property="pid" column="pid" />
> <result property="pname" column="pname" />
> </resultMap>
>
> <select id="getProductList" resultMap="product" >
> select pid, pname
> from products
> where categoryid = #key#
> </select>
>
> <resultMap id="attribute" class="Attribute">
> <result property="aid" column="aid" />
> <result property="aname" column="aname" />
> </resultMap>
>
> <select id="getAttributeList" resultMap="attribute" >
> select aid, aname
> from attribute
> where categoryid = #key#
> </select>
>
--
View this message in context:
http://www.nabble.com/Multiple-resultMap-per-connection--tp16136325p16192135.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
