Larry Meadors wrote:
Use t his instead:
<select
id="searchAssets"
parameterClass="com.mafoi.assetregister.core.Search"
resultClass="java.util.HashMap"
remapResults="true">
My guess is that your tests are reloading the sql map each tim, so the
results are being mapped each time. In your app, that is not the case.
Adding remapResults="true" will make it so.
Be aware that this could cause a noticable performance degradation. If
this query needs to run fast, find a way to make it return the same
results (into a bean) every time you run it.
Yes, I have made some changes to the query to return the same results.
It was only one property so it wasn't too much of a problem. Thanks a lot!
Regards,
Vamsee.
