Sorry for the delay in replying to folks. I appreciate the responses, but so far none have solved the problem.
Per Mike, I have placed each individual insert (there will be thousands of them) in its own transaction. I have not specified a isolation level; if someone thinks that could make a difference, please let me know. I also set incredibly long timeouts (like 2000 minutes) on the database connection, to test Russ's thought. Neither changed anything. The routine stopped inserting records after about the same amount of time. Anyone else have any thoughts on what might be happening, or how I might diagnose what's happening? -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
