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
