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 haven't had an opportunity to run a test yet but I am hoping someone can answer a quick question which is this:
If I have a database Connection object, setAutoCommit to false, execute 1 or more UPDATE statements, then execute a SELECT before invoking commit, will the SELECT return the database table values prior to the UPDATEs or will it return the updated table values?