Suggested Pages

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

Suggested Pages