Hi,
Issue 1670 (https://mifos.dev.java.net/issues/show_bug.cgi?id=1670)
describes the problem:
If you pass a java.util.Collection as a query parameter using
Persistence.java, then the items
in the collection are not picked up in the query if you use them, say, in
a WHERE clause
(Eg: "where role_id in (:roles)" where :roles is an ArrayList)
This is because Persistence.setParametersInQuery
uses "query.setParameter()" instead of "query.setParameterList()" for
Collection parameters.
The patch fixes the problem by checking if the parameter is of type
Collection, and using
query.setParameterList appropriately. It also contains a testcase for the
same.
It has been applied and tested against mifos revision 12363.
Pramod Biligiri,
ThoughtWorks
P.S: Please ignore 3 leading path segments when applying the patch.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
