Hello, My requirement is to place a query like:
SELECT a, b, c FROM my_table WHERE a IN (some_list) in the SQLMap. Now this 'some_list' can be an instance of java.util.List or java.util.Collection etc. I am not able to figure out how can I configure such a query. Can this be done by using some construct like: <!-- Assuming myResult etc. is defined --> <select id="getMyData" resultMap="myResult" parameterClass="what_to_put_here?"> SELECT a, b, c FROM my_table WHERE a IN (#what_to_put_here?#) </select> Any help will be greatly appreciated. Regards, Balwinder
