Paul, How does it compare to batch processing?
Zsolt >-----Original Message----- >From: Paul Benedict [mailto:[EMAIL PROTECTED] >Sent: Thursday, November 03, 2005 8:44 AM >To: user-java@ibatis.apache.org >Subject: Re: Bulk inserts > >Yes, > >SQL has a notation to INSERT multiple entries at once. >What you want to do is build a statement like the >following: > >INSERT INTO fruit (id, name) VALUES (0, 'Pear'), (1, >'Apple'), (2, 'Peach') > >Use the <iterate> tag to build the dynamic list at the >end. In this example, the GroceryBag object has a >property of Fruit[] called fruits: > ><insert id="insertFruit" parameterClass="GroceryBag"> > INSERT INTO fruit > (id, name) > VALUES > <iterate property="fruits" conjunction=","> > (#fruits[].id#, #fruits[].name#) > </iterate> ></insert> > > > > >__________________________________ >Yahoo! FareChase: Search multiple travel sites in one click. >http://farechase.yahoo.com
