IBATIS - multiple parameter

[Bruno Frascino]

Hello,

First time using ibatis. I am having problem trying to passe more than one parameter to my query.

I have got:

  
<resultMap id="userDetails"
class="pack.domain.BasicUserDetails">
  <result property="entity" column="entity" />
  <result property="employeeId" column="employee_id" />
  <result property="profileLogin" column="PROFILE_LOGIN" />
</resultMap>

 
 <select id="findByUserEmployee" parameterClass="java.util.Map" 
resultMap="userDetails">
 
SELECT 
i.entity,
i.employee_id, 
i.profile_login_lckd 
FROM MSF020 i
WHERE
i.entity = #userId#
AND
            i.employee_id = #employeeId#
 
</select>  

And my DAO implementation:

    
Map paramM = new HashMap();
paramM.put("userId", userId);
paramM.put("employeeId", employeeId);
 
List list = (List)this.getSqlMapClientTemplate().queryForList("findByUserEmployee", paramM);

It seems to be right, I get no error, but it is not because it doesn't return any record!! I think there is something to do with the multiple parameters, because when I hardcode one of the parameters (#employeeId# or #userId# ) it returns the data I need.

Any help!?

I also don't know how to enable the sql statements output, that could maybe help.

Thanks!

[Imre Tokai]

Here is an example for resultset:

<parameterMap id="resultSetParams" class="map" >
  <parameter property="USRNAME" jdbcType="VARCHAR" javaType="java.lang.String" mode="INOUT"/>
  <parameter property="PASSWORD" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
</parameterMap>
 
<resultMap id="getResult" class="ibatis.training.resultmaps.ResultSetResultMap">
    <result property="prf"  column="USRNAME" />
    <result property="pwd"  column="PASSWORD" />
    <result property="mail" column="EMAIL" />    
</resultMap>
 

<select id="resultMapSP" parameterMap="resultSetParams" resultMap="getResult">
  {call query}
</select>

Regards