Are the productcategory id’s = unique? queryForMap() will use that as a key, so if all id’s are the same, = map.size() will be 1.

From: Firas = A. [mailto:ofbiz@idigna.com]
Sent: woensdag 10 mei = 2006 8:25
To: user-java@ibatis.apache.org
Subject: RE: queryForMap = returning zero results

Thanks Niels for your = answer.

I'm affraid I haven't been completely correct in my description of the issue. Sorry about that. queryForMap does actually = return 1 (one) value, the last row in the resultset. About accessor methods: = I do have getProductCategoryId()= and setProductCategoryId(S= tring productCategoryId) in ProductCategory = class.

But why queryForMap returns only the last row = from the resultset?

Thanks again!

</Firas>

From: Niels Beekman [mailto:n.beekman@wis.nl] =
Sent: den 9 maj 2006 = 20:28
To: user-java@ibatis.apache.org
Subject: RE: queryForMap = returning zero results

That’s very strange, since queryForMap() uses queryForList() internally. Is there a proper getter = in class ‘com.mycompany.ecommerce.ProductCategory’ for the ‘productCategoryId’ property?

Niels

From: Firas = A. [mailto:ofbiz@idigna.com]
Sent: dinsdag 9 mei 2006 = 20:05
To: user-java@ibatis.apache.org
Subject: queryForMap = returning zero results

Hello everybody!

I'm getting zero results when using queryForMap. Whith queryForList I = get the correct results.

----- = SQLMap -----
<resultMap id=3D"listOfCategories" class=3D"com.mycompany.ecommerce.ProductCategory">
        <result column=3D"product_category_id" = property=3D"productCategoryId" jdbcType=3D"VARCHAR" />
        <result column=3D"parent_category_id" = property=3D"parentCategoryId" jdbcType=3D"VARCHAR" />
        <result column=3D"category_name" property=3D"categoryName" jdbcType=3D"VARCHAR" />
</resultMap>

<select id=3D"listAvailableCategories" resultMap=3D"listOfCategories">
        SELECT
            &= nbsp; product_category_id,
            &= nbsp; parent_category_id,
            &= nbsp; category_name
        FROM = product_category
</select>

----- = Java -----
public Map listAvailableCategories() throws SQLException {
        Map prodCatRel =3D = sqlMapClient.queryForMap("listAvailableCategories", null, "productCategoryId");
        return prodCatRel;
}

In the logging output I can clearly see that there are several rows in = the resultset, but = prodCatRel.size()=3D=3D0.

Anybody have an = idea?

Thanks for your = time!

</Firas>