ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Koka Kiknadze" <226...@gmail.com>
Subject Re: Simple questions
Date Thu, 16 Nov 2006 15:17:37 GMT
> I must to use a queryForObject and no a queryForList
In your setup if you execute:
queryForObject("getMatchList", 5)
it will retrieve single Match object having match_id = 5 with child
matchScores list populated.
if you execute
queryForList("getMatchList", 5)
it will return List containing all Match objects having match_id = 5 with
child matchScores lists populated (i.e. if match_id is unique index the list
will contain single object).

And change your join type in SQL as Engel proposed (to get matchis w/o/
corresponding scores)

View raw message