Support for arrays or list parameter using "IN" keyword
-------------------------------------------------------
Key: IBATIS-38
URL: http://nagoya.apache.org/jira/browse/IBATIS-38
Project: iBatis for Java
Type: New Feature
Components: SQL Maps
Environment: Any
Reporter: Walter So
Priority: Minor
I have a need for the following kind of query:
<select id="getAmount" parameterClass="java.util.List" >
select
ID, AMOUNT
from
TABLE
where ID IN (#ids#)
</select>
To generate:
select ID, AMOUNT from TABLE where ID IN (1001, 1002, 1003, 1004)
#ids# can also be int[], String[] or Object[] array. Will there be any support
for these kinds of parameters? Thanks.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
