Uploaded image for project: 'iBatis for .NET'
  1. iBatis for .NET
  2. IBATISNET-301

QueryForList() method runs into intermittent databinding issues.

    XMLWordPrintableJSON

    Details

      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>

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lamchakchan Lam Chan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: