ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Magnus Stattin" <magnus.stat...@cue.se>
Subject Simple example of N+1 selects
Date Fri, 28 Jan 2005 06:35:01 GMT


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 


View raw message