Featured Post

NoSQL use cases

Here are a simple summary of use cases for Cassandra, MongoDB and Redis MongoDB Storing Log Data Speed is the primary perfor...

Tuesday, July 31, 2012

Transaction Commit and Transaction Rollback

A transaction has only two ways to end: commit or rollback. If you don't commit or rolls back explicitly, the transaction remains alive and it may holds locks (exclusive lock).
Then when the connection is closed by the client, the transaction will commit or roll back depending on how the vendor implements the JDBC specification that doen't say nothing about it.
For example Oracle driver commits on closed connection.

No comments :

Post a Comment