Hi Eric,
Sometimes it is not good to advice people when you don't know it fully
yourself. But this is how
i would do.
In normal JDBC i would achieve this by batchInsert. Similar is the case with
iBatis.
When executing in batch mode i do this.
try {
startTransaction();
startBatch();
for (int i = 0; i < dealerFrLines.length; i++) {
param.put("dealerFrLines", new Integer(dealerFrLines[i]));
insert("insertShopDFL", param);
}
executeBatch();
commitTransaction();
} finally {
endTransaction();
}
Rgds
Prashanth.
--- Eric Sheffer <[EMAIL PROTECTED]> wrote:
> 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
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com