This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I am trying to process about 20,000 records. I will be making several calls per record with my database (an oracle database). My transaction times out way before I finish processing my records.
Can someone please advice me on how best to handle such a large volume of data without a time out. Kindly point me in the right direction on how best to handle such large records. I am attempting to see if i can process 400,000 records at a time. Help please.
P.s. I dont want to break my transaction into bits and pieces if i donot have to.
SCJP 1.4, SCWCD 1.4
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
- Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
Transaction timeouts are configurable. A Google search on "JTA timeout" may help you find out how to configure them for your environment; for example, this configuration reference came up first in the search results.