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.
Actually i am using one connection, and im adding all statements to batch ( statement.addBatch(); ).
For every 1000 statements im executing batach. If something happens wrong thn it should rollback everything.