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.
Is it permissible to use commit() and rollback() methods on the Connection object multiple times when setAutoCommit(false) is called initially on the Connection? For example: do some processing affecting several tables, call rollback(), do more processing on several tables, call commit(), and continue using the Connection like this for an unlimited number of transactions?