I am not sure you are grasping the concept here.
Both IB2 and IB3 can take any type of java.util.Map implementation as
a parameter.
Map<String, Object> parameters = new HashMap<String, Object>();
parameters.put("someNumber", Integer.valueOf(123));
parameters.put("someString", "hello");
Now use that parameter as the single parameter to any ibatis sqlmap client.
In IB3 you can use multiple named parameters but the above will still work.
I would really suggest reading the developers guide. This is all
covered in a very short pdf.
Nathan
On Mon, Apr 12, 2010 at 8:24 AM, mukhi <vkstudymater...@gmail.com> wrote:
>
> Thanks, but the parameter 'entryrefno' is of numeric type in my table. How
> can i pass two different types of values to Map at the same time?
> Please reply me. I am struck at this point.
>
>
>
> Nate Weiss wrote:
>>
>> Hi mukhi--
>>
>> I'm pretty new to this list, but I believe the general solution is to
>> make a HashMap and pass that in:
>>
>> Map params = new HashMap();
>> params.entryRefno= myEntryRefno;
>> params.someList = someList;
>> getSqlMapClientTemplate().insert("insertChoice", params);
>>
>> In iBatis 3 you also have the option of creating a mapper interface
>> class which allows you to pass in multiple params without a map.
>>
>>
>> On 4/11/2010 3:41 PM, mukhi wrote:
>>>
>>> I am using Spring with Ibatis. I want to pass a sting value and list to a
>>> query. How I can do that.
>>>
>>> My query is as follows
>>> INSERT INTO
>>> T_ENTRY_ANSWER_ASSOC( ENTRY_REFNO, CHOICE_REFNO )
>>>
>>> SELECT #entryRefno#,CHOICE_REFNO,
>>> FROM T_CHOICE
>>> WHERE CHOICE_REFNO IN ( 90,89,93,45,67)
>>>
>>>
>>>
>>> in the above query i need to pass two types of parameters.
>>> 1. Sting
>>> 2.list of values in where clause.
>>>
>>> How can i do it?
>>>
>>>
>>> What kind of parameter I can pass to call the query. while making call
>>>
>>> getSqlMapClientTemplate().insert("insertChoice", What parameter goes
>>> here?);
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
>> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>>
>>
>>
>
> --
> View this message in context:
> http://old.nabble.com/how-to-pass-two-different-types-of-values-to-query-in-IBATIS-tp28211187p28218461.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
