May 5th, 2010, 02:05 PM
StoredProcedure execution in spring
My requirement is:
I have a list of employees(in an ArrayList or Array, got it from some other system) whom i should filter out based on certain filter conditions. The number of employees can not be passed to IN clause, because the number can vary from 500 to 3000. So i thought of using stored procedure.
How to use Spring StoredProcedure class to pass:
1. Query that should be executed in stored proc is constructed dynamically.
2. Parameters that should be used in dynamic constructed query where clauses.
3. Input as the list of employees.
The out put expected is filtered list/array of employees.
How to use Spring StoredProcedure in the above case.