mysql+ibatis-2.3.4.726 出错

Question

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82)
at com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult(ResultLoader.java:75)
at com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.loadResult(ResultLoader.java:57)
at com.ibatis.sqlmap.engine.mapping.result.ResultMap.getNestedSelectMappingValue(ResultMap.java:510)
at com.ibatis.sqlmap.engine.mapping.result.ResultMap.getResults(ResultMap.java:341)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:384)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:300)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:189)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82)
at com.ibatis.sqlmap.engine.mapping.result.loader.ResultLoader.getResult(ResultLoader.java:75)
出错

Answer 1

看看你的sql语句，以及接收查询结果的返回值和参数类型、数量上，可匹配

Answer 2

<resultMap id="basePersonalResult" class="basePersonal">
<result property="basePersonalId" column="base_personal_id"/>
<result property="basePersonalName" column="base_personal_name"/>
<result property="basePersonalSex" column="base_personal_sex"/>
<result property="basePositionId" column="base_position_id"/>
<result property="businessPhone" column="business_phone"/>
<result property="telephone" column="telephone"/>
<result property="eMail" column="e_mail"/>
<result property="qqNum" column="qq_num"/>
<result property="fax" column="fax"/>
<result property="microblog" column="microblog"/>
<result property="isAccessQqgroup" column="is_access_qqgroup"/>
<result property="baseEnterpriseId" column="base_enterprise_id"/>
<result property="createBy" column="create_by"/>
<result property="createTs" column="create_ts"/>
<result property="lastModifiedBy" column="last_modified_by"/>
<result property="lastModifiedTs" column="last_modified_ts"/>
<result property="deleteBy" column="delete_by"/>
<result property="deleteTs" column="delete_ts"/>
<result property="avaliableTab" column="avaliable_tab"/>

<result property="baseEntrantInfoVO" column="base_personal_id" select="selectBaseEntrantInfoByPersonalId"/>
<result property="basePositionVO" column="base_position_id" select="selectBasePosition"/>

</resultMap><resultMap id="baseEntrantInfoResult" class="baseEntrantInfo">
<result property="baseEntrantInfoId" column="base_entrant_info_id"/>
<result property="baseEnterpriseId" column="base_enterprise_id"/>
<result property="basePersonalId" column="base_personal_id"/>
<result property="basePositionId" column="base_position_id"/>
<result property="entrantTime" column="entrant_time"/>
<result property="leaveOfficeTime" column="leave_office_time"/>
<result property="createdBy" column="created_by"/>
<result property="createdTs" column="created_ts"/>
<result property="lastModifiedBy" column="last_modified_by"/>
<result property="lastModifiedTs" column="last_modified_ts"/>
<result property="avaliableTab" column="avaliable_tab"/>

<result property="baseEnterpriseVO" column="base_enterprise_id" select="selectBaseEnterprise"/>
</resultMap>
<select id="selectBaseEntrantInfoByPersonalId" parameterClass="string" resultMap="baseEntrantInfoResult">
select * from base_entrant_info where base_personal_id = #value# and avaliable_tab = '1'
</select>
<select id="selectBaseEnterprise" parameterClass="string" resultMap="baseEnterpriseResult">
select * from base_enterprise where base_enterprise_id = #value#
</select>
<resultMap id="baseEnterpriseResult" class="baseEnterprise">
<result property="baseEnterpriseId" column="base_enterprise_id"/>
<result property="enterpriseName" column="enterprise_name"/>
<result property="details" column="details"/>
<result property="enterpriseType" column="enterprise_type"/>
<result property="enterpriseAddress" column="enterprise_address"/>
<result property="enterprisePostcode" column="enterprise_postcode"/>
<result property="basePersonalId" column="base_personal_id"/>
<result property="enterpriseFax" column="enterprise_fax"/>
<result property="enterpriseMicrblog" column="enterprise_micrblog"/>
<result property="enterpriseUrl" column="enterprise_url"/>
<result property="quarter" column="quarter"/>
<result property="province" column="province"/>
<result property="city" column="city"/>
<result property="createBy" column="create_by"/>
<result property="createTs" column="create_ts"/>
<result property="lastModifiedBy" column="last_modified_by"/>
<result property="lastModifiedTs" column="last_modified_ts"/>
<result property="deleteBy" column="delete_by"/>
<result property="deleteTs" column="delete_ts"/>
<result property="avaliableTab" column="avaliable_tab"/>

<result property="basePersonalVO" column="base_personal_id" select="selectBasePersonal"/>
</resultMap> <result property="baseEnterpriseVO" column="base_enterprise_id" select="selectBaseEnterprise"/>查找顺序
通过base_personal_id字段找到 id="selectBaseEntrantInfoByPersonalId"的select语句
得到<resultMap id="baseEntrantInfoResult">
通过id="selectBaseEnterprise"查找 <result property="enterpriseName" column="enterprise_name"/>

Answer 3

<resultMap id="personalResultByMap" class="hashmap" extends="basePersonalResult">
    </resultMap>
    

<select id="selectBasePersonal" parameterClass="string" resultMap="basePersonalResult">
select * from base_personal where base_personal_id = #value#
</select>

<!--base_personal页: begin-->
    <sql id="pagingPersonalCriteria">
from base_personal a
        <dynamic prepend="where">
         <isNotPropertyAvailable prepend="and " property="avaliableTab">a.avaliable_tab = '1'
            </isNotPropertyAvailable>
            <isPropertyAvailable prepend="and " property="basePersonalName">a.base_personal_name like '%$basePersonalName$%'
            </isPropertyAvailable>
            <isPropertyAvailable prepend="and " property="basePersonalSex">a.base_personal_sex = #basePersonalSex#
            </isPropertyAvailable>
            <isPropertyAvailable prepend="and " property="baseEnterpriseId">(a.base_enterprise_id is #baseEnterpriseId# or a.base_enterprise_id = '')
            </isPropertyAvailable>
            <isPropertyAvailable prepend="and " property="EnterpriseId">a.base_enterprise_id = #EnterpriseId#
            </isPropertyAvailable>
            
        </dynamic>
    </sql>    <select id="pagingPersonalSelect" parameterClass="hashmap" resultMap="personalResultByMap">
        select  a.*
        <include refid="pagingPersonalCriteria"/>
        order by
        <isNotPropertyAvailable property="__sortingProperty">a.create_ts desc</isNotPropertyAvailable>
        <isEqual property="__sortingProperty" compareValue="basePersonalName">a.base_personal_name</isEqual>
        <isEqual property="__sortingProperty" compareValue="baseEnterpriseId">a.base_enterprise_id</isEqual>
        
        <include refid="__paginationLimit"/>
    </select>    <select id="pagingPersonalCount" parameterClass="hashmap" resultClass="int">
        select count(*) 
        <include refid="pagingPersonalCriteria"/>
    </select>