Is it possible to pass a 2nd custom/standard class
through a queryForObject() or queryForList() ? Or do I
have to combine both objects under a Collection before
sending it in ? I would want to use certain properties
from the 2nd class to aid the 1st in a join, like
shown below:
<resultMap id="tableAResult" class="objectA">
...
</resultMap>
<select id="anId" resultMap="tableAResult"
parameterClass="objectA">
select TableA.field1, TableA.field2
from TableA, TableB
where TableA.field3 = TableB.field1
and TableA.field4 = #propertyOfObjectA#
and TableB.field2 = #someStringNotPartofObjectA#
</select>
How is this acheived ?
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs