RE: Questions on N+1 and ParameterMap

2005-03-10 Thread James, Steven
luck steve.. -Original Message- From: Marty Tomasi [mailto:[EMAIL PROTECTED] Sent: Thu 3/10/2005 1:20 AM To: ibatis-user-java@incubator.apache.org Subject: Questions on N+1 and ParameterMap Hi, First off, excellent work to date on iBATIS. It's been a real treat to work with so far. I

RE: Questions on N+1 and ParameterMap

2005-03-10 Thread James, Steven
luck steve.. -Original Message- From: Marty Tomasi [mailto:[EMAIL PROTECTED] Sent: Thu 3/10/2005 1:20 AM To: ibatis-user-java@incubator.apache.org Subject: Questions on N+1 and ParameterMap Hi, First off, excellent work to date on iBATIS. It's been a real treat to work with so far. I

Re: Questions on N+1 and ParameterMap

2005-03-10 Thread Paul Barry
Subject: Questions on N+1 and ParameterMap Hi, First off, excellent work to date on iBATIS. It's been a real treat to work with so far. I could go on, but I have some questions. Note that I am using the latest 2.0.9B code when running this code. Given two tables with the following: Table

Re: Questions on N+1 and ParameterMap

2005-03-10 Thread Paul Barry
technique to only get the data when you need it. Good luck steve.. -Original Message- From: Marty Tomasi [mailto:[EMAIL PROTECTED] Sent: Thu 3/10/2005 1:20 AM To: ibatis-user-java@incubator.apache.org Subject: Questions on N+1 and ParameterMap Hi, First off, excellent work to date

Re: Questions on N+1 and ParameterMap

2005-03-10 Thread Paul Barry
I tried to make a simple example myself using the new groupBy feature and I think I am having a problem similar to Marty's. I created a simple author has many books example. I have an Author Object like this: public class Author { private Long id; private String name; private

Re: Questions on N+1 and ParameterMap

2005-03-10 Thread Karen Koch
I'm sorry, I'm an idiot. I flew off the handle on that one confused the old select syntax with the new groupBy feature... I believe you want the groupBy on your child ResultMap. --- Karen Koch [EMAIL PROTECTED] wrote: You need two select statements, not a query with a join. Really, there

RE: Questions on N+1 and ParameterMap

2005-03-10 Thread Marty Tomasi
on N+1 and ParameterMap Importance: Low I tried to make a simple example myself using the new groupBy feature and I think I am having a problem similar to Marty's. I created a simple author has many books example. I have an Author Object like this: public class Author { private Long id

Re: Questions on N+1 and ParameterMap

2005-03-10 Thread Paul Barry
expected. Still puzzled as to what to try next, Marty P.S. Thanks, Paul. -Original Message- From: Paul Barry [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 11:19 AM To: ibatis-user-java@incubator.apache.org Subject: Re: Questions on N+1 and ParameterMap Importance: Low I tried

RE: Questions on N+1 and ParameterMap

2005-03-10 Thread Marty Tomasi
] Sent: Thursday, March 10, 2005 3:40 PM To: ibatis-user-java@incubator.apache.org Subject: Re: Questions on N+1 and ParameterMap Importance: Low Karen is correct, once I changed my groupBy from author.id to id, it works as expected. Marty, do you have groupBy=id or groupBy=alert_id