RE: Confused with groupBy

2005-08-27 Thread Brian Yoffe
an -Original Message- From: Prashanth Sukumaran [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 10:38 PM To: user-java@ibatis.apache.org Subject: RE: Confused with groupBy Hi Brian, If you are getting a NullPointerException then Add this javaType="int" jdbcTy

RE: Confused with groupBy

2005-08-26 Thread Prashanth Sukumaran
ant. Now, how do I keep iBatis > from bombing when it encounters the nulls and tries to map that onto an > order object. Essentially, I want an account object created for Mike I > expect my code to create a new list just as you recommended, Huy. > > Hope that clears up my questi

RE: Confused with groupBy

2005-08-26 Thread Brian Yoffe
list just as you recommended, Huy. Hope that clears up my question. Thanks, Brian -Original Message- From: Huy Do [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 8:24 PM To: user-java@ibatis.apache.org Subject: Re: Confused with groupBy Shouldn't you do that yourself in

Re: Confused with groupBy

2005-08-24 Thread Huy Do
is.apache.org Subject: Re: Confused with groupBy You got it exactly right. :-) Larry On 8/24/05, Alan Chandler <[EMAIL PROTECTED]> wrote: Larry Meadors writes: ... The groupBy attribute is used to deal with the "N+1" selects problem. The "N+1 Selects" problem

RE: Confused with groupBy

2005-08-24 Thread Brian Yoffe
create an empty list of orders for those accounts where there exist no orders? Thanks, Brian Yoffe -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 11:33 AM To: user-java@ibatis.apache.org Subject: Re: Confused with groupBy You got it exa

Re: Confused with groupBy

2005-08-24 Thread Larry Meadors
You got it exactly right. :-) Larry On 8/24/05, Alan Chandler <[EMAIL PROTECTED]> wrote: > Larry Meadors writes: > > ... > > > > The groupBy attribute is used to deal with the "N+1" selects problem. > > The "N+1 Selects" problem is caused by trying to load child records > > that are related to

Re: Confused with groupBy

2005-08-24 Thread Alan Chandler
Larry Meadors writes: ... The groupBy attribute is used to deal with the "N+1" selects problem. The "N+1 Selects" problem is caused by trying to load child records that are related to a list of parent records. So, if you run one query to get the parent records, and there are some number "N" of

Re: Confused with groupBy

2005-08-24 Thread Larry Meadors
Wow, lots of good questions. Starting with the easiest - the namespace attribute is used to logically group sqlmap elements - for example, you can define a "Product" namespace for mapped statements and related items that are to be used when working with products. That is done by setting the useSta