[IBATISNET-301] QueryForList() method runs into intermittent databinding issues.

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: DataMapper 1.6.2
• Component/s: DataMapper
• Labels: class databind databinding datamapper entity timeout
• Environment: .Net 3.5 Framework; SQL2005; ASP.NET; Windows Server 2003
• Assignee: Unassigned
• Reporter: Lam Chan
• Created: 06/Feb/10 02:42
• Updated: 06/Feb/10 02:42

Description

I'm running into a databinding time out error with the DataMapper when using the IList version of QueryForList(). My SQL statement excutes fine and I receive no SQL exceptions. When I debug and walk through the entity class that the DataMapper is databinding the value against, it times out only on certain statements. I've walked through the entire databinding process and usually it will databind all of return result rows, but it just hangs and does not return the IList.

For example this fails:
<select id="Partsearch.Entity.Items_FindAllWithBrand" resultMap="PartialResultMap">
SELECT [ps].[Items].*
FROM [ps].[Items]
JOIN [ps].[Brands] ON [ps].[Items].[BrandID] = [ps].[Brands].[BrandID]
</select>

and this fails
<select id="Partsearch.Entity.Items_FindAll" resultMap="PartialResultMap">
SELECT [ps].[Items].*
FROM [ps].[Items]
</select>

but this works
<select id="Partsearch.Entity.Items_FindAllWithProductLineItem" resultMap="PartialResultMap">
SELECT [ps].[Items].*
FROM [ps].[Items]
JOIN [ps].[ProductLineItems] ON [ps].[Items].[ItemID] = [ps].[ProductLineItems].[ItemID]
</select>