ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kris Rasmussen <kristapes...@yahoo.com>
Subject Re: lazy-loading=off problems
Date Sun, 06 Feb 2005 07:26:03 GMT
I guess writting things out help, I saw the problem right after sending it. I am fetching the
parent and the child in the same map.

Kris Rasmussen <kristapestry@yahoo.com> wrote:
I have table with a parent child relationship. I have been trying to figure out why so many
database calls are being made because it appears that there are more than there should each
time a web page loads. I tryed turning off lazy-loading because I thought it might not be
working, but when i did I quickly overflowed the stack and the number of sql queries went
from about 19 to 600.
If my table only has 6 rows in it and there are definatly no loops in the paret child relationships
then I don't know how this many queries could be possible.
Any ideas what is going on?
Here is my code...
<resultMap id="getPageResult" class="page">
<result property="siteId" column="page.SiteId"/>
<result property="pageId" column="page.PageId"/>
<result property="parentPageId" column="page.ParentPageId"/>
<result property="title" column="page.Title"/>
<result property="subPages" column="{siteId=page.siteId,pageId=page.PageId}" select="getPagesByParentId"/>
<result property="parentPage" column="{siteId=page.siteId,pageId=page.ParentPageId}" select="getPage"/>
<select id="getPagesByParentId" resultMap="getPageResult">
SELECT page.* FROM page WHERE page.SiteId = #siteId# AND page.ParentPageId = #pageId# ORDER
BY page.DisplayOrder

<select id="getPage"  resultMap="getPageResult">
SELECT page.* FROM page WHERE SiteId=#siteId# AND PageId=#pageId#

Do you Yahoo!?
All your favorites on one personal page  Try My Yahoo!
Do you Yahoo!?
 The all-new My Yahoo!  What will yours do?
View raw message