Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 99350 invoked from network); 23 Jun 2009 23:57:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 23 Jun 2009 23:57:12 -0000 Received: (qmail 96368 invoked by uid 500); 23 Jun 2009 23:57:22 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 96314 invoked by uid 500); 23 Jun 2009 23:57:22 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 96306 invoked by uid 99); 23 Jun 2009 23:57:22 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Jun 2009 23:57:22 +0000 X-ASF-Spam-Status: No, hits=4.0 required=10.0 tests=HTML_MESSAGE,MIME_QP_LONG_LINE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of zoran@sparecreative.com designates 150.101.158.37 as permitted sender) Received: from [150.101.158.37] (HELO conads.com) (150.101.158.37) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Jun 2009 23:57:11 +0000 Received: from [60.242.126.136] (account webhosting HELO sparecreative.com) by conads.com (CommuniGate Pro SMTP 5.2.11) with ESMTPA id 6539670 for user-java@ibatis.apache.org; Wed, 24 Jun 2009 09:56:45 +1000 Received: from [10.0.1.10] (account zoran [10.0.1.10] verified) by sparecreative.com (CommuniGate Pro SMTP 5.2.11) with ESMTPA id 2160149 for user-java@ibatis.apache.org; Wed, 24 Jun 2009 09:57:22 +1000 User-Agent: Microsoft-Entourage/11.4.0.080122 Date: Wed, 24 Jun 2009 09:56:43 +1000 Subject: Re: N+1 Null value objects From: Zoran Avtarovski To: iBatis Java Mail List Message-ID: Thread-Topic: N+1 Null value objects Thread-Index: Acn0XkIbgGP2SGBREd6NEQANkyympA== In-Reply-To: Mime-version: 1.0 Content-type: multipart/alternative; boundary="B_3328682203_15462904" X-Virus-Checked: Checked by ClamAV on apache.org > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3328682203_15462904 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable Bingo. Thanks Jeff. Now the hard part, the DTD at http://ibatis.apache.org/dtd/sql-map-2.dtd hasn=B9t been updated to include the notNullColumn property so Tomcat is complaining.=20 Do you know if it=B9s an oversight and the DTD is going to be updated or should I point to a local version? Z. >=20 > This maybe? >=20 > http://issues.apache.org/jira/browse/IBATIS-375 >=20 > Jeff Butler >=20 >=20 > On Tue, Jun 23, 2009 at 12:04 AM, Zoran Avtarovski > wrote: >> I=B9ve come across a problem I haven=B9t seen for long time. >>=20 >> I=B9m running an n+1 query. If the query returns no children I get a singl= e >> child object with null values. >>=20 >> I thought there was a way to prevent null value objects from being gener= ated >> by I can=B9t remember how. >>=20 >> Does any of this sound familiar? If somebody could point out the solutio= n to >> my memory lapse I=B9d be extremely grateful. >>=20 >> TIA >> Z.=20 >=20 >=20 --B_3328682203_15462904 Content-type: text/html; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable Re: N+1 Null value objects Bingo= . Thanks Jeff.

Now the hard part, the DTD at http://ibatis.apache.org/dtd/sql-map-2.dtd hasn’t been upd= ated to include the notNullColumn property so Tomcat is complaining.

Do you know if it’s an oversight and the DTD is going to be updated o= r should I point to a local version?

Z.

This maybe?

http://issues.apa= che.org/jira/browse/IBATIS-375

 <http://= issues.apache.org/jira/browse/IBATIS-375> Jeff Butler


On Tue, Jun 23, 2009 at 12:04 AM, Zoran Avtarovski <zoran@sparecreative.= com> wrote:
I’ve come across a problem I haven’t seen f= or long time.

I’m running an n+1 query. If the query returns no children I get a si= ngle child object with null values.

I thought there was a way to prevent null value objects from being generate= d by I can’t remember how.

Does any of this sound familiar? If somebody could point out the solution t= o my memory lapse I’d be extremely grateful.

TIA
Z.



--B_3328682203_15462904--