click below
click below
Normal Size Small Size show me how
OCPJP709.4
Cert Obj JDBC Transactions
[9.4.1]JDBC support for transactions includes three concepts 1) | All transactions are in auto-commit mode unless explicitly disabled. |
[9.4.2]JDBC support for transactions includes three concepts 2) | Transactions have varying levels of isolation—that is, what data is visible to the code executing in a transaction. |
[9.4.3]JDBC support for transactions includes three concepts 3) | JDBC supports savepoint. A savepoint is a point within a transaction where the work that occurred up until that point is valid. A savepoint is useful when conditions in a transaction must be preserved even if other parts of the transaction fail. |
[9.4.4]Starting a Transaction Context in JDBC | JDBC driver or the database determines when to start a transaction and when to commit an existing transaction. |
[9.4.5] Performing transactions | A transaction is a set of SQL operations that needs to be either executed all successfully or not at all. Failure to perform even one operation leads to an inconsistent and erroneous database. |
[9.4.6]ACID | Atomic, Consistent, Isolated, Durable |
[9.4.7] |