Time to switch to WebSphere! (just kidding)
What's the database? What's your transaction configuration in iBATIS? Are you using an EXTERNAL transaction manager by any chance? If so, then the intermediate commits are ignored.
I just did a simple test of inserting 1,000,000 records with DB2 and HSQLDB. DB2 could handle it either way, HSQLDB could not - I got out of memory errors with HSQLDB.
I don't think the out of memory errors are coming from iBATIS. Probably something else is choking.
Jeff Butler
On 6/21/06, jaybytez <[EMAIL PROTECTED]> wrote:
Thank you very much for your help.
I did make the changes you mentioned in option 1. I also made sure that I
used no dot notation in my insert syntax. I am only updating two columns in
a table, but like I said, over 100,000 records. My insert is as simple as
this:
<insert id="batchInsertFacilityService"
parameterClass="foo.to.FacilityServiceTO">
<![CDATA[
INSERT INTO facility_service (provider_medicare_number,
facility_service_code)
VALUES (#medicareId#, #serviceCode#)
]]>
</insert>
I use the method below to commit every 100 records and WebLogic is still
running out of memory.
jay
--
View this message in context: http://www.nabble.com/executeBatch-not-returning-int-of-records-updated.-t1819686.html#a4980209
Sent from the iBATIS - User - Java forum at Nabble.com.
