ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Graeme J Sweeney <ibatis.u...@gjsweeney.com>
Subject Re: where with multiple where conditions.. ERROR
Date Mon, 11 Dec 2006 10:40:17 GMT
On Mon, 11 Dec 2006, Tommy Kristiansen wrote:

<snip/>

>            PinOrder pinorder =  (PinOrder)
> sqlMap.queryForObject("getLastPinOrder",fnr,partnerCode);

The signature for this is

queryForObject(String id,Object parameterObject, Object resultObject)

You appear to be passing 2 parameters. You need to modify your select to 
access the parameters e.g.

>      <select id="getLastPinOrder" resultClass="com.commfides.dao.PinOrder">

<select id="getLastPinOrder" resultClass="com.commfides.dao.PinOrder" 
parameterClass="Bean">

>                  WHERE FNR = #fnr#
>                  AND ID_PARTNER = #partnerCode#

where Bean has set/getFnr and set/getPartnerCode


-- 
Graeme -

Mime
View raw message