ive done like
<select id="selectAssgnResults"
resultMap="RschResult" parameterClass="java.util.List" >
select
<iterate open=" " close=" " conjunction=",">
#ll[]#</iterate>
from RSCH
</select>
and now it comments on the resultmap saying ivalid column name
--- Check the result mapping for the 'trackingIdC' property.
--- Cause: java.sql.SQLException: Invalid column name
you mean to build the query in java itself intsead of doing it here in the
sqlmap?
Regards
ram
Larry Meadors-2 wrote:
>
> you need to remap the results, and it's probably a better idea to
> build that string in java code anyway.
>
> Larry
>
>
> On 10/18/07, ramy <[EMAIL PROTECTED]> wrote:
>>
>> I have a list over which the select statement has to be run
>> my sql is like
>>
>> <select id="selectAssgnResults" parameterClass="java.util.List"
>>
>> resultMap="RschResult" >
>> select
>> <iterate property="reportData" open=" " close=" " conjunction=",">
>> $[]$
>>
>> </iterate>
>>
>> from RSCH
>>
>> </select>
>>
>>
>> It throws me an error
>>
>> --- Check the selectAssgnResults.
>> --- Check the parameter map.
>> --- Cause: com.ibatis.common.beans.ProbeException: Error getting ordinal
>> list from JavaBean. Cause java.lang.StringIndexOutOfBoundsException:
>> String
>> index out of range: -1
>>
>> --
>> View this message in context:
>> http://www.nabble.com/passing-a-list-to-sqlmap-tf4648784.html#a13280522
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/passing-a-list-to-sqlmap-tf4648784.html#a13281873
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
