From userkwalker@example.com Tue Jun 03 17:02:10 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 57739 invoked from network); 3 Jun 2008 17:02:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Jun 2008 17:02:10 -0000 Received: (qmail 92667 invoked by uid 500); 3 Jun 2008 17:02:13 -0000 Delivered-To: kwalker@example.com Received: (qmail 92645 invoked by uid 500); 3 Jun 2008 17:02:12 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 92634 invoked by uid 99); 3 Jun 2008 17:02:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Jun 2008 10:02:12 -0700 X-ASF-Spam-Status: No, hits=-1.4 required=10.0 tests=HTML_FONT_FACE_BAD,HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy includes SPF kwalker@example.com) Received: from [83.161.120.155] (HELO psmtp.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Jun 2008 17:01:20 +0000 Received: from source ([83.161.120.155]) (using TLSv1) by exprod8ob112.postini.com ([83.161.120.155]) with SMTP; Tue, 03 Jun 2008 10:01:29 PDT X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C8C59B.7A89EFD0" Subject: RE: Next Release? Date: Tue, 3 Jun 2008 10:01:34 -0700 Message-ID: <kwalker@example.com> In-Reply-To: <kwalker@example.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Next Release? Thread-Index: AcjCZEUyXekTy06zTWS5F73m+cXmiQDNx3cg References: <kwalker@example.com> <kwalker@example.com> From: "Michael McCurrey \(5318\)" <kwalker@example.com> To: <kwalker@example.com> X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01C8C59B.7A89EFD0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Thats very good to hear as we are in the midst of a largescale migration from 'homegrown' to iBatis.net =20 =20 ________________________________ From: Clinton Begin [mailto:kwalker@example.com]=20 Sent: Friday, May 30, 2008 7:48 AM To: kwalker@example.com Subject: Re: Next Release? Hi Sal, I'm the lead developer of iBATIS for Java and the original creator of iBATIS. =20 I don't think you have anything to worry about, as I believe that iBATIS.NET has a bright future and will possibly even surpass the success we've seen on the Java side. iBATIS for Java has a lot more competition with products like Hibernate and Spring JDBC as serious competitors. Furthermore, Java application best practices are more compatible with typical ORM solutions like Hibernate. In the .NET world, there are very few ORM options (NHibernate, LINQ to SQL...), but more importantly a lot of .NET project consider stored procedures to be a best practice. Since day one, iBATIS has supported stored procedures as a first class feature. While ORM tools may be "compatible", they certainly weren't designed with that as a primary goal. In fact, it doesn't even make a lot of sense to map a representation of state (a class) to a behavior (a function or procedure). iBATIS handles this by design, as a core consideration. One reason you might not see a lot of activity on the development side for .NET is that it was more feature rich than iBATIS for Java out of the gate. Gilles did a great job porting the framework, but also introducing a number of new features that iBATIS for Java still doesn't have. So naturally, for the last while you've probably only seen bug fixes and the odd feature. =20 In my opinion, this is a great success of iBATIS. Our software has survived the test of time and continues to be chosen over the competition with very few changes. We aren't running a race or trying to keep up with any artificial specifications. We just continue to do what we do, and do it well. =20 That said, both Gilles and I (and the rest of the team) are working on version 3 of the .NET and Java versions respectively. With the introduction of C# 3 and with greater adoption of Java 5 (finally), we are now able to leverage some of the cool new features they offer. =20 So worry not. iBATIS has been around for 6 years now, it's not going anywhere. :-) Cheers, Clinton On Fri, May 30, 2008 at 7:52 AM, Sal Bass <kwalker@example.com> wrote: =20 I was just wondering when we can expect the next major release of Ibatis.NET? I was also curious to know if there is a definite future for Ibatis.NET, as it seems development is much more active on the Java front. I want to bring Ibatis into our organization, but the CTO has concerns on whether .NET releases will be supported and active for the foreseeable future.=20 ________________________________ E-mail for the greater good. Join the i'm Initiative from Microsoft. <http://im.live.com/Messenger/IM/Join/Default.aspx?source=3DEML_WL_+Great= e rGood>=20 ------_=_NextPart_001_01C8C59B.7A89EFD0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.6000.16640" name=3DGENERATOR></HEAD> <BODY> <DIV dir=3Dltr align=3Dleft><SPAN class=3D274550017-03062008><FONT = face=3DArial=20 color=3D#0000ff size=3D2>Thats very good to hear as we are in the midst = of a=20 largescale migration from 'homegrown' to iBatis.net</FONT></SPAN></DIV> <DIV dir=3Dltr align=3Dleft><SPAN = class=3D274550017-03062008></SPAN>&nbsp;</DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D274550017-03062008><FONT = face=3DArial=20 color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV><BR> <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft> <HR tabIndex=3D-1> <FONT face=3DTahoma size=3D2><B>From:</B> Clinton Begin=20 [mailto:kwalker@example.com] <BR><B>Sent:</B> Friday, May 30, 2008 = 7:48=20 AM<BR><B>To:</B> kwalker@example.com<BR><B>Subject:</B> Re: Next=20 Release?<BR></FONT><BR></DIV> <DIV></DIV>Hi Sal,<BR><BR>I'm the lead developer of iBATIS for Java and = the=20 original creator of iBATIS.&nbsp; <BR><BR>I don't think you have = anything to=20 worry about, as I believe that iBATIS.NET has a bright future and will = possibly=20 even surpass the success we've seen on the Java side.&nbsp; iBATIS for = Java has=20 a lot more competition with products like Hibernate and Spring JDBC as = serious=20 competitors.&nbsp; Furthermore, Java application best practices are more = compatible with typical ORM solutions like Hibernate.<BR><BR>In the .NET = world,=20 there are very few ORM options (NHibernate, LINQ to SQL...), but more=20 importantly a lot of .NET project consider stored procedures to be a = best=20 practice.&nbsp; Since day one, iBATIS has supported stored procedures as = a first=20 class feature.&nbsp; While ORM tools may be "compatible", they certainly = weren't=20 designed with that as a primary goal.&nbsp; In fact, it doesn't even = make a lot=20 of sense to map a representation of state (a class) to a behavior (a = function or=20 procedure).&nbsp; iBATIS handles this by design, as a core=20 consideration.<BR><BR>One reason you might not see a lot of activity on = the=20 development side for .NET is that it was more feature rich than iBATIS = for Java=20 out of the gate.&nbsp; Gilles did a great job porting the framework, but = also=20 introducing a number of new features that&nbsp; iBATIS for Java still = doesn't=20 have.&nbsp; So naturally, for the last while you've probably only seen = bug fixes=20 and the odd feature.&nbsp; <BR><BR>In my opinion, this is a great = success of=20 iBATIS.&nbsp; Our software has survived the test of time and continues = to be=20 chosen over the competition with very few changes.&nbsp; We aren't = running a=20 race or trying to keep up with any artificial specifications.&nbsp; We = just=20 continue to do what we do, and do it well.&nbsp; <BR><BR>That said, both = Gilles=20 and I (and the rest of the team) are working on version 3 of the .NET = and Java=20 versions respectively.&nbsp; With the introduction of C# 3 and with = greater=20 adoption of Java 5 (finally), we are now able to leverage some of the = cool new=20 features they offer.&nbsp; <BR><BR>So worry not.&nbsp; iBATIS has been = around=20 for 6 years now, it's not going anywhere.&nbsp;=20 :-)<BR><BR>Cheers,<BR>Clinton<BR><BR> <DIV class=3Dgmail_quote>On Fri, May 30, 2008 at 7:52 AM, Sal Bass = &lt;<A=20 href=3D"mailto:kwalker@example.com">kwalker@example.com</A>&gt; = wrote:<BR> <BLOCKQUOTE class=3Dgmail_quote=20 style=3D"PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: = rgb(204,204,204) 1px solid"> <DIV> <P style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial"><FONT=20 color=3D#000000></FONT></SPAN>&nbsp;</P> <P style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial"><FONT face=3D"" = color=3D#000000>I was=20 just wondering when we can expect the next major release of = Ibatis.NET? I was=20 also curious to know if there is a definite future for Ibatis.NET, as = it seems=20 development is much more active on the Java front. I want to bring = Ibatis into=20 our organization, but the CTO has concerns on whether .NET releases = will be=20 supported and active for the foreseeable future. = </FONT></SPAN></P><BR> <HR> E-mail for the greater good. <A=20 = href=3D"http://im.live.com/Messenger/IM/Join/Default.aspx?source=3DEML_WL= _+GreaterGood"=20 target=3D_blank>Join the i'm Initiative from=20 Microsoft.</A></DIV></BLOCKQUOTE></DIV><BR></BODY></HTML> ------_=_NextPart_001_01C8C59B.7A89EFD0-- From userkwalker@example.com Sat Jun 07 20:51:02 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 89913 invoked from network); 7 Jun 2008 20:51:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 7 Jun 2008 20:51:01 -0000 Received: (qmail 4837 invoked by uid 500); 7 Jun 2008 20:51:04 -0000 Delivered-To: kwalker@example.com Received: (qmail 4825 invoked by uid 500); 7 Jun 2008 20:51:03 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 4814 invoked by uid 99); 7 Jun 2008 20:51:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Jun 2008 13:51:03 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO web30505.mail.mud.yahoo.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with SMTP; Sat, 07 Jun 2008 20:50:06 +0000 Received: (qmail 53750 invoked by uid 60001); 7 Jun 2008 20:50:26 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=QIBFpwoaBQlvHElU6De3dPXgeVYTJf56/erjKABf42INBGqhZaBWiHNZ4pR2pohvnZWF6bbpLixqpv31wLXYY7+w5z540ee25Z8AQhfOfqmdHQV1a4t+oh+qb0rfnl8LrvQwtStiSr5NNqqI20wsFkndhkISN6v4o2Pd6pX/c50=; Received: from [83.161.120.155] by web30505.mail.mud.yahoo.com via HTTP; Sat, 07 Jun 2008 13:50:26 PDT X-Mailer: YahooMailRC/975.41 YahooMailWebService/0.7.199 Date: Sat, 7 Jun 2008 13:50:26 -0700 (PDT) From: Ron Grabowski <kwalker@example.com> Subject: Extending DataMapper from V3 to add support QueryForDataSet To: kwalker@example.com MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <kwalker@example.com> X-Virus-Checked: Checked by ClamAV on apache.org Here's an example of extending the DataMapper from V3 to add a QueryForDataSet method: http://www.ronosaurus.com/IBatisNet/DataSetDataMapper.cs.txt DataRow doesn't have a public constructor so I used a Hashtable in the resultClass of the resultMap then wrote a small adapter class to redirect the call to IDictionary.Add to the indexer of the DataRow: public override void Add(object key, object value) { dataRow[(string)key] = value; } I needed DataSet support because I'm porting some old code that calls stored procedures which return multiple result sets as a single DataSet. The tricky part about a DataSet is that it can only contain DataTables and the DataTables can only contain DataRows; those classes don't implement any common interfaces like IList or IDictionary. There might be a few bugs still left in it. Maybe we could add a generic protected Query method to DataMapper (as well as a corresponding generic Execute method on IMappedStatement) to make extensions easier. I shouldn't have to worry how the RequestScope is made or how an ISession is created if I want to write a simple extension: public DataSet QueryForDataSet(string statementId, object parameter) { // this method doesn't exist yet return base.Query<DataSet>(dataSetQuery, statementId, parameter); } private DataSet dataSetQuery(RequestScope request, ISession session, object parameterObject) { using (IDbCommand command = request.IDbCommand) { // snip } } - Ron From userkwalker@example.com Sat Jun 07 21:12:44 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 95817 invoked from network); 7 Jun 2008 21:12:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 7 Jun 2008 21:12:44 -0000 Received: (qmail 11664 invoked by uid 500); 7 Jun 2008 21:12:47 -0000 Delivered-To: kwalker@example.com Received: (qmail 11649 invoked by uid 500); 7 Jun 2008 21:12:47 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 11638 invoked by uid 99); 7 Jun 2008 21:12:47 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Jun 2008 14:12:47 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kwalker@example.com designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO an-out-0708.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Jun 2008 21:11:58 +0000 Received: by an-out-0708.google.com with SMTP id d26so355373and.110 for <kwalker@example.com>; Sat, 07 Jun 2008 14:12:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=DVr9FMApEcouBzXYDxcWskgiq3xY96sAc3X67Ivvwtg=; b=X3Tg2+IPz3OQvUkfMf2WfQTfKchLYgSj6ZD1kaAvTNBBz/pla6pkl0Tx5DbpJZALoI jxDogjriZ/lQXziSJ542Gs2OAYSEdrYR5c9TVdRhw2H2jvV1wycDU7txUFZ2gQtBsEWm FqQLlhWeSUTij3OvRYvftgy8DTweJaEz7yapI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=F3waEkfaUoAG2HZm+cEMt4RNhnbbWopkDD1+0faEvpB1S1rcfKTZFelY50MD4ko/Zy XetVaRBQD3MHUtCK5Ecn2+CqRVBYVYezeQSVySuF3qSDjkQhvYA2gqR8/xBTD+EOsOkE OkQ48iY+QhkD+1A19Vu7BUbfc3XLT+b7lbB9U= Received: by 83.161.120.155 with SMTP id 11mr1846723anj.94.1212873134679; Sat, 07 Jun 2008 14:12:14 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Sat, 7 Jun 2008 14:12:14 -0700 (PDT) Message-ID: <kwalker@example.com> Date: Sat, 7 Jun 2008 23:12:14 +0200 From: "Gilles Bayon" <kwalker@example.com> To: kwalker@example.com Subject: Re: Extending DataMapper from V3 to add support QueryForDataSet In-Reply-To: <kwalker@example.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13990_1184898.1212873134646" References: <kwalker@example.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_13990_1184898.1212873134646 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I will think of that Did you know that you can do this <select id="GetMultipleResultMap" resultMap="account-result, Category-result"> select Account_ID, Account_FirstName, Account_LastName, Account_Email, Account_Banner_Option, Account_Cart_Option from Accounts where Account_ID = 1; select Category_ID, Category_Name, Category_Guid from Categories where Category_ID = 1 </select> -- Cheers, Gilles ------=_Part_13990_1184898.1212873134646 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I will think of that<br>Did you know that you can do this<br><br>&nbsp;&nbsp;&nbsp; &lt;select id=&quot;GetMultipleResultMap&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; resultMap=&quot;account-result, Category-result&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_ID,<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_FirstName,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_LastName,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_Email,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_Banner_Option,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_Cart_Option<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from Accounts<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where Account_ID = 1;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Category_ID,<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Category_Name,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Category_Guid<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from Categories<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where Category_ID = 1<br>&nbsp;&nbsp;&nbsp; &lt;/select&gt;<br><br><br>-- <br>Cheers,<br>Gilles<br><br> ------=_Part_13990_1184898.1212873134646-- From userkwalker@example.com Sun Jun 08 05:50:11 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 99525 invoked from network); 8 Jun 2008 05:50:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 8 Jun 2008 05:50:11 -0000 Received: (qmail 53949 invoked by uid 500); 8 Jun 2008 05:50:12 -0000 Delivered-To: kwalker@example.com Received: (qmail 53939 invoked by uid 500); 8 Jun 2008 05:50:12 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 53928 invoked by uid 99); 8 Jun 2008 05:50:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Jun 2008 22:50:12 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO web30505.mail.mud.yahoo.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with SMTP; Sun, 08 Jun 2008 05:49:22 +0000 Received: (qmail 20866 invoked by uid 60001); 8 Jun 2008 05:49:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=FcR1dA1SyRKtMml4hco7P9maVJopqKBFeKMUubqrsa+in/JnNCEujfLH3lT4kpO9t9ovv/ai6pmpjCA6QYP2nvow89bE/km3ux/Xdo8FdBBKS0FySTAzzAf5liILwfBcB6PB57YasJoMslOd9F1wDzs8/CiO+jwn3XHMvO/HTrI=; Received: from [83.161.120.155] by web30505.mail.mud.yahoo.com via HTTP; Sat, 07 Jun 2008 22:49:37 PDT X-Mailer: YahooMailRC/975.41 YahooMailWebService/0.7.199 Date: Sat, 7 Jun 2008 22:49:37 -0700 (PDT) From: Ron Grabowski <kwalker@example.com> Subject: Re: Extending DataMapper from V3 to add support QueryForDataSet To: kwalker@example.com MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1774450221-1212904177=:20829" Message-ID: <kwalker@example.com> X-Virus-Checked: Checked by ClamAV on apache.org --0-1774450221-1212904177=:20829 Content-Type: text/plain; charset=us-ascii My code should handle that. Its suppose to put each result set in its own DataTable. I don't think its extremely important that we provide that Query<T> overload...I doubt many people will be extending the DataMapper class. If they do, they can just follow a pattern similar to what I did. ----- Original Message ---- From: Gilles Bayon <kwalker@example.com> To: kwalker@example.com Sent: Saturday, June 7, 2008 5:12:14 PM Subject: Re: Extending DataMapper from V3 to add support QueryForDataSet I will think of that Did you know that you can do this <select id="GetMultipleResultMap" resultMap="account-result, Category-result"> select Account_ID, Account_FirstName, Account_LastName, Account_Email, Account_Banner_Option, Account_Cart_Option from Accounts where Account_ID = 1; select Category_ID, Category_Name, Category_Guid from Categories where Category_ID = 1 </select> -- Cheers, Gilles --0-1774450221-1212904177=:20829 Content-Type: text/html; charset=us-ascii <html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">My code should handle that. Its suppose to put each result set in its own DataTable. I don't think its extremely important that we provide that Query&lt;T&gt; overload...I doubt many people will be extending the DataMapper class. If they do, they can just follow a pattern similar to what I did.<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Gilles Bayon &lt;kwalker@example.com&gt;<br>To: kwalker@example.com<br>Sent: Saturday, June 7, 2008 5:12:14 PM<br>Subject: Re: Extending DataMapper from V3 to add support QueryForDataSet<br><br>I will think of that<br>Did you know that you can do this<br><br>&nbsp;&nbsp;&nbsp; &lt;select id="GetMultipleResultMap"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; resultMap="account-result, Category-result"&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_ID,<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_FirstName,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_LastName,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_Email,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_Banner_Option,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account_Cart_Option<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from Accounts<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where Account_ID = 1;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Category_ID,<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Category_Name,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Category_Guid<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from Categories<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where Category_ID = 1<br>&nbsp;&nbsp;&nbsp; &lt;/select&gt;<br><br><br>-- <br>Cheers,<br>Gilles<br><br></div></div></div></body></html> --0-1774450221-1212904177=:20829-- From userkwalker@example.com Tue Jun 10 18:47:59 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 70710 invoked from network); 10 Jun 2008 18:47:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 10 Jun 2008 18:47:58 -0000 Received: (qmail 77601 invoked by uid 500); 10 Jun 2008 18:48:00 -0000 Delivered-To: kwalker@example.com Received: (qmail 77584 invoked by uid 500); 10 Jun 2008 18:48:00 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 77573 invoked by uid 99); 10 Jun 2008 18:48:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Jun 2008 11:48:00 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kwalker@example.com designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO wf-out-1314.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Jun 2008 18:47:08 +0000 Received: by wf-out-1314.google.com with SMTP id 28so2664529wff.27 for <kwalker@example.com>; Tue, 10 Jun 2008 11:47:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=Y/n/Ck/NS41WM5aeZaNLCK6jhKcpV/Uy93mSWVaaoNU=; b=RqpLJCWBh5wmsesJ7tPnZsoGQbmqRMeEtO4tfCl0kUdrB0vc+/W37CRukhaYZiVcLs VZ3BWg4X6OpeiAeFwjHnd5w285JN4zhL1FIAV270eoTo6GYnLvFedtpQUzX5lCVh6o7I dPbC1crsWxxRKdCZhZmWnnM74RGATxW0wdgbc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=ZPuiJDx4mZuvPAQsF71ECsSmFzMyGHEAfomamKJdvHSXhoA+sMr7yXpwkfdigNuhGK 9POeWY/IeSeg9b/BByLchp4z1WdG2xCaNbnTaw510JbhoJLHa9T4ZXdRYHDa1rbY/JvS R2t4Y47NMDEWzdWAKaLCwBoLThkFJ08TwqrM0= Received: by 83.161.120.155 with SMTP id v14mr2207004wfv.133.1213123645951; Tue, 10 Jun 2008 11:47:25 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Tue, 10 Jun 2008 11:47:25 -0700 (PDT) Message-ID: <kwalker@example.com> Date: Tue, 10 Jun 2008 20:47:25 +0200 From: "Gilles Bayon" <kwalker@example.com> To: kwalker@example.com, kwalker@example.com, kwalker@example.com Subject: [OT] Crosspost: LinkedIn iBATIS Group MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17431_14965290.1213123645938" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_17431_14965290.1213123645938 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all, Just a note to let you know that there is a LinkedIn group created for iBATIS. It should not replace the mailing list for: A) User support B) Developer discussions C) Bug reports Joining will allow you to find and contact other members on LinkedIn that used iBATIS and show your interests in iBATIS. The goal of this group is to help members: * Reach other users of iBATIS * Accelerate careers/business through referrals from iBATIS * View rich professional profiles from fellow iBATIS Group members Here's the link to join: ***http://www.linkedin.com/e/gis/118639/51B76D0678EE *This group is currently administrated by me and Clinton. Hope to see you in the group, Cheers -Gilles ------=_Part_17431_14965290.1213123645938 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all,<br><br>Just a note to let you know that there is a LinkedIn group created for iBATIS.<br><br>It should not replace the mailing list for:<br><br>A) User support<br>B) Developer discussions<br>C) Bug reports<br><br>Joining will allow you to find and contact other members on LinkedIn that used<br> iBATIS and show your interests in iBATIS. <br><br>The goal of this group is to help members:<br><br>&nbsp;&nbsp;&nbsp; * Reach other users of iBATIS<br>&nbsp;&nbsp;&nbsp; * Accelerate careers/business through referrals from iBATIS<br>&nbsp;&nbsp;&nbsp; * View rich professional profiles from fellow iBATIS Group members<br> <br>Here's the link to join:<br><br><strong></strong><strong><a href="http://www.linkedin.com/e/gis/118639/51B76D0678EE">http://www.linkedin.com/e/gis/118639/51B76D0678EE</a><br><br></strong>This group is currently administrated by me and Clinton.<br> <br>Hope to see you in the group,<br><br>Cheers<br>-Gilles<br> ------=_Part_17431_14965290.1213123645938-- From userkwalker@example.com Thu Jun 12 21:47:04 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 50367 invoked from network); 12 Jun 2008 21:47:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 12 Jun 2008 21:47:04 -0000 Received: (qmail 36122 invoked by uid 500); 12 Jun 2008 21:47:06 -0000 Delivered-To: kwalker@example.com Received: (qmail 36093 invoked by uid 500); 12 Jun 2008 21:47:06 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 36082 invoked by uid 99); 12 Jun 2008 21:47:06 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jun 2008 14:47:06 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kwalker@example.com designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO rv-out-0708.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jun 2008 21:46:17 +0000 Received: by rv-out-0708.google.com with SMTP id b17so3545848rvf.36 for <kwalker@example.com>; Thu, 12 Jun 2008 14:46:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=pena9F2k1b9o7DiJfCjYxucY+ejKj88rzIssw6rCbds=; b=awnILBCzx/uvDbnjTk9Tbpgj9i7iKFsvNIjC3RHiOe89HcYjTRDXOjC9/ZZCm5LVlT Cohox0aKogvNbzpM6A82jQI11tolxEvI0/OriUk9c5IQMn9bnPo+kvYs/lG/7RjaGC/b V6ilWsL9fd5kfkTh/Y3IP9Q9EcJO4IyMtAMAA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=LuMskJrb5C9jEtXaDutJiVGXnTNgd5uDg4Vb0lswGfKMgxbXnzRvWjLnaQvz8bz6Fs W+CCs8b8II6nusFkRhXG/7lAS7u+WKsoJuN5bZXmIwkc9CPkhg7fq7CRK8B0xIQaXioi PRBLMU2hQbkSG2eP1QBMPMdY1FBZrNDKu1YHE= Received: by 83.161.120.155 with SMTP id s2mr2293088wae.170.1213307194810; Thu, 12 Jun 2008 14:46:34 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Thu, 12 Jun 2008 14:46:34 -0700 (PDT) Message-ID: <kwalker@example.com> Date: Thu, 12 Jun 2008 16:46:34 -0500 From: "Michael Schall" <kwalker@example.com> To: kwalker@example.com Subject: Multiple ResultMap Support MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_36486_5171186.1213307194822" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_36486_5171186.1213307194822 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I'm trying to use the multiple resultset support in one of my maps. I only receive one list of objects back. I expected a list of lists back. Is the following supported somehow? If not I suppose I could loop through and split the list by type myself. Thanks Mike <select id="GetMultipleResultMap" resultMap="account, category"> select * from accounts select * from categories </select> IList list = sqlMap.QueryForList("GetMultipleResultMap", null); IList<Account> accountList = list[0]; IList<Category> categoryList = list[1]; ------=_Part_36486_5171186.1213307194822 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline <p>I&#39;m trying to use the multiple resultset support in one of my maps. &nbsp;I only receive one list of objects back. &nbsp;I expected a list of lists back. &nbsp;Is the following supported somehow? &nbsp;If not I suppose I could loop through and split the list by type myself. &nbsp;</p> <p>Thanks&nbsp;</p><p>Mike</p><p>&lt;select id=&quot;GetMultipleResultMap&quot; resultMap=&quot;account, category&quot;&gt;</p><p>select * from accounts</p><p>select * from categories</p><p>&lt;/select&gt;</p><p>IList list = sqlMap.QueryForList(&quot;GetMultipleResultMap&quot;, null);</p> <p>IList&lt;Account&gt; accountList = list[0];<br><br>IList&lt;Category&gt; categoryList = list[1];<br><br><br></p> ------=_Part_36486_5171186.1213307194822-- From userkwalker@example.com Thu Jun 12 22:08:51 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 59558 invoked from network); 12 Jun 2008 22:08:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 12 Jun 2008 22:08:51 -0000 Received: (qmail 66614 invoked by uid 500); 12 Jun 2008 22:08:53 -0000 Delivered-To: kwalker@example.com Received: (qmail 66600 invoked by uid 500); 12 Jun 2008 22:08:53 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 66589 invoked by uid 99); 12 Jun 2008 22:08:53 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jun 2008 15:08:53 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO web30507.mail.mud.yahoo.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 12 Jun 2008 22:08:03 +0000 Received: (qmail 31433 invoked by uid 60001); 12 Jun 2008 22:08:19 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=P/l+jbr+fj7BdPtlxxvx0kj7v8UoO82zMl+Thaxk1bNdtqxHwZhYJg+l57xgvhsspOoKG+c3q9UeUQ7w038oGS5fouS5kbMxELEGNBv2+w9tOGhqzSH9wgjLdlAVM5w07bkkbf9IZu5eR9DBoveVuQz9tcIVLDQliULSXyB0jzU=; Received: from [83.161.120.155] by web30507.mail.mud.yahoo.com via HTTP; Thu, 12 Jun 2008 15:08:18 PDT X-Mailer: YahooMailRC/975.45 YahooMailWebService/0.7.199 Date: Thu, 12 Jun 2008 15:08:18 -0700 (PDT) From: Ron Grabowski <kwalker@example.com> Subject: Re: Multiple ResultMap Support To: kwalker@example.com MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1852398687-1213308498=:30578" Message-ID: <{{EMAIL+PHONE}}> X-Virus-Checked: Checked by ClamAV on apache.org --0-1852398687-1213308498=:30578 Content-Type: text/plain; charset=us-ascii Try putting a semi-colon after the first select? ----- Original Message ---- From: Michael Schall <kwalker@example.com> To: kwalker@example.com Sent: Thursday, June 12, 2008 5:46:34 PM Subject: Multiple ResultMap Support I'm trying to use the multiple resultset support in one of my maps. I only receive one list of objects back. I expected a list of lists back. Is the following supported somehow? If not I suppose I could loop through and split the list by type myself. Thanks Mike <select id="GetMultipleResultMap" resultMap="account, category"> select * from accounts select * from categories </select> IList list = sqlMap.QueryForList("GetMultipleResultMap", null); IList<Account> accountList = list[0]; IList<Category> categoryList = list[1]; --0-1852398687-1213308498=:30578 Content-Type: text/html; charset=us-ascii <html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">Try putting a semi-colon after the first select?<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Michael Schall &lt;kwalker@example.com&gt;<br>To: kwalker@example.com<br>Sent: Thursday, June 12, 2008 5:46:34 PM<br>Subject: Multiple ResultMap Support<br><br><p>I'm trying to use the multiple resultset support in one of my maps. &nbsp;I only receive one list of objects back. &nbsp;I expected a list of lists back. &nbsp;Is the following supported somehow? &nbsp;If not I suppose I could loop through and split the list by type myself. &nbsp;</p> <p>Thanks&nbsp;</p><p>Mike</p><p>&lt;select id="GetMultipleResultMap" resultMap="account, category"&gt;</p><p>select * from accounts</p><p>select * from categories</p><p>&lt;/select&gt;</p><p>IList list = sqlMap.QueryForList("GetMultipleResultMap", null);</p> <p>IList&lt;Account&gt; accountList = list[0];<br><br>IList&lt;Category&gt; categoryList = list[1];<br><br><br></p> </div></div></div></body></html> --0-1852398687-1213308498=:30578-- From userkwalker@example.com Fri Jun 13 02:18:05 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 98824 invoked from network); 13 Jun 2008 02:18:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 13 Jun 2008 02:18:05 -0000 Received: (qmail 90768 invoked by uid 500); 13 Jun 2008 02:18:07 -0000 Delivered-To: kwalker@example.com Received: (qmail 90754 invoked by uid 500); 13 Jun 2008 02:18:07 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 90743 invoked by uid 99); 13 Jun 2008 02:18:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jun 2008 19:18:07 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kwalker@example.com designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO rv-out-0708.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jun 2008 02:17:18 +0000 Received: by rv-out-0708.google.com with SMTP id b17so3615918rvf.36 for <kwalker@example.com>; Thu, 12 Jun 2008 19:17:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=zxqdDWFAMFVKZOArAIhbLu7lNWKQgKhKUalUuG5MIu4=; b=dD3bYomGOxuo4XVdl62O6oTaSLAtEaYCaToOS3E0/lEjm/vln8QwQZfWJNkeGGAxT4 AYpDCStNl5/WA7IVZwMNoV2iCXj1qDSqQbj3pXbu5eRUuOj1A+iBtv0f38NKxrxzVPK2 HIzmyoVozrgQ+HaH998qkI9s353UX6sOL5sNk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=POT64ieejOZxGtzWdKqe+9TVG9v+0YOi2frfiJAvVd3UmKyHae7w6ob7gt7pkgS/uf Xc8NrC9pnzfMuVcTGw9nlCbfaAhRJsLZZsc54F5hWiV2gqQpxmAmA3H5pN3ViakScGk9 FMVKFhUlF6wplOgmqQWYfPEcCcqDTiqQysQgM= Received: by 83.161.120.155 with SMTP id f20mr2481906wag.147.1213323453578; Thu, 12 Jun 2008 19:17:33 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Thu, 12 Jun 2008 19:17:33 -0700 (PDT) Message-ID: <kwalker@example.com> Date: Thu, 12 Jun 2008 21:17:33 -0500 From: "Michael Schall" <kwalker@example.com> To: kwalker@example.com Subject: Re: Multiple ResultMap Support In-Reply-To: <{{EMAIL+PHONE}}> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_37324_2222196.1213323453561" References: <{{EMAIL+PHONE}}> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_37324_2222196.1213323453561 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry, I should have been more specific. I think my sql is fine. I'm getting two resultsets back from sql server, but only one from queryForList. The list that comes back has both accounts and categories objects in it rather than a list with two elements ( a list of accounts and a list of categories). Looking at the code, a single arraylist is created outside the loop of resultsets and then all the objects from both sql resultsets are added to the same list. Mike On 6/12/08, Ron Grabowski <kwalker@example.com> wrote: > > Try putting a semi-colon after the first select? > > ----- Original Message ---- > From: Michael Schall <kwalker@example.com> > To: kwalker@example.com > Sent: Thursday, June 12, 2008 5:46:34 PM > Subject: Multiple ResultMap Support > > I'm trying to use the multiple resultset support in one of my maps. I only > receive one list of objects back. I expected a list of lists back. Is the > following supported somehow? If not I suppose I could loop through and > split the list by type myself. > > Thanks > > Mike > > <select id="GetMultipleResultMap" resultMap="account, category"> > > select * from accounts > > select * from categories > > </select> > > IList list = sqlMap.QueryForList("GetMultipleResultMap", null); > > IList<Account> accountList = list[0]; > > IList<Category> categoryList = list[1]; > > > ------=_Part_37324_2222196.1213323453561 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline <p>Sorry, I should have been more specific. &nbsp;I think my sql is fine. &nbsp;I&#39;m getting two resultsets back from sql server, but only one from queryForList. &nbsp;The list that comes back has both accounts and categories objects in it rather than a list with two elements ( a list of accounts and a list of categories). &nbsp;Looking at the code, a single arraylist is created outside the loop of resultsets and then all the objects from both sql resultsets are added to the same list.</p> <p>Mike<br></p><br><div><span class="gmail_quote">On 6/12/08, <b class="gmail_sendername">Ron Grabowski</b> &lt;<a href="mailto:kwalker@example.com">kwalker@example.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex"> <div><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family:times new roman,new york,times,serif;font-size:12pt">Try putting a semi-colon after the first select?<div><span class="e" id="q_11a7ed2f4af62c17_1"><br> <br><div style="font-family:times new roman,new york,times,serif;font-size:12pt">----- Original Message ----<br>From: Michael Schall &lt;<a href="mailto:kwalker@example.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">kwalker@example.com</a>&gt;<br> To: <a href="mailto:kwalker@example.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">kwalker@example.com</a><br>Sent: Thursday, June 12, 2008 5:46:34 PM<br>Subject: Multiple ResultMap Support<br> <br><p>I&#39;m trying to use the multiple resultset support in one of my maps. &nbsp;I only receive one list of objects back. &nbsp;I expected a list of lists back. &nbsp;Is the following supported somehow? &nbsp;If not I suppose I could loop through and split the list by type myself. &nbsp;</p> <p>Thanks&nbsp;</p><p>Mike</p><p>&lt;select id=&quot;GetMultipleResultMap&quot; resultMap=&quot;account, category&quot;&gt;</p><p>select * from accounts</p><p>select * from categories</p><p>&lt;/select&gt;</p><p>IList list = sqlMap.QueryForList(&quot;GetMultipleResultMap&quot;, null);</p> <p>IList&lt;Account&gt; accountList = list[0];<br><br>IList&lt;Category&gt; categoryList = list[1];<br><br><br></p> </div></span></div></div></div></div></blockquote></div><br> ------=_Part_37324_2222196.1213323453561-- From userkwalker@example.com Fri Jun 13 05:26:49 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 59051 invoked from network); 13 Jun 2008 05:26:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 13 Jun 2008 05:26:49 -0000 Received: (qmail 10890 invoked by uid 500); 13 Jun 2008 05:26:51 -0000 Delivered-To: kwalker@example.com Received: (qmail 10639 invoked by uid 500); 13 Jun 2008 05:26:50 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 10627 invoked by uid 99); 13 Jun 2008 05:26:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jun 2008 22:26:50 -0700 X-ASF-Spam-Status: No, hits=-1.4 required=10.0 tests=HTML_FONT_FACE_BAD,HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO ups.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jun 2008 05:25:59 +0000 Received: from ([83.161.120.155]) by tessa10.ups.com with ESMTP id 5503511.31037081; Fri, 13 Jun 2008 01:25:53 -0400 Received: from gaalpsvr021c.us.ups.com ([83.161.120.155]) by gaalpsvr0132.us.ups.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 13 Jun 2008 01:25:53 -0400 Received: from sgsitsvr0002.asiapac.ups.com ([83.161.120.155]) by gaalpsvr021c.us.ups.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 13 Jun 2008 01:25:53 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C8CD15.E76F6CBE" Subject: RE: Multiple ResultMap Support Date: Fri, 13 Jun 2008 13:25:34 +0800 Message-ID: <kwalker@example.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Multiple ResultMap Support Thread-Index: AcjM+9rOkVR2C/ULTTS/7tDBcBlRPAAGc7MA References: <{{EMAIL+PHONE}}> <kwalker@example.com> From: <kwalker@example.com> To: <kwalker@example.com> X-OriginalArrivalTime: 13 Jun 2008 05:25:53.0929 (UTC) FILETIME=[F3428790:01C8CD15] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01C8CD15.E76F6CBE Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Is there anyone who can help me out? when i run the ibatis tutorial sample. system throw out this exception. =20 thx =20 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.=20 Exception Details: IBatisNet.Common.Exceptions.ConfigurationException: Invalid SqlMap.config document. cause :The attribute targetNamespace does not match the designated namespace URI. An error occurred at file:///C:/WINNT/system32/SqlMapConfig.xsd, (2, 2). The 'sqlMapConfig' element is not declared. An error occurred at , (1, 2). The 'properties' element is not declared. An error occurred at , (3, 6). Could not find schema information for the attribute 'resource'. An error occurred at , (3, 17). The 'settings' element is not declared. An error occurred at , (5, 3). The 'setting' element is not declared. An error occurred at , (5, 13). Could not find schema information for the attribute 'useStatementNamespaces'. An error occurred at , (5, 21). The 'setting' element is not declared. An error occurred at , (5, 55). Could not find schema information for the attribute 'cacheModelsEnabled'. An error occurred at , (5, 63). The 'database' element is not declared. An error occurred at , (5, 103). The 'provider' element is not declared. An error occurred at , (5, 113). Could not find schema information for the attribute 'name'. An error occurred at , (5, 122). The 'dataSource' element is not declared. An error occurred at , (5, 144). Could not find schema information for the attribute 'name'. An error occurred at , (5, 155). Could not find schema information for the attribute 'connectionString'. An error occurred at , (5, 177). The 'sqlMaps' element is not declared. An error occurred at , (5, 230). The 'sqlMap' element is not declared. An error occurred at , (5, 239). Could not find schema information for the attribute 'resource'. An error occurred at , (5, 246).=20 ------_=_NextPart_001_01C8CD15.E76F6CBE Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.2900.3354" name=3DGENERATOR></HEAD> <BODY> <DIV dir=3Dltr align=3Dleft><FONT face=3D&#23435;&#20307; = size=3D2><STRONG><SPAN=20 class=3D362502305-13062008>Is there anyone who can help me out? when i = run the=20 ibatis tutorial sample. system throw out this=20 exception.</SPAN></STRONG></FONT></DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3D&#23435;&#20307; = size=3D2><STRONG><SPAN=20 class=3D362502305-13062008></SPAN></STRONG></FONT>&nbsp;</DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3D&#23435;&#20307; = size=3D2><STRONG><SPAN=20 class=3D362502305-13062008>thx</SPAN></STRONG></FONT></DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3D&#23435;&#20307; = size=3D2><STRONG><SPAN=20 class=3D362502305-13062008></SPAN></STRONG></FONT>&nbsp;</DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3D&#23435;&#20307; = size=3D2><STRONG>Description: </STRONG><FONT=20 face=3DArial>An unhandled exception occurred during the execution of the = current=20 web request. Please review the stack trace for more information about = the error=20 and where it originated in the code. <BR><BR></FONT><B>Exception = Details:=20 </B><FONT = face=3DArial>IBatisNet.Common.Exceptions.ConfigurationException: Invalid = SqlMap.config document. cause :The attribute targetNamespace does not = match the=20 designated namespace URI. An error occurred at=20 file:///C:/WINNT/system32/SqlMapConfig.xsd, (2, 2). The 'sqlMapConfig' = element=20 is not declared. An error occurred at , (1, 2). The 'properties' element = is not=20 declared. An error occurred at , (3, 6). Could not find schema = information for=20 the attribute 'resource'. An error occurred at , (3, 17). The 'settings' = element=20 is not declared. An error occurred at , (5, 3). The 'setting' element is = not=20 declared. An error occurred at , (5, 13). Could not find schema = information for=20 the attribute 'useStatementNamespaces'. An error occurred at , (5, 21). = The=20 'setting' element is not declared. An error occurred at , (5, 55). Could = not=20 find schema information for the attribute 'cacheModelsEnabled'. An error = occurred at , (5, 63). The 'database' element is not declared. An error = occurred=20 at , (5, 103). The 'provider' element is not declared. An error occurred = at ,=20 (5, 113). Could not find schema information for the attribute 'name'. An = error=20 occurred at , (5, 122). The 'dataSource' element is not declared. An = error=20 occurred at , (5, 144). Could not find schema information for the = attribute=20 'name'. An error occurred at , (5, 155). Could not find schema = information for=20 the attribute 'connectionString'. An error occurred at , (5, 177). The = 'sqlMaps'=20 element is not declared. An error occurred at , (5, 230). The 'sqlMap' = element=20 is not declared. An error occurred at , (5, 239). Could not find schema=20 information for the attribute 'resource'. An error occurred at , (5, = 246).=20 </FONT></FONT></DIV></BODY></HTML> ------_=_NextPart_001_01C8CD15.E76F6CBE-- From userkwalker@example.com Fri Jun 13 08:27:52 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 47558 invoked from network); 13 Jun 2008 08:27:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 13 Jun 2008 08:27:52 -0000 Received: (qmail 83460 invoked by uid 500); 13 Jun 2008 08:27:53 -0000 Delivered-To: kwalker@example.com Received: (qmail 83446 invoked by uid 500); 13 Jun 2008 08:27:53 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 83435 invoked by uid 99); 13 Jun 2008 08:27:53 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jun 2008 01:27:53 -0700 X-ASF-Spam-Status: No, hits=-1.4 required=10.0 tests=HTML_FONT_FACE_BAD,HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO ups.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jun 2008 08:27:02 +0000 Received: from ([83.161.120.155]) by magma10.ups.com with ESMTP id 5503509.29316830; Fri, 13 Jun 2008 04:25:37 -0400 Received: from gaalpsvr012e.us.ups.com ([83.161.120.155]) by gaalpsvr0131.us.ups.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 13 Jun 2008 04:25:37 -0400 Received: from sgsitsvr0002.asiapac.ups.com ([83.161.120.155]) by gaalpsvr012e.us.ups.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 13 Jun 2008 04:25:37 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----_=_NextPart_001_01C8CD2E.DABEC734" Subject: This SQL map does not contain an ResultMap named Address Result Date: Fri, 13 Jun 2008 16:24:10 +0800 Message-ID: <kwalker@example.com> X-MS-Has-Attach: yes X-MS-TNEF-Correlator: Thread-Topic: This SQL map does not contain an ResultMap named Address Result Thread-Index: AcjM+9rOkVR2C/ULTTS/7tDBcBlRPAAMrF4Q References: <{{EMAIL+PHONE}}> <kwalker@example.com> From: <kwalker@example.com> To: <kwalker@example.com> X-OriginalArrivalTime: 13 Jun 2008 08:25:37.0556 (UTC) FILETIME=[0ECD6D40:01C8CD2F] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01C8CD2E.DABEC734 Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C8CD2E.DABEC734" ------_=_NextPart_002_01C8CD2E.DABEC734 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi All, =20 I am just starting the IBatis.net by tailoring the tutorial sample. encountering one problem, program shows that: =20 This SQL map does not contain an ResultMap named Address Result=20 =20 ------_=_NextPart_002_01C8CD2E.DABEC734 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.2900.3354" name=3DGENERATOR></HEAD> <BODY> <DIV><FONT face=3D&#23435;&#20307;><FONT color=3D#0000ff><FONT = size=3D2><SPAN=20 class=3D610582108-13062008>Hi All,</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=3D&#23435;&#20307;><FONT color=3D#0000ff><FONT = size=3D2><SPAN=20 class=3D610582108-13062008></SPAN></FONT></FONT></FONT>&nbsp;</DIV> <DIV><FONT face=3D&#23435;&#20307;><FONT color=3D#0000ff><FONT = size=3D2><SPAN=20 class=3D610582108-13062008>I&nbsp;am just starting the = IBatis.net&nbsp;by=20 tailoring the&nbsp;tutorial sample. encountering one problem, program = shows=20 that:</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=3D&#23435;&#20307;><FONT color=3D#0000ff><FONT = size=3D2><SPAN=20 class=3D610582108-13062008>&nbsp;</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT><FONT><FONT face=3D&#23435;&#20307;><FONT = color=3D#0000ff><FONT size=3D2><SPAN=20 class=3D610582108-13062008>&nbsp;</SPAN>This SQL map does not contain an = ResultMap=20 named Address Result<SPAN=20 class=3D610582108-13062008>&nbsp;</SPAN></FONT></FONT></FONT></FONT></FON= T></DIV> <DIV><FONT><FONT><FONT face=3D&#23435;&#20307;><FONT = color=3D#0000ff><FONT size=3D2><SPAN=20 class=3D610582108-13062008>&nbsp;</SPAN></FONT></FONT></FONT></FONT></FON= T></DIV></BODY></HTML> ------_=_NextPart_002_01C8CD2E.DABEC734-- ------_=_NextPart_001_01C8CD2E.DABEC734 Content-Type: text/xml; name="Account.xml" Content-Transfer-Encoding: base64 Content-Description: Account.xml Content-Disposition: attachment; filename="Account.xml" PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiID8+DQoNCjxzcWxNYXAgDQoJbmFt ZXNwYWNlPSJTSUZNLkRvbWFpbiIgDQoJeG1sbnM9Imh0dHA6Ly9pYmF0aXMuYXBhY2hlLm9yZy9t YXBwaW5nIg0KCXhtbG5zOnhzaT0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEtaW5z dGFuY2UiPg0KDQoJPGFsaWFzPg0KCQk8dHlwZUFsaWFzIGFsaWFzPSJBY2NvdW50IiB0eXBlPSJT SUZNLkRvbWFpbi5BY2NvdW50ICxTSUZNIi8+DQoJCTx0eXBlQWxpYXMgYWxpYXM9IkFkZHJlc3Mi IHR5cGU9IlNJRk0uRG9tYWluLkFkZHJlc3MgLFNJRk0iIC8+DQoJCTx0eXBlQWxpYXMgYWxpYXM9 IlByb2ZpbGUiIHR5cGU9IlNJRk0uRG9tYWluLlByb2ZpbGUgLFNJRk0iIC8+CQkNCgk8L2FsaWFz Pg0KCQkgICAgICAgDQoJPHJlc3VsdE1hcHM+DQoJCTxyZXN1bHRNYXAgaWQ9IkFkZHJlc3NSZXN1 bHQiIGNsYXNzPSJBZGRyZXNzIj4NCgkJCTxyZXN1bHQgcHJvcGVydHk9IkZpcnN0TmFtZSIgY29s dW1uPSJBY2NvdW50X0ZpcnN0TmFtZSIvPg0KCQkJPHJlc3VsdCBwcm9wZXJ0eT0iTGFzdE5hbWUi IGNvbHVtbj0iQWNjb3VudF9MYXN0TmFtZSIvPg0KCQkJPHJlc3VsdCBwcm9wZXJ0eT0iQWRkcmVz czEiIGNvbHVtbj0iQWNjb3VudF9BZGRyMSIvPg0KCQkJPHJlc3VsdCBwcm9wZXJ0eT0iQWRkcmVz czIiIGNvbHVtbj0iQWNjb3VudF9BZGRyMiIvPg0KCQkJPHJlc3VsdCBwcm9wZXJ0eT0iQ2l0eSIg Y29sdW1uPSJBY2NvdW50X0NpdHkiLz4NCgkJCTxyZXN1bHQgcHJvcGVydHk9IlN0YXRlIiBjb2x1 bW49IkFjY291bnRfU3RhdGUiLz4NCgkJCTxyZXN1bHQgcHJvcGVydHk9IlppcCIgY29sdW1uPSJB Y2NvdW50X1ppcCIvPg0KCQkJPHJlc3VsdCBwcm9wZXJ0eT0iQ291bnRyeSIgY29sdW1uPSJBY2Nv dW50X0NvdW50cnkiLz4NCgkJCTxyZXN1bHQgcHJvcGVydHk9IlBob25lIiBjb2x1bW49IkFjY291 bnRfUGhvbmUiLz4NCgkJPC9yZXN1bHRNYXA+DQoJCTxyZXN1bHRNYXAgaWQ9IlByb2ZpbGVSZXN1 bHQiIGNsYXNzPSJQcm9maWxlIj4NCgkJCTxyZXN1bHQgcHJvcGVydHk9IkZhdm9yaXRlTGFuZ3Vh Z2UiIGNvbHVtbj0iUHJvZmlsZV9MYW5nUHJlZiIvPg0KCQkJPHJlc3VsdCBwcm9wZXJ0eT0iRmF2 b3VyaXRlQ2F0ZWdvcnkiIGNvbHVtbj0iUHJvZmlsZV9GYXZDYXRlZ29yeSIgc2VsZWN0PSJHZXRD YXRlZ29yeSIvPg0KCQkJPHJlc3VsdCBwcm9wZXJ0eT0iSXNTaG93RmF2b3JpdGVzIiBjb2x1bW49 IlByb2ZpbGVfTXlMaXN0T3B0Ii8+DQoJCQk8cmVzdWx0IHByb3BlcnR5PSJJc1Nob3dCYW5uZXJz IiBjb2x1bW49IlByb2ZpbGVfQmFubmVyT3B0Ii8+DQoJCTwvcmVzdWx0TWFwPg0KCQk8cmVzdWx0 TWFwIGlkPSJBY2NvdW50UmVzdWx0IiBjbGFzcz0iQWNjb3VudCI+DQoJCQk8cmVzdWx0IHByb3Bl cnR5PSJMb2dpbiIgY29sdW1uPSJBY2NvdW50X0lkIi8+DQoJCQk8cmVzdWx0IHByb3BlcnR5PSJQ YXNzd29yZCIgY29sdW1uPSJTaWduT25fUGFzc3dvcmQiLz4NCgkJCTxyZXN1bHQgcHJvcGVydHk9 IkVtYWlsIiBjb2x1bW49IkFjY291bnRfRW1haWwiLz4NCgkJCTxyZXN1bHQgcHJvcGVydHk9IlN0 YXR1cyIgY29sdW1uPSJBY2NvdW50X1N0YXR1cyIgLz4NCgkJCTxyZXN1bHQgcHJvcGVydHk9IkFk ZHJlc3MiIHJlc3VsdE1hcHBpbmc9IkFkZHJlc3NSZXN1bHQiIC8+DQoJCQk8cmVzdWx0IHByb3Bl cnR5PSJQcm9maWxlIiByZXN1bHRNYXBwaW5nPSJQcm9maWxlUmVzdWx0IiAvPg0KCQk8L3Jlc3Vs dE1hcD4JCQ0KCTwvcmVzdWx0TWFwcz4NCgk8IS0tID09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PQ0KICAgICAgICBNQVBQRUQgU1RBVEVNRU5UUyANCiAgICA9PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0gDQogICAgLS0+DQoJPHN0 YXRlbWVudHM+DQoJDQoJCTxpbnNlcnQgaWQ9Ikluc2VydEFjY291bnQiIHBhcmFtZXRlckNsYXNz PSJBY2NvdW50Ij4NCgkJCWluc2VydCBpbnRvIEFjY291bnRzIA0KCQkJKCBBY2NvdW50X0VtYWls LCBBY2NvdW50X0ZpcnN0TmFtZSwgQWNjb3VudF9MYXN0TmFtZSwgDQoJCQkgIEFjY291bnRfU3Rh dHVzLCBBY2NvdW50X0FkZHIxLCBBY2NvdW50X0FkZHIyLCBBY2NvdW50X0NpdHksIEFjY291bnRf U3RhdGUsIEFjY291bnRfWmlwLCANCgkJCSAgQWNjb3VudF9Db3VudHJ5LCBBY2NvdW50X1Bob25l LCBBY2NvdW50X0lkKQ0KCQkJdmFsdWVzIA0KCQkJKCAjRW1haWwjLCAjQWRkcmVzcy5GaXJzdE5h bWUjLCAjQWRkcmVzcy5MYXN0TmFtZSMsIA0KCQkJICAjU3RhdHVzIywgI0FkZHJlc3MuQWRkcmVz czEjLCAgI0FkZHJlc3MuQWRkcmVzczIjLCAjQWRkcmVzcy5DaXR5IywgI0FkZHJlc3MuU3RhdGUj LCANCgkJCSAgI0FkZHJlc3MuWmlwIywgI0FkZHJlc3MuQ291bnRyeSMsICNBZGRyZXNzLlBob25l IywgI0xvZ2luIykNCgkJPC9pbnNlcnQ+DQoJCQ0KCQk8dXBkYXRlIGlkPSJVcGRhdGVBY2NvdW50 IiBwYXJhbWV0ZXJDbGFzcz0iQWNjb3VudCI+DQoJCQl1cGRhdGUgQWNjb3VudHMgDQoJCQlzZXQg QWNjb3VudF9FbWFpbCA9ICNFbWFpbCMsIA0KCQkJQWNjb3VudF9GaXJzdE5hbWUgPSAjQWRkcmVz cy5GaXJzdE5hbWUjLCANCgkJCUFjY291bnRfTGFzdE5hbWUgPSAjQWRkcmVzcy5MYXN0TmFtZSMs DQoJCQlBY2NvdW50X1N0YXR1cyA9ICNTdGF0dXMjLCANCgkJCUFjY291bnRfQWRkcjEgPSAjQWRk cmVzcy5BZGRyZXNzMSMsICANCgkJCUFjY291bnRfQWRkcjIgPSAjQWRkcmVzcy5BZGRyZXNzMiMs ICANCgkJCUFjY291bnRfQ2l0eSA9ICNBZGRyZXNzLkNpdHkjLA0KCQkJQWNjb3VudF9TdGF0ZSA9 ICNBZGRyZXNzLlN0YXRlIywgDQoJCQlBY2NvdW50X1ppcCA9ICNBZGRyZXNzLlppcCMsIA0KCQkJ QWNjb3VudF9Db3VudHJ5ID0gI0FkZHJlc3MuQ291bnRyeSMsDQoJCQlBY2NvdW50X1Bob25lID0g I0FkZHJlc3MuUGhvbmUjIA0KCQkJd2hlcmUgQWNjb3VudF9JZCA9ICNMb2dpbiMNCgkJPC91cGRh dGU+DQogIA0KCQk8aW5zZXJ0IGlkPSJJbnNlcnRQcm9maWxlIiBwYXJhbWV0ZXJDbGFzcz0iQWNj b3VudCI+DQoJCQlpbnNlcnQgaW50byBQcm9maWxlcyANCgkJCQkoUHJvZmlsZV9MYW5nUHJlZiwg UHJvZmlsZV9GYXZDYXRlZ29yeSwgUHJvZmlsZV9NeUxpc3RPcHQsIFByb2ZpbGVfQmFubmVyT3B0 LCBBY2NvdW50X0lkKQ0KCQkJdmFsdWVzIA0KCQkJCSgjUHJvZmlsZS5GYXZvcml0ZUxhbmd1YWdl IywgI1Byb2ZpbGUuRmF2b3VyaXRlQ2F0ZWdvcnkuSWQjLCAjUHJvZmlsZS5Jc1Nob3dGYXZvcml0 ZXMjLCAjUHJvZmlsZS5Jc1Nob3dCYW5uZXJzIywgI0xvZ2luIykNCgkJPC9pbnNlcnQ+DQoJCQ0K CQk8dXBkYXRlIGlkPSJVcGRhdGVQcm9maWxlIiBwYXJhbWV0ZXJDbGFzcz0iQWNjb3VudCI+DQoJ CQl1cGRhdGUgUHJvZmlsZXMgDQoJCQlzZXQgUHJvZmlsZV9MYW5nUHJlZiA9ICNQcm9maWxlLkZh dm9yaXRlTGFuZ3VhZ2UjLCANCgkJCVByb2ZpbGVfRmF2Q2F0ZWdvcnkgPSAjUHJvZmlsZS5GYXZv dXJpdGVDYXRlZ29yeS5JZCMsDQoJCQlQcm9maWxlX015TGlzdE9wdCA9ICNQcm9maWxlLklzU2hv d0Zhdm9yaXRlcyMsIA0KCQkJUHJvZmlsZV9CYW5uZXJPcHQgPSAjUHJvZmlsZS5Jc1Nob3dCYW5u ZXJzIyANCgkJCXdoZXJlIEFjY291bnRfSWQgPSAjTG9naW4jDQoJCTwvdXBkYXRlPg0KICANCgkJ PGluc2VydCBpZD0iSW5zZXJ0U2lnbm9uIiBwYXJhbWV0ZXJDbGFzcz0iQWNjb3VudCI+DQoJCQlp bnNlcnQgaW50byBTaWduc09uDQoJCQkJKFNpZ25Pbl9QYXNzd29yZCwgQWNjb3VudF9JZCkgDQoJ CQl2YWx1ZXMgDQoJCQkJKCNQYXNzd29yZCMsICNMb2dpbiMpDQoJCTwvaW5zZXJ0PiAgDQoJCQ0K CQk8dXBkYXRlIGlkPSJVcGRhdGVTaWdub24iIHBhcmFtZXRlckNsYXNzPSJBY2NvdW50Ij4NCgkJ CXVwZGF0ZSBTaWduc09uIHNldCBTaWduT25fUGFzc3dvcmQgPSAjUGFzc3dvcmQjIHdoZXJlIEFj Y291bnRfSWQgPSAjTG9naW4jDQoJCTwvdXBkYXRlPg0KCQkJCQkNCgkJPHNlbGVjdCBpZD0iR2V0 QWNjb3VudEJ5TG9naW5BbmRQYXNzd29yZCIgcmVzdWx0TWFwPSJBY2NvdW50UmVzdWx0IiBwYXJh bWV0ZXJDbGFzcz0iQWNjb3VudCI+DQoJCQlzZWxlY3QNCgkJCQlTLkFjY291bnRfSWQsDQoJCQkJ U2lnbk9uX1Bhc3N3b3JkLA0KCQkJCUFjY291bnRfRW1haWwsDQoJCQkJQWNjb3VudF9GaXJzdE5h bWUsDQoJCQkJQWNjb3VudF9MYXN0TmFtZSwNCgkJCQlBY2NvdW50X1N0YXR1cywNCgkJCQlBY2Nv dW50X0FkZHIxLA0KCQkJCUFjY291bnRfQWRkcjIsDQoJCQkJQWNjb3VudF9DaXR5LA0KCQkJCUFj Y291bnRfU3RhdGUsDQoJCQkJQWNjb3VudF9aaXAsDQoJCQkJQWNjb3VudF9Db3VudHJ5LA0KCQkJ CUFjY291bnRfUGhvbmUsDQoJCQkJUHJvZmlsZV9MYW5nUHJlZiwNCgkJCQlQcm9maWxlX0ZhdkNh dGVnb3J5LA0KCQkJCVByb2ZpbGVfTXlMaXN0T3B0LA0KCQkJCVByb2ZpbGVfQmFubmVyT3B0DQoJ CQlmcm9tIEFjY291bnRzIGFzIEEsIFNpZ25zT24gYXMgUywgUHJvZmlsZXMgYXMgUA0KCQkJd2hl cmUgQS5BY2NvdW50X0lkID0gI0xvZ2luIw0KCQkJCWFuZCBTaWduT25fUGFzc3dvcmQgPSAjUGFz c3dvcmQjDQoJCQkJYW5kIFMuQWNjb3VudF9JZCA9IEEuQWNjb3VudF9JZA0KCQkJCWFuZCBQLkFj Y291bnRfSWQgPSBBLkFjY291bnRfSWQNCgkJPC9zZWxlY3Q+DQoJCQ0KCTwvc3RhdGVtZW50cz4N Cg0KCQ0KCQ0KPC9zcWxNYXA+ ------_=_NextPart_001_01C8CD2E.DABEC734-- From userkwalker@example.com Fri Jun 13 09:17:46 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 77306 invoked from network); 13 Jun 2008 09:17:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 13 Jun 2008 09:17:45 -0000 Received: (qmail 42255 invoked by uid 500); 13 Jun 2008 09:17:48 -0000 Delivered-To: kwalker@example.com Received: (qmail 42035 invoked by uid 500); 13 Jun 2008 09:17:47 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 42024 invoked by uid 99); 13 Jun 2008 09:17:47 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jun 2008 02:17:47 -0700 X-ASF-Spam-Status: No, hits=-1.4 required=10.0 tests=HTML_FONT_FACE_BAD,HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [83.161.120.155] (HELO ups.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jun 2008 09:16:56 +0000 Received: from ([83.161.120.155]) by tessa11.ups.com with ESMTP id 5503510.30949139; Fri, 13 Jun 2008 05:16:50 -0400 Received: from gaalpsvr012e.us.ups.com ([83.161.120.155]) by gaalpsvr021b.us.ups.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 13 Jun 2008 05:16:50 -0400 Received: from sgsitsvr0002.asiapac.ups.com ([83.161.120.155]) by gaalpsvr012e.us.ups.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 13 Jun 2008 05:16:50 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C8CD36.2711F74E" Subject: RE: This SQL map does not contain an ResultMap named Address Result Date: Fri, 13 Jun 2008 17:16:24 +0800 Message-ID: <kwalker@example.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: This SQL map does not contain an ResultMap named Address Result Thread-Index: AcjM+9rOkVR2C/ULTTS/7tDBcBlRPAAMrF4QAAHjlLA= References: <{{EMAIL+PHONE}}> <kwalker@example.com> <kwalker@example.com> From: <kwalker@example.com> To: <kwalker@example.com> X-OriginalArrivalTime: 13 Jun 2008 09:16:50.0013 (UTC) FILETIME=[362128D0:01C8CD36] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01C8CD36.2711F74E Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Fix by change=20 <sqlMap=20 namespace=3D"SIFM.Domain" to <sqlMap=20 namespace=3D"" Eric=20 =20 _____ =20 From: Eric Ye (GJJ7YYE)=20 Sent: Friday, June 13, 2008 4:24 PM To: kwalker@example.com Subject: This SQL map does not contain an ResultMap named Address Result Hi All, =20 I am just starting the IBatis.net by tailoring the tutorial sample. encountering one problem, program shows that: =20 This SQL map does not contain an ResultMap named Address Result=20 =20 ------_=_NextPart_001_01C8CD36.2711F74E Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.2900.3354" name=3DGENERATOR></HEAD> <BODY> <DIV dir=3Dltr align=3Dleft><FONT face=3D&#23435;&#20307; = color=3D#0000ff size=3D2><SPAN=20 class=3D809031609-13062008>Fix by change </SPAN></FONT></DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3D&#23435;&#20307; = color=3D#0000ff size=3D2>&lt;sqlMap=20 <BR>&nbsp;namespace=3D"SIFM.Domain"</FONT></DIV> <DIV><SPAN class=3D809031609-13062008><FONT face=3D&#23435;&#20307; = color=3D#0000ff=20 size=3D2>to</FONT></SPAN></DIV> <DIV><SPAN class=3D809031609-13062008><FONT face=3D&#23435;&#20307; = color=3D#0000ff size=3D2> <DIV dir=3Dltr align=3Dleft><FONT face=3D&#23435;&#20307; = color=3D#0000ff size=3D2>&lt;sqlMap=20 <BR>&nbsp;namespace=3D""</FONT></DIV></FONT></SPAN></DIV><!-- Converted = from text/rtf format --> <P><SPAN lang=3Den-us><FONT face=3DArial = size=3D2>Eric</FONT></SPAN><SPAN=20 lang=3Dzh-cn></SPAN> </P> <DIV>&nbsp;</DIV><BR> <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft> <HR tabIndex=3D-1> <FONT face=3DTahoma size=3D2><B>From:</B> Eric Ye (GJJ7YYE) = <BR><B>Sent:</B> Friday,=20 June 13, 2008 4:24 PM<BR><B>To:</B> = kwalker@example.com<BR><B>Subject:</B>=20 This SQL map does not contain an ResultMap named Address=20 Result<BR></FONT><BR></DIV> <DIV></DIV> <DIV><FONT face=3D&#23435;&#20307;><FONT color=3D#0000ff><FONT = size=3D2><SPAN=20 class=3D610582108-13062008>Hi All,</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=3D&#23435;&#20307;><FONT color=3D#0000ff><FONT = size=3D2><SPAN=20 class=3D610582108-13062008></SPAN></FONT></FONT></FONT>&nbsp;</DIV> <DIV><FONT face=3D&#23435;&#20307;><FONT color=3D#0000ff><FONT = size=3D2><SPAN=20 class=3D610582108-13062008>I&nbsp;am just starting the = IBatis.net&nbsp;by=20 tailoring the&nbsp;tutorial sample. encountering one problem, program = shows=20 that:</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=3D&#23435;&#20307;><FONT color=3D#0000ff><FONT = size=3D2><SPAN=20 class=3D610582108-13062008></SPAN></FONT></FONT></FONT>&nbsp;</DIV> <DIV><FONT size=3D+0><FONT size=3D+0><FONT face=3D&#23435;&#20307;><FONT = color=3D#0000ff><FONT=20 size=3D2><SPAN class=3D610582108-13062008>&nbsp;</SPAN>This SQL map does = not contain=20 an ResultMap named Address Result<SPAN=20 class=3D610582108-13062008>&nbsp;</SPAN></FONT></FONT></FONT></FONT></FON= T></DIV> <DIV><FONT size=3D+0><FONT size=3D+0><FONT face=3D&#23435;&#20307;><FONT = color=3D#0000ff><FONT=20 size=3D2><SPAN=20 class=3D610582108-13062008></SPAN></FONT></FONT></FONT></FONT></FONT>&nbs= p;</DIV></BODY></HTML> ------_=_NextPart_001_01C8CD36.2711F74E-- From userkwalker@example.com Fri Jun 13 13:14:56 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 86622 invoked from network); 13 Jun 2008 13:14:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 13 Jun 2008 13:14:56 -0000 Received: (qmail 31085 invoked by uid 500); 13 Jun 2008 13:14:58 -0000 Delivered-To: kwalker@example.com Received: (qmail 31061 invoked by uid 500); 13 Jun 2008 13:14:58 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 31050 invoked by uid 99); 13 Jun 2008 13:14:57 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jun 2008 06:14:57 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=HTML_FONT_FACE_BAD,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kwalker@example.com designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO rv-out-0708.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jun 2008 13:14:07 +0000 Received: by rv-out-0708.google.com with SMTP id b17so3768112rvf.36 for <kwalker@example.com>; Fri, 13 Jun 2008 06:14:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=pWOQXKJ4YKg2PEwyMaL84ockdy/hcYnCqXw0N98x+jk=; b=pQeOuo63b2kdEMGa7sL1ThvgOrlaB47eL2ldNca4tqZKaqmIxWWaONh9pWnCjVtATe U8rPiMPSCNbSCUxGjeRYkbfCvfAWr7SgKL80d/a6Wg30DJW346N/eX7JkQV+NAU+lJk+ xKFGXg8YA7FAh1XEGd4ogxGnnJ9VRQZFyG1lI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=sUUVdQCXt9HP64jz9+VYrEXBWbTTuZKeH64tyXaq8s6N0rtyXuoMLujZKP5Iug8UET laYn6Mz1ZzrGRDlXSY5gaJUsI0qFMDQ6Hg4DBYQiiSAaVyWyr7+HJ+7vidoIcIagKJML G9lfnfpi4VOqL7SbxitgazrolMonT3EK4akcY= Received: by 83.161.120.155 with SMTP id z1mr2975569waj.129.1213362864364; Fri, 13 Jun 2008 06:14:24 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Fri, 13 Jun 2008 06:14:24 -0700 (PDT) Message-ID: <kwalker@example.com> Date: Fri, 13 Jun 2008 08:14:24 -0500 From: "Michael Schall" <kwalker@example.com> To: kwalker@example.com Subject: Re: This SQL map does not contain an ResultMap named Address Result In-Reply-To: <kwalker@example.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_38899_4672490.1213362864368" References: <{{EMAIL+PHONE}}> <kwalker@example.com> <kwalker@example.com> <kwalker@example.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_38899_4672490.1213362864368 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline You might want to look at the useStatementNamespaces setting in your sqlmap.config. http://ibatis.apache.org/docs/dotnet/datamapper/ch04s03.html#id378950 On 6/13/08, kwalker@example.com <kwalker@example.com> wrote: > > Fix by change > <sqlMap > namespace="SIFM.Domain" > to > <sqlMap > namespace="" > > Eric > > > ------------------------------ > *From:* Eric Ye (GJJ7YYE) > *Sent:* Friday, June 13, 2008 4:24 PM > *To:* kwalker@example.com > *Subject:* This SQL map does not contain an ResultMap named Address Result > > Hi All, > > I am just starting the IBatis.net by tailoring the tutorial sample. > encountering one problem, program shows that: > > This SQL map does not contain an ResultMap named Address Result > > ------=_Part_38899_4672490.1213362864368 Content-Type: text/html; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit Content-Disposition: inline <p>You might want to look at the useStatementNamespaces setting in your sqlmap.config.</p><p><a href="http://ibatis.apache.org/docs/dotnet/datamapper/ch04s03.html#id378950">http://ibatis.apache.org/docs/dotnet/datamapper/ch04s03.html#id378950</a><br> </p><br><div><span class="gmail_quote">On 6/13/08, <b class="gmail_sendername"><a href="mailto:kwalker@example.com">kwalker@example.com</a></b> &lt;<a href="mailto:kwalker@example.com">kwalker@example.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex"> <div> <div dir="ltr" align="left"><font face="$BAWBN(B" color="#0000ff" size="2"><span>Fix by change </span></font></div> <div dir="ltr" align="left"><font face="$BAWBN(B" color="#0000ff" size="2">&lt;sqlMap <br>&nbsp;namespace=&quot;SIFM.Domain&quot;</font></div> <div><span><font face="$BAWBN(B" color="#0000ff" size="2">to</font></span></div> <div><span><font face="$BAWBN(B" color="#0000ff" size="2"> <div dir="ltr" align="left"><font face="$BAWBN(B" color="#0000ff" size="2">&lt;sqlMap <br>&nbsp;namespace=&quot;&quot;</font></div></font></span></div> <p><span lang="en-us"><font face="Arial" size="2">Eric</font></span> </p> <div>&nbsp;</div><br> <div lang="en-us" dir="ltr" align="left"> <hr> <font face="Tahoma" size="2"><b>From:</b> Eric Ye (GJJ7YYE) <br><b>Sent:</b> Friday, June 13, 2008 4:24 PM<br><b>To:</b> <a href="mailto:kwalker@example.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">kwalker@example.com</a><br><b>Subject:</b> This SQL map does not contain an ResultMap named Address Result<br></font><br></div><span class="q"> <div><font face="$BAWBN(B"><font color="#0000ff"><font size="2"><span>Hi All,</span></font></font></font></div> <div>&nbsp;</div> <div><font face="$BAWBN(B"><font color="#0000ff"><font size="2"><span>I&nbsp;am just starting the IBatis.net&nbsp;by tailoring the&nbsp;tutorial sample. encountering one problem, program shows that:</span></font></font></font></div> <div>&nbsp;</div> <div><font size="+0"><font size="+0"><font face="$BAWBN(B"><font color="#0000ff"><font size="2"><span>&nbsp;</span>This SQL map does not contain an ResultMap named Address Result<span>&nbsp;</span></font></font></font></font></font></div> <div>&nbsp;</div></span></div> </blockquote></div><br> ------=_Part_38899_4672490.1213362864368-- From userkwalker@example.com Fri Jun 13 17:22:50 2008 Return-Path: <userkwalker@example.com> Delivered-To: kwalker@example.com Received: (qmail 58408 invoked from network); 13 Jun 2008 17:22:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 13 Jun 2008 17:22:50 -0000 Received: (qmail 57703 invoked by uid 500); 13 Jun 2008 17:22:52 -0000 Delivered-To: kwalker@example.com Received: (qmail 57457 invoked by uid 500); 13 Jun 2008 17:22:52 -0000 Mailing-List: contact kwalker@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:kwalker@example.com> List-Unsubscribe: <mailto:kwalker@example.com> List-Post: <mailto:kwalker@example.com> List-Id: <user-cs.ibatis.apache.org> Reply-To: kwalker@example.com Delivered-To: mailing list kwalker@example.com Received: (qmail 57443 invoked by uid 99); 13 Jun 2008 17:22:52 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jun 2008 10:22:52 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kwalker@example.com designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO rv-out-0708.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jun 2008 17:22:03 +0000 Received: by rv-out-0708.google.com with SMTP id b17so3865568rvf.36 for <kwalker@example.com>; Fri, 13 Jun 2008 10:22:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=oekHhT7Qm3hQ9HbFya59R2eb7qMnV/7mEmrHHoC1v10=; b=Zp4irn+nW+nI52dD9Ht3OQflk7H0x0wzWbNFmibc/9zJ9Z2GmGv254LQjm6yJGymD7 vClRmvJZTQ6Z2aBMvqndPXwGWMVleB++HsYJMLaPddVbGhqIAFpzVkhkWFyipuXbsCxi dGH32MC0Mw6gHpjBYwZVEKtpdQGULP1D0U2XQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=xBdVpWJCfih08JvY79Ct7hEfD+CMpOYujxvLvGOsMs0FDtH+mT5VhED9FwhIwQQpar g68ZhIwY5e8uQIU3pIllnnr6kUuMi4e5HFQAikXslWXlpRU/pHB4w2Z1/MeUD4JIjkm3 GGQNSF5zUwQOIeJX3j/0M9I67OEqGFpNAj7rk= Received: by 83.161.120.155 with SMTP id a18mr3443331wae.127.1213377740810; Fri, 13 Jun 2008 10:22:20 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Fri, 13 Jun 2008 10:22:20 -0700 (PDT) Message-ID: <kwalker@example.com> Date: Fri, 13 Jun 2008 12:22:20 -0500 From: "Michael Schall" <kwalker@example.com> To: kwalker@example.com Subject: Re: Multiple ResultMap Support In-Reply-To: <kwalker@example.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_40481_14778508.1213377740798" References: <{{EMAIL+PHONE}}> <kwalker@example.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_40481_14778508.1213377740798 Content-Type: multipart/alternative; boundary="----=_Part_40482_4366621.1213377740799" ------=_Part_40482_4366621.1213377740799 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I dug into the code and found my issue. IBatisNet.DataMapper\MappedStatements\MappedStatement.cs internal IList RunQueryForList(RequestScope request, ISqlMapSession session, object parameterObject, IList resultObject, RowDelegate rowDelegate) A single IList is created and appended to, no matter how many resultsets are returned from the IDataReader. I attached a patch with 10 minutes worth of code that "works" for my scenerio as an example. It is not backwards compatible as it creates a list for each resultset. We would probably need a way to opt in to a list of lists. A quick idea could be the following. Does the Java version have/want anything like this? We should match their map syntax if they do... <select id="GetMultipleResultMap" resultMap="account[], address, category[]"> select * from accounts select * from addresses where addressId = 23 select * from categories </select> Also when creating empty list, why not create a generic list if we have the information to do so? I did that in the patch as well. Thoughts? Mike On 6/12/08, Michael Schall <kwalker@example.com> wrote: > > Sorry, I should have been more specific. I think my sql is fine. I'm > getting two resultsets back from sql server, but only one from queryForList. > The list that comes back has both accounts and categories objects in it > rather than a list with two elements ( a list of accounts and a list of > categories). Looking at the code, a single arraylist is created outside the > loop of resultsets and then all the objects from both sql resultsets are > added to the same list. > > Mike > > On 6/12/08, Ron Grabowski <kwalker@example.com> wrote: >> >> Try putting a semi-colon after the first select? >> >> ----- Original Message ---- >> From: Michael Schall <kwalker@example.com> >> To: kwalker@example.com >> Sent: Thursday, June 12, 2008 5:46:34 PM >> Subject: Multiple ResultMap Support >> >> I'm trying to use the multiple resultset support in one of my maps. I >> only receive one list of objects back. I expected a list of lists back. Is >> the following supported somehow? If not I suppose I could loop through and >> split the list by type myself. >> >> Thanks >> >> Mike >> >> <select id="GetMultipleResultMap" resultMap="account, category"> >> >> select * from accounts >> >> select * from categories >> >> </select> >> >> IList list = sqlMap.QueryForList("GetMultipleResultMap", null); >> >> IList<Account> accountList = list[0]; >> >> IList<Category> categoryList = list[1]; >> >> >> > ------=_Part_40482_4366621.1213377740799 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline <br>I dug into the code and found my issue.<br><br>IBatisNet.DataMapper\MappedStatements\MappedStatement.cs<br>internal IList RunQueryForList(RequestScope request, ISqlMapSession session, object parameterObject, IList resultObject, RowDelegate rowDelegate)<br> <p>A single IList is created and appended to, no matter how many resultsets are returned from the IDataReader. &nbsp;</p><p>I attached a patch with 10 minutes worth of code that &quot;works&quot; for my scenerio as an example. &nbsp;It is not backwards compatible as it creates a list for each resultset. &nbsp;We would probably need a way to opt in to a list of lists. &nbsp;A quick idea could be the following. &nbsp;Does the Java version have/want anything like this? &nbsp;We should match their map syntax if they do...<br> </p><p>&lt;select id=&quot;GetMultipleResultMap&quot; resultMap=&quot;account[], address, category[]&quot;&gt;<br><br>select * from accounts</p><p>select * from addresses where addressId = 23</p><p>select * from categories<br> <br>&lt;/select&gt;</p><p>Also when creating empty list, why not create a generic list if we have the information to do so? &nbsp;I did that in the patch as well.</p><p>Thoughts?</p><p>Mike</p><br><div><span class="gmail_quote">On 6/12/08, <b class="gmail_sendername">Michael Schall</b> &lt;<a href="mailto:kwalker@example.com">kwalker@example.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex"> <p>Sorry, I should have been more specific. &nbsp;I think my sql is fine. &nbsp;I&#39;m getting two resultsets back from sql server, but only one from queryForList. &nbsp;The list that comes back has both accounts and categories objects in it rather than a list with two elements ( a list of accounts and a list of categories). &nbsp;Looking at the code, a single arraylist is created outside the loop of resultsets and then all the objects from both sql resultsets are added to the same list.</p> <p>Mike<br></p><div><span class="e" id="q_11a7fb6a42d4a7ab_1"><br><div><span class="gmail_quote">On 6/12/08, <b class="gmail_sendername">Ron Grabowski</b> &lt;<a href="mailto:kwalker@example.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">kwalker@example.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex"> <div><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family:times new roman,new york,times,serif;font-size:12pt">Try putting a semi-colon after the first select?<div><span><br> <br><div style="font-family:times new roman,new york,times,serif;font-size:12pt">----- Original Message ----<br>From: Michael Schall &lt;<a href="mailto:kwalker@example.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">kwalker@example.com</a>&gt;<br> To: <a href="mailto:kwalker@example.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">kwalker@example.com</a><br>Sent: Thursday, June 12, 2008 5:46:34 PM<br>Subject: Multiple ResultMap
{'source': 'Apache Software Foundation Public Mail Archives'}