Magnus Stattin wrote:
Hi
How would I be able to avoid the N+1 selects if I have for example a
departments table and a table with employees. All employees belongs to a
department and I would like to get a list of department valueObjects where
each departmentVo contains a collection of employee valueObjects.
Is it possible to do this with a single select with Ibatis and how would the Sqlmap look like. I am looking for a simple example to get me started.
Thank you
Magnus
Take a look at this wiki FAQ:
http://wiki.apache.org/ibatis/How_20do_20I_20get_20around_20the_20n_2b1_20selects_20problem_3f
Kris
-- Kris Jenkins Email: [EMAIL PROTECTED] Blog: http://cafe.jenkster.com/ Wiki: http://wiki.jenkster.com/
