First of all, thanks for developing iBATIS! It's very slick!
Perhaps I'm missing something, but I've been unable to find any
information about this question. I've searched through the
documentation and posts to the mailing list and I'm surprised this
question hasn't been asked yet: is it possible to pass as a parameter
to a SqlMap a list of like objects that the framework would then act on?
For example, I have an ArrayList of objects of type Widget. I'd
like to insert into the database a row for each object in the
collection. It seems like the only way to do that is to write code
to iterate over the collection and call a method like "insertWidget"
on an WidgetSqlMapDao.
A logical extension to this (for me, at least ;-) is to pass the
collection directly to iBATIS and let it do the iterating. In the
following example, if the Widget SqlMap is defined as:
<sqlmap id="Widget">
<typeAlias alias="widget" type="com.yoyodyne.domain.Widget"/>
<typeAlias alias="arrayList" type="java.util.ArrayList"/>
<parameterList id="widgetList" class="widget" type="arraylist"/>
<insert id="insertWidgets" parameterList="widgetList">
insert into WIDGET (WIDGET_ID, WIDGET_NAME, CATEGORY, PRICE)
values (WIDGET_SEQ.NEXTVAL, #widgetName#, #category#, #price#)
</insert>
</sqlmap>
the framework could handle the iterating knowing that its being
passed a list containing a collection of objects of type Widget.
The new <parameterList/> tag would define a list of a specific
type that contains instances of the specified class. The parameterList
attribute of the insert tag would tell the framework about the
list mapping and indicate that it is to iterate over the collection.
I suppose the use of type arrays (i.e. Widget[]) could be considered
as well.
Am I out in the weeds here? Can iBATIS do this now? Is there any
benefit to something like this? Drawbacks?
Anyway, again thanks for creating such a useful tool.
Eric
--
_______________________________________________
Search for businesses by name, location, or phone number. -Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10