Re: parameter map

[Mark Bennett]

You may have already figured it out by now but he said to set the "resultClass" to string.

Mark

On 1/10/06, Tony Qian < [EMAIL PROTECTED]> wrote:

radha rukmani wrote on 1/9/2006, 11:04 AM:

Thanks Beekman,

It works if it is set as a String.

So, you can pass in more than one parameters if you set the parameterClass="string". How so?

thanks,
Tony

 

Niels Beekman <[EMAIL PROTECTED]> wrote:

Try setting resultClass to "String", you told iBATIS already that you want a List by using queryForList().

 

---

From: radha rukmani [mailto:[EMAIL PROTECTED]]
Sent: maandag 9 januari 2006 16:35
To: user-java@ibatis.apache.org
Subject: parameter map

 

Hi

 

I am trying to pass some parameters into the select statement.

 

My select statement in ibatis, is like this.

< select id ="getTransferPendingPlates" parameterClass ="java.util.Map" resultClass="java.util.List" >

SELECT

GBL_PLATE_BAR_CODE

FROM GTN_FERT_PLATE

WHERE LOCATION_STATUS=#locationStatus#

AND

TRANSFER_STATUS=#transferStatus#

</ select>

 

And i am calling this from the java class, like this.

 

  parameterMap.put("transferStatus",TRANSFER_STATUS_PENDING);
  parameterMap.put("locationStatus",LOCATION_STATUS_PERMANENT);
  try{
   pendingPlates = (List)sqlMap.queryForList("getTransferPendingPlates",parameterMap);
  }catch(Exception e)

Now my pendingPlates list shows an empty list of strings. but if i run the same query in oracle, i get some result. What am i doing wrong. Could any one please help

 

Thanks.

---

Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.

---

Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.