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.
If I begin a transaction, (I am doing it with java, but I omit the code)
1 - I insert a value in a table
2 - now I try to insert a value in another table, I need the value I have Inserted before in table 1 because there is a referencial integrity.
3 I don't commit yet, Here is my question.
I can't see the values of any data (in a data browser) until I commit them Is the step 2 seeing the data inserted in 1, or Is step 2 going to complain about referencial integrity because It don't see any data until it is commited