When we work in distributed systems where multiple databases are involved, we are required to use 2 phase commit protocol. 2 phase commit protocol is an atomic commitment protocol for distributed systems.
In the first phase, transaction manager sends commit-request to all the transaction resources. If all the transaction resources are OK, then transaction manager commits the transaction changes for all the resources. If any of the transaction resource responds as Abort, then the transaction manager can rollback all the transaction changes.
- What is the difference between execute, executequery, executeupdate?
- What is the difference between Statement and PreparedStatement in jdbc?
- How can we execute stored procedures and functions?
- How to rollback a JDBC transaction?
- Explain JDBC Savepoint.
- What is the use of blob and clob datatypes in JDBC?
- What is Connection Pooling?
- How do you implement connection pooling?
- What is 2 phase commit?
- What are the different types of locking in JDBC?
- What is a “dirty read”?