ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kris Jenkins <krisajenk...@yahoo.co.uk>
Subject Re: Simple example of N+1 selects
Date Fri, 28 Jan 2005 09:27:59 GMT

Magnus Stattin wrote:

>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 
Take a look at this wiki FAQ:



Kris Jenkins
Email:  kris@jenkster.com
Blog:   http://cafe.jenkster.com/
Wiki:   http://wiki.jenkster.com/

View raw message