Mapping is missing column attribute for prop

Posted on | In |

Error Information:
org.apache.ibatis.exceptions.PersistenceException:
### Error building SqlSession.
### The error may exist in com/github/dao/DepartmentMapper.xml
### The error occurred while processing mapper_resultMap[MyDept]_collection[list]
### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration.
Cause:org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML.
Cause: java.lang.IllegalStateException: Mapping is missing column attribute for property null

Error Cause:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<resultMap type="com.github.bean.Department" id="MyDept">
		<id column="did" property="id" />
		<result column="dept_name" property="departmentName" />
		<collection property="list" ofType="com.github.bean.Employee">
			<id column="eid" property="id" />
			<result column="last_name" property="lastName" />
			<result column="gender" property="gender" />
			<result column="email" property="email" />
			<result />  <!-- why is it here, so lonely? No syntax error -->
		</collection>
	</resultMap>  
	<select id="getDepByIdPlus" resultMap="MyDept">
		select d.id as did,dept_name,e.id as eid,last_name,gender,email
		from tbl_employee e,tbl_dept d
		where d.id=e.d_id and d.id=#{id}
	</select>