Ingmar Lötzsch wrote:
>
>> You don't need a custom TypeHandler. But perhaps you have to provide
> more information.
>
I get exception:
--- Check the company.company-result.
--- The error happened while setting a property on the result object.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: Error instantiating
collection property for mapping 'address'. Cause:
java.lang.ClassCastException:
I have Company.xml where is all typeAliases, resultMap, sql statement
I use useStatementNamespaces="true", so I must have <sqlMap
namespace="company">
DAO:
return getSqlMapClientTemplate().queryForList("company.getAll");
XML:
<select id="getAll" resultMap="company-result">
SELECT
c.company_id, c.companyname,
a.address_id, a.street
FROM hh_companies c
LEFT JOIN hh_addresses a ON c.address_id = a.address_id
</select>
** all companies have its addresses; no null values
<resultMap id="address-result" class="Address">
<result property="addressId" column="address_id" />
<result property="street" column="street" />
</resultMap>
<resultMap id="company-result" class="Company">
<result property="companyId" column="company_id" />
<result property="name" column="companyname" />
<result property="address" javaType="Address"
resultMap="company.address-result" />
</resultMap>
--
View this message in context:
http://www.nabble.com/-resultMap--related-objects-tp22845356p22847806.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
