Hi Babitha,
Hopefully that I understand right your issue, so, here is how I made it (and
I think also this is the iBatis way to handle it)
<sqlMap namespace="MyObject">
<resultMap id="result" class="org.test.MyObject" groupBy="id">
<result property="id" column="id" columnIndex="1" />
<result property="name" column="name" columnIndex="2" />
<result property="details" column="details" columnIndex="3" />
<result property="properties" resultMap="MyObject.resultProperty" />
</resultMap>
<resultMap class="org.test.Property" id="resultProperty">
<result property="objId" column="obj_id" />
<result property="name" column="property_name" />
<result property="value" column="property_value" />
</resultMap>
<select id="getMyObjects" resultMap="result"
parameterClass="java.util.Map">
SELECT obj.id as id, obj.name, obj.details, p.id as property_id,
p.obj_id as obj_id, p.name as property_name, p.value as property_value
FROM objects obj LEFT JOIN properties p
ON obj.id = p.obj_id WHERE obj.id=#id#
</select>
</sqlMap>
On Mon, Jun 1, 2009 at 3:39 PM, Babitha <babitha.srid...@ge.com> wrote:
>
> Hi,
>
> I have a Dealer bean. The Dealer bean contains a List of DealerContact bean
> objects. I would have to execute 2 select queries to populate Dealer bean
> and DealerContact bean. I wish to execute both the select queries in one
> go,
> such that all the details of Dealer bean including DealerContact property
> gets populated. But my DealerContact list returns null.
>
> I have attached the Dealer bean, DealerContact bean and the xml file
> containing the queries. Please help me in finding out where I am going
> wrong.
>
> I am making the iBatis call using the below code:
>
> List dealerDetailsList =
> getSqlMapClientTemplate().queryForList("selectDealerDetails", dealer);
>
> Thanks in advance for the help extended.
>
> - Babitha http://www.nabble.com/file/p23814348/sqlDatabaseQueries.xml
> sqlDatabaseQueries.xml http://www.nabble.com/file/p23814348/Dealer.java
> Dealer.java http://www.nabble.com/file/p23814348/DealerContact.java
> DealerContact.java
> --
> View this message in context:
> http://www.nabble.com/Populate-List-within-object-in-iBatis-tp23814348p23814348.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
--
Regards,
Alin
