You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Zoran Avtarovski <zo...@sparecreative.com> on 2009/06/23 07:04:18 UTC
N+1 Null value objects
I¹ve come across a problem I haven¹t seen for long time.
I¹m running an n+1 query. If the query returns no children I get a single
child object with null values.
I thought there was a way to prevent null value objects from being generated
by I can¹t remember how.
Does any of this sound familiar? If somebody could point out the solution to
my memory lapse I¹d be extremely grateful.
TIA
Z.
Re: N+1 Null value objects
Posted by Jeff Butler <je...@gmail.com>.
It was an oversight. I've updated the Apache site - it will be available
with the next site refresh (in about an hour).
Jeff Butler
On Tue, Jun 23, 2009 at 6:56 PM, Zoran Avtarovski
<zo...@sparecreative.com>wrote:
> Bingo. Thanks Jeff.
>
> Now the hard part, the DTD at http://ibatis.apache.org/dtd/sql-map-2.dtdhasn’t been updated 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 or
> should I point to a local version?
>
> Z.
>
>
> This maybe?
>
> http://issues.apache.org/jira/browse/IBATIS-375
>
> <http://issues.apache.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 for long time.
>
> I’m running an n+1 query. If the query returns no children I get a single
> child object with null values.
>
> I thought there was a way to prevent null value objects from being
> generated by I can’t remember how.
>
> Does any of this sound familiar? If somebody could point out the solution
> to my memory lapse I’d be extremely grateful.
>
> TIA
> Z.
>
>
>
>
>
Re: N+1 Null value objects
Posted by Zoran Avtarovski <zo...@sparecreative.com>.
Bingo. Thanks Jeff.
Now the hard part, the DTD at http://ibatis.apache.org/dtd/sql-map-2.dtd
hasn¹t been updated 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 or
should I point to a local version?
Z.
>
> This maybe?
>
> http://issues.apache.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 <zo...@sparecreative.com>
> wrote:
>> I¹ve come across a problem I haven¹t seen for long time.
>>
>> I¹m running an n+1 query. If the query returns no children I get a single
>> child object with null values.
>>
>> I thought there was a way to prevent null value objects from being generated
>> by I can¹t remember how.
>>
>> Does any of this sound familiar? If somebody could point out the solution to
>> my memory lapse I¹d be extremely grateful.
>>
>> TIA
>> Z.
>
>
Re: N+1 Null value objects
Posted by Jeff Butler <je...@gmail.com>.
This maybe?
http://issues.apache.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
<zo...@sparecreative.com>wrote:
> I’ve come across a problem I haven’t seen for long time.
>
> I’m running an n+1 query. If the query returns no children I get a single
> child object with null values.
>
> I thought there was a way to prevent null value objects from being
> generated by I can’t remember how.
>
> Does any of this sound familiar? If somebody could point out the solution
> to my memory lapse I’d be extremely grateful.
>
> TIA
> Z.
>
Re: N+1 Null value objects
Posted by David Brown <db...@sexingtechnologies.com>.
Hello, I just finished reading about N+1 in the IBatis doco. HTH.
----- Original Message -----
From: "Zoran Avtarovski" <zo...@sparecreative.com>
To: "iBatis Java Mail List" <us...@ibatis.apache.org>
Sent: Tuesday, June 23, 2009 12:04:18 AM GMT -06:00 US/Canada Central
Subject: N+1 Null value objects
I¹ve come across a problem I haven¹t seen for long time.
I¹m running an n+1 query. If the query returns no children I get a single
child object with null values.
I thought there was a way to prevent null value objects from being generated
by I can¹t remember how.
Does any of this sound familiar? If somebody could point out the solution to
my memory lapse I¹d be extremely grateful.
TIA
Z.